SELECT p.property_id, p.source_id, p.title, p.summary, p.descr, p.homeaway_property_id, p.source_property_id, p.homeaway_url, p.source_property_url, p.property_type, p.sleeps, p.bedrooms, p.full_bathrooms, p.half_bathrooms, p.city, p.state_abbr, p.zip, p.region, p.city_id, p.latitude, p.longitude, p.owner_name, p.is_spidered, p.is_active, p.is_synonymizer_disabled, p.rating, p.reviews, p.size, p.allows_parties, p.allows_smoking, p.allows_pets, p.allows_children, p.area_descr, p.pet_policy, p.special_instructions, p.kbyg, s.source_id, s.descr AS company_name, s.phone AS company_phone, s.logo AS company_logo_image, s.lead_form_email, s.folder, s.utm, s.is_active AS is_source_active, s.enable_canonical, CASE WHEN IFNULL(sco.detail_page_url_prefix,'') <> '' THEN sco.detail_page_url_prefix ELSE s.detail_page_url_prefix END AS detail_page_url_prefix, ci.city, pg.url
				FROM properties p
				INNER JOIN pages pg ON p.property_id = pg.some_id AND pg.page_type = 'property'
				LEFT JOIN cities ci ON p.city_id = ci.city_id
				LEFT JOIN sources s ON p.source_id = s.source_id
				LEFT JOIN source_city_override sco ON p.source_id = sco.source_id AND p.city_id = sco.city_id
				WHERE 1=1
				 AND p.property_id IN (378823)
				ORDER BY FIELD(p.property_id,378823)