SELECT
                    realestates.id,
                    realestates.id AS code,
                    realestates.status,
                    realestates.top_offer,
                    realestates.lease,
                    realestates.sold,
                    realestates.title,
                    t1.val AS title_trans,
                    realestates.description,
                    realestates.description_full,
                    realestates.highlight,
                    realestates.id_region,
                    spt_regions.name AS region_name,
                    t2.val AS region_name_trans,                    
                    realestates.id_type,
                    spt_types.name AS type_name,
                    t3.val AS type_name_trans,
                    realestates.city,
                    realestates.city_nearby,
                    realestates.njuskalo_location_id,
                    realestates.address,
                    realestates.area_bruto,
                    realestates.area_neto,
                    realestates.area_land,
                    realestates.area_living,
                    realestates.num_room,
                    realestates.num_bathroom,
                    realestates.num_wc,
                    realestates.floor,
                    realestates.floor AS floor_id_opt,
                    realestates.num_floors,
                    realestates.year_build,
                    realestates.year_adaptation,
                    realestates.price_from,
                    realestates.google_map,
                    realestates.map_pin,
                    realestates.youtube_url,
                    realestates.addTime,
                    realestates_seo.id AS id_seo,
                    realestates_seo.slug,
                    realestates_seo.title AS seo_title,
                    realestates_seo.description AS seo_description,
                    (0) AS relevance 
                    FROM realestates 
                    LEFT JOIN translations t1 ON (t1.table_name LIKE 'realestates' AND t1.table_col LIKE 'title' AND t1.table_id = realestates.id)
                    LEFT JOIN spt_regions ON (realestates.id_region = spt_regions.id)
                    LEFT JOIN translations t2 ON (t2.table_name LIKE 'spt_regions' AND t2.table_col LIKE 'name' AND t2.table_id = spt_regions.id)                    
                    LEFT JOIN spt_types ON (realestates.id_type = spt_types.id)
                    LEFT JOIN translations t3 ON (t3.table_name LIKE 'spt_types' AND t3.table_col LIKE 'name' AND t3.table_id = spt_types.id)
                    LEFT JOIN realestates_seo ON (realestates.id = realestates_seo.id_realestate)
                    WHERE realestates.status IN (0,1) AND realestates.lease IN (0,1) AND realestates.id = 15628 ORDER BY relevance DESC, realestates.top_offer DESC, realestates.id DESC1