Welcome Guest, Not a member yet? Register   Sign In
How to Print Single Name
#1

(This post was last modified: 07-30-2021, 01:46 AM by InsiteFX. Edit Reason: I fixed it for you next time please use the editor code tags on the menu )

Help me out to fetch only single store Data to below mentioned SQL queries

Code:
select
affiliateURL as url,
`store`.`name`
from
`store`
inner join
`store_coupon_junction` as `scj` on `store`.`id` = `scj`.`storeId` and `scj`.`storeCouponRank` >= 0
inner join
`category_coupon_junction` as `ccj` on `scj`.`couponId` = `ccj`.`couponId` and `ccj`.`categoryCouponRank` >= 0
inner join
`category` on `ccj`.`categoryId` = `category`.`id` and `category`.`active` = 1
inner join
`coupon` on `scj`.`couponId` = `coupon`.`id` and `coupon`.`active` = 1 and `coupon`.`type` != ''
where
`store`.`active` = 1
order by
`store`.`rank` desc
Reply


Messages In This Thread
How to Print Single Name - by Zouton - 05-19-2021, 04:54 AM
RE: How to Print Single Name - by craig - 05-19-2021, 06:25 AM
RE: How to Print Single Name - by includebeer - 05-19-2021, 04:14 PM
RE: How to Print Single Name - by PromoCoupons - 07-29-2021, 10:14 AM
RE: How to Print Single Name - by ojmichael - 07-29-2021, 11:58 PM



Theme © iAndrew 2016 - Forum software by © MyBB