Beauty Salon & Spa Category Listings in Mehsana

SELECT * FROM ( 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.gtot_amt gtot_amt, l.updated_at, 'listings' src, adstatus, NULL imglnk_0,NULL imglnk_1,NULL imglnk_2, NULL imglnk_3,NULL imglnk_4,NULL imglnk_5 :==: WHERE l.status='verified' AND (l.city LIKE '%Mehsana%' OR l.state LIKE '%Mehsana%') AND l.category LIKE '%Beauty Salon & Spa%' UNION ALL SELECT id,category,'' subcategory,'' transaction_type, pprovince title, pcity city,'' state,pcountry country, '' currency, price,pkg,pmt_cpn,gtot_amt, 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 '%Mehsana%' OR pprovince LIKE '%Mehsana%') AND category LIKE '%Beauty Salon & Spa%' ) AS combined ORDER BY (pmt_cpn IS NOT NULL) DESC, gtot_amt DESC, updated_at DESC LIMIT 27 OFFSET 0