SELECT if(enabled_unitsize ,unit_size_desc,lst_type_listing.type_listing) as regroup, if(enabled_unitsize ,unit_size,CONCAT(' ',lst_type_listing.type_listing)) as regroup_sort, rand() as rnd, tbl_rent.*, CONCAT('http://www.trouveunappart.com/' , tbl_building.path_region , '/' , tbl_building.path_municipality , '/' , tbl_building.path_builduig , '/' , tbl_building_suite.image01) as image, tbl_building.name, tbl_building.name_french, tbl_region.region, tbl_building.address, tbl_region.h1_rqa as h1, tbl_region.h1_desc_rqa as h1_desc, tbl_building.phone, tbl_building.email, tbl_building.email2, tbl_building.numero FROM (tbl_region INNER JOIN ((lst_type_listing INNER JOIN (tbl_building INNER JOIN tbl_rent ON tbl_building.numero = tbl_rent.building_link) ON lst_type_listing.type_listing = tbl_rent.type_listing) INNER JOIN tbl_building_suite ON tbl_building.numero = tbl_building_suite.numero_link) ON tbl_region.region_code = tbl_building.region) INNER JOIN tbl_mainregion ON tbl_region.link_mainregion = tbl_mainregion.mainregion WHERE tbl_rent.active and tbl_building.active_rentquebecapartments and tbl_building.region = 'Montreal-Downtown' and true and true and true and true and true ORDER BY regroup_sort LIMIT 0, 10
