SELECT SQL_CALC_FOUND_ROWS tblinventory.* , rtkgroup.tblhousefeatures.*, tblhouseinfo.addInfoID, tblhouseinfo.name, tblhouseinfo.Address, tblhouseinfo.City, tblhouseinfo.`State`, tblhouseinfo.Zip, tblhouseinfo.Make, tblhouseinfo.Model, tblhouseinfo.`Year`, tblhouseinfo.sqr_ft, tblhouseinfo.Width, tblhouseinfo.Length, tblhouseinfo.BedRooms, tblhouseinfo.BathRooms, tblhouseinfo.list_price, tblhouseinfo.status, tblhouseinfo.lng, tblhouseinfo.lat FROM (tblinventory JOIN tblhouseinfo ON tblhouseinfo.addInfoID=tblinventory.invId) LEFT JOIN rtkgroup.tblhousefeatures ON tblinventory.invId = rtkgroup.tblhousefeatures.key WHERE tblinventory.mid= 1 AND tblinventory.invId = 3654 AND invReleased = 0 ORDER BY tblhouseinfo.City LIMIT 1<BR><BR>