SELECT
DISTINCT(a.crea_id),
a.office_name,
a.office_id,
b.crea_id,
b.mls_id,
STR_TO_DATE(b.last_updated,'%a, %d %b %Y') AS LASTUPDATED,
b.street_address,
b.city,
b.province,
b.postal,
b.price,
b.bedroom_total,
b.bathroom_total,
b.half_bath_total,
b.size_interior,
c.sequence_id,
c.thumbURL,
c.medURL,
c.largeURL
FROM tbl_CREA_0_agents a
INNER JOIN tbl_CREA_0 b ON (a.crea_id = b.crea_id) LEFT JOIN tbl_CREA_0_photos c ON (a.crea_id = c.crea_id AND c.sequence_id = 1) WHERE a.crea_id IN (25165662)
ORDER BY b.price DESC, b.mls_id ASC
2 | 
3 
