Home Decorations Category Listings in Pakistan
SELECT
l.id,l.category,l.subcategory,l.transaction_type,l.title,
NULLIF(TRIM(l.city),'') city,
NULLIF(TRIM(l.state),'') state,
NULLIF(TRIM(l.country),'') country,
l.currency,l.price,l.pkg,l.pmt_cpn,
l.updated_at,
'listings' src,
adstatus
:==:
WHERE l.status='verified' AND (l.city LIKE '%Pakistan%' OR l.state LIKE '%Pakistan%') AND l.category LIKE '%Home Decorations%'
ORDER BY l.pmt_cpn DESC, l.updated_at DESC
LIMIT 27 OFFSET 27
/:==:/
SELECT
id,category,'' subcategory,'' transaction_type,
pprovince title,
pcity city,'' state,pcountry country,
'' currency,
price,pkg,pmt_cpn,
updated_at,
'classifieds' src,
adstatus,
imglnk_0,imglnk_1,imglnk_2,imglnk_3,imglnk_4,imglnk_5
:==:
WHERE adstatus NOT IN (0,9) AND (pcity LIKE '%Pakistan%' OR pprovince LIKE '%Pakistan%') AND category LIKE '%Home Decorations%'
ORDER BY pmt_cpn DESC, updated_at DESC
LIMIT 27 OFFSET 27