SELECT `engine4_emultlist_listings`.*, `engine4_core_locations`.`lat`, `engine4_core_locations`.`lng` FROM `engine4_emultlist_listings`
 LEFT JOIN `engine4_core_locations` ON engine4_core_locations.resource_id = engine4_emultlist_listings.listing_id AND engine4_core_locations.resource_type = "listing"  WHERE (engine4_emultlist_listings.owner_id <> 0) AND (engine4_emultlist_listings.category_id =515) AND (engine4_emultlist_listings.publish_date <= '2026-07-16 05:41:09' OR engine4_emultlist_listings.publish_date = '') AND (engine4_emultlist_listings.is_approved = '1') AND (engine4_emultlist_listings.draft = '') AND (engine4_emultlist_listings.search = '1') ORDER BY `engine4_emultlist_listings`.`creation_date` DESC