select a.*, (select name from listing_type where id=a.listing_type_id) as type_name, (select link_name from listing_type where id=a.listing_type_id) as type_link_name, (select id from listing_subtype where id=a.listing_subtype_id) as subtype_id, (select name from listing_subtype where id=a.listing_subtype_id) as subtype_name, (select link_name from listing_subtype where id=a.listing_subtype_id) as subtype_link_name, (select id from listing_subsubtype where id=a.listing_subsubtype_id) as subsubtype_id, (select name from listing_subsubtype where id=a.listing_subsubtype_id) as subsubtype_name, (select link_name from listing_subsubtype where id=a.listing_subsubtype_id) as subsubtype_link_name, (select name from listing_category where id=(select t2.listing_category_id from listing_category_link as t2 where t2.source='listing' and t2.record_id=a.id and t2.status=1 order by t2.id desc limit 1)) as region, (select name from listing_subcategory where id=(select t3.listing_subcategory_id from listing_subcategory_link as t3 where t3.source='listing' and t3.record_id=a.id and t3.status=1 order by t3.id desc limit 1) and listing_category_id=(select t2.listing_category_id from listing_category_link as t2 where t2.source='listing' and t2.record_id=a.id and t2.status=1 order by t2.id desc limit 1)) as sub_region, (select name from listing_subsubcategory where id=(select t4.listing_subsubcategory_id from listing_subsubcategory_link as t4 where t4.source='listing' and t4.record_id=a.id and t4.status=1 order by t4.id desc limit 1) and listing_subcategory_id=(select t3.listing_subcategory_id from listing_subcategory_link as t3 where t3.source='listing' and t3.record_id=a.id and t3.status=1 order by t3.id desc limit 1) and listing_category_id=(select t2.listing_category_id from listing_category_link as t2 where t2.source='listing' and t2.record_id=a.id and t2.status=1 order by t2.id desc limit 1)) as town, (select link_name from listing_category where id=(select t2.listing_category_id from listing_category_link as t2 where t2.source='listing' and t2.record_id=a.id and t2.status=1 order by t2.id desc limit 1)) as region_link_name, (select link_name from listing_subcategory where id=(select t3.listing_subcategory_id from listing_subcategory_link as t3 where t3.source='listing' and t3.record_id=a.id and t3.status=1 order by t3.id desc limit 1) and listing_category_id=(select t2.listing_category_id from listing_category_link as t2 where t2.source='listing' and t2.record_id=a.id and t2.status=1 order by t2.id desc limit 1)) as sub_region_link_name, (select link_name from listing_subsubcategory where id=(select t4.listing_subsubcategory_id from listing_subsubcategory_link as t4 where t4.source='listing' and t4.record_id=a.id and t4.status=1 order by t4.id desc limit 1) and listing_subcategory_id=(select t3.listing_subcategory_id from listing_subcategory_link as t3 where t3.source='listing' and t3.record_id=a.id and t3.status=1 order by t3.id desc limit 1) and listing_category_id=(select t2.listing_category_id from listing_category_link as t2 where t2.source='listing' and t2.record_id=a.id and t2.status=1 order by t2.id desc limit 1)) as town_link_name, (select name from file where source='listing' and record_id=a.id and type='image' and status='enabled' order by sequence asc limit 1) as image from listing as a where (select status from user_link where source='listing' and user_id=26 and record_id=a.id)=1 and (a.name like '%%' or (select name from listing_type where id=a.listing_type_id) like '%%' or (select name from listing_subtype where id=a.listing_subtype_id) like '%%' or (SELECT name FROM listing_subcategory WHERE id=(select t3.listing_subcategory_id from listing_subcategory_link as t3 where t3.source='listing' and t3.record_id=a.id and t3.status=1 order by t3.id desc limit 1) AND listing_category_id=(select t2.listing_category_id from listing_category_link as t2 where t2.source='listing' and t2.record_id=a.id and t2.status=1 order by t2.id desc limit 1)) like '%%' or (SELECT name FROM listing_subsubcategory WHERE id=(select t4.listing_subsubcategory_id from listing_subsubcategory_link as t4 where t4.source='listing' and t4.record_id=a.id and t4.status=1 order by t4.id desc limit 1) AND listing_subcategory_id=(select t3.listing_subcategory_id from listing_subcategory_link as t3 where t3.source='listing' and t3.record_id=a.id and t3.status=1 order by t3.id desc limit 1) AND listing_category_id=(select t2.listing_category_id from listing_category_link as t2 where t2.source='listing' and t2.record_id=a.id and t2.status=1 order by t2.id desc limit 1)) like '%%') AND status='enabled'order by rand()