RE/MAX Collection – Luxury Properties

PAGE?select *, 1 as firstSort, IF(num_photos > 0,1,0) as secondSort from wp_remax_ucwre_listing_search where interaction_id LIKE '%22106700%' ORDER BY firstSort desc, secondSort desc,price desc LIMIT 0,21 ;