SELECT listings.*, states.*, suburbs.*, areas.*, types.*, statuses.*, users.user_telephone,GROUP_CONCAT(DISTINCT level_name_en ORDER BY levels.level_order ASC SEPARATOR ', ') AS level_name_en, level_order FROM (((((((levels INNER JOIN listing_levels ON levels.level_id = listing_levels.level_id) LEFT JOIN listings ON listing_levels.level_listing_id = listings.listing_id LEFT JOIN users ON listings.listing_user_id = users.user_id) LEFT JOIN contacts ON listings.listing_contact_id = contacts.contact_id) LEFT JOIN types ON listings.listing_type_id = types.type_id) LEFT JOIN statuses ON listings.listing_status_id = statuses.status_id) LEFT JOIN states ON listings.listing_state_id = states.state_id) LEFT JOIN suburbs ON listings.listing_suburb_id = suburbs.suburb_id) LEFT JOIN areas ON listings.listing_area_id = areas.area_id WHERE listing_date_deleted IS NULL AND listing_web_enabled = TRUE AND listing_id = '1026' AND listing_id NOT IN (SELECT listings.listing_id FROM listings LEFT JOIN listing_characteristics ON listings.listing_id = listing_characteristics.characteristic_listing_id WHERE listing_characteristics.characteristic_id = 124) LIMIT 1