Furniture Category Listings in Miami Fl Usa

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 '%Miami fl usa%' OR l.state LIKE '%Miami fl usa%') AND l.category LIKE '%Furniture%' 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 '%Miami fl usa%' OR pprovince LIKE '%Miami fl usa%') AND category LIKE '%Furniture%' ) AS combined ORDER BY (pmt_cpn IS NOT NULL) DESC, gtot_amt DESC, updated_at DESC LIMIT 27 OFFSET 0