string(2305) "SELECT temp.*,city.City,city.simplified AS citysimplified,co.county,co.simplified AS cosimplified,s.state,s.simplified AS statesimplified,t.latest_status,t.True_status_simplified FROM ( ( SELECT Zip,UpDateTime,True_statusid,PropertyTypeid ,ListPrice,Beds,Baths,Sqft,LotSize,YearBuilt,Address,ImageCity,image_main,listdate,HomeID,"" as agentid,"0" AS agent_house_sign ,"0" AS agent_top_sign ,"" AS titleDes, StatusID, table1_name, table1_id FROM home FORCE INDEX (coveringindex1) WHERE StatusID in (80) AND `True_statusid` > 0 AND `UpDateTime`>=0 and (`True_statusid` >= 0 and images_checked>0 ) order by UpDateTime desc limit 1000 ) Union all ( SELECT Zip,UpDateTime,True_statusid,PropertyTypeid ,ListPrice ,Beds ,Baths ,Sqft,LotSize,YearBuilt,Address ,ImageCity,ImageNames as image_main ,listdate ,HomeID,agentid ,"0" AS agent_house_sign ,"1" AS agent_top_sign ,titleDes, StatusID, '' as table1_name, '' as table1_id FROM home_agent WHERE StatusID in (80) AND `True_statusid` > 0 and `agentid` in(51,430,500,1159,1170,1492,1525,1859,2131,2145,2383,2396,2547,2588,2724,2786,3076,3470,3491,3644,3660,3799,3813,3833,3861,3865,3897,3990,3997,4036,4038,4061,4068,4376,4407,4410,4424,4433,4434,4446,4454,4492,4495,4508,4518,4523,4527,4557) AND `activate`=1 AND `ListPrice`> 100000 and top_house = 0 and ImageNames != '' order by UpDateTime desc limit 1000 ) Union all ( SELECT Zip,UpDateTime,True_statusid,PropertyTypeid ,ListPrice ,Beds ,Baths ,Sqft,LotSize,YearBuilt,Address ,ImageCity,ImageNames as image_main,listdate ,HomeID,agentid ,"1" AS agent_house_sign ,"1" AS agent_top_sign ,titleDes, StatusID, '' as table1_name, '' as table1_id FROM home_agent WHERE `activate`=1 and top_house = 1 and StatusID in (80) AND `True_statusid` > 0 and `agentid` in(1170,1525) AND `ListPrice`> 100000 and ImageNames != '' order by UpDateTime desc limit 9 ) ) AS temp LEFT JOIN True_status AS t ON temp.True_statusid = t.True_statusid LEFT JOIN `status` AS city ON temp.StatusID = city.StatusID LEFT JOIN county AS co ON city.idcounty = co.idcounty LEFT JOIN state AS s ON co.idstate = s.idstate ORDER BY agent_house_sign desc, UpDateTime desc,HomeID asc limit 0,20"