Vacationtour Packages Category Listings in Ajmer
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 '%Ajmer%' OR l.state LIKE '%Ajmer%') AND l.category LIKE '%Vacationtour Packages%'
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 '%Ajmer%' OR pprovince LIKE '%Ajmer%') AND category LIKE '%Vacationtour Packages%'
ORDER BY pmt_cpn DESC, updated_at DESC
LIMIT 27 OFFSET 27