WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND xpaw_wdk_membership_agency_agent.agent_id = `xpaw_wdk_listings`.`user_id_...' at line 3]
SELECT DISTINCT xpaw_wdk_listings.post_id, xpaw_wdk_listings.*, xpaw_posts.*,xpaw_wdk_listings_fields.*,xpaw_wdk_listings_fields.post_id AS fields_post_id, location_table.location_title, category_table.category_title,xpaw_wdk_users.* FROM xpaw_posts LEFT JOIN xpaw_wdk_listings ON xpaw_wdk_listings.post_id = xpaw_posts.ID LEFT JOIN xpaw_wdk_listings_fields ON xpaw_wdk_listings.post_id = xpaw_wdk_listings_fields.post_id LEFT JOIN xpaw_wdk_users ON xpaw_wdk_users.cacheduser_user_id = xpaw_wdk_listings.user_id_editor LEFT JOIN xpaw_wdk_locations AS location_table ON xpaw_wdk_listings.location_id = location_table.idlocation LEFT JOIN xpaw_wdk_categories AS category_table ON xpaw_wdk_listings.category_id = category_table.idcategory LEFT JOIN xpaw_wdk_listings_users ON xpaw_wdk_listings.post_id = xpaw_wdk_listings_users.post_id LEFT JOIN xpaw_wdk_membership_agency_agent ON (xpaw_wdk_membership_agency_agent.agency_id = AND xpaw_wdk_membership_agency_agent.agent_id = `xpaw_wdk_listings`.`user_id_editor` AND xpaw_wdk_membership_agency_agent.status = "CONFIRMED") WHERE xpaw_posts.post_type = 'wdk-listing' AND `xpaw_wdk_listings`.`is_activated` = '1' AND `xpaw_wdk_listings`.`is_approved` = '1' ORDER BY xpaw_wdk_listings.post_id desc, xpaw_wdk_listings.post_id DESC LIMIT 3