string(2483) "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 (418) 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 (418) AND `True_statusid` > 0 and `agentid` in(347,430,475,500,1159,1170,1461,1492,1506,1525,1859,2131,2145,2396,2547,2588,2724,3076,3318,3470,3491,3556,3571,3600,3624,3639,3644,3650,3660,3665,3666,3679,3685,3688,3690,3706,3708,3715,3785,3788,3799,3808,3809,3813,3827,3833,3834,3861,3865,3886,3897,3901,3911,3930,3934,3946,3990,3997,4008,4026,4028,4033,4036,4038,4061,4065,4068,4075,4078,4208,4261,4376,4396,4403,4407,4410,4424,4433,4434,4446,4454) 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 (418) AND `True_statusid` > 0 and `agentid` in(1170,1525,3639,3715) 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"