MySQL Query : 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 (3390) AND `True_statusid` > 0 AND `UpDateTime`>=0 AND `Sqft`> 1500 AND `Sqft`< 2000 and (`True_statusid` >= 0) and SUBSTRING(ImageCity,1,8)<'20240328' 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 (3390) AND `True_statusid` > 0 and `agentid` in(14,500,850,1170,1492,1525,1859,2131,2145,2383,2786,2820,2821,2822,2823,2824,2825,2826,2828,2829,2830,2831,2832,2833,2834,3416,3470,3491,3644,3799,3997,4424,4433,4454,4495,4518,4639,4640,4656,4660,4665,4681,7636,7640,7662,7685,7708) AND `activate`=1 AND `ListPrice`> 100000 AND `Sqft`> 1500 AND `Sqft`< 2000 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 (3390) AND `True_statusid` > 0 and `agentid` in(1170,1525,7640,7708) AND `ListPrice`> 100000 AND `Sqft`> 1500 AND `Sqft`< 2000 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 DaysOnMarket asc,agent_house_sign desc,HomeID ASC limit 0,20
MySQL Error : Unknown column 'DaysOnMarket' in 'order clause'
MySQL Errno : 1054
Message :
Need Help?