Logik

select distinct SQL_CALC_FOUND_ROWS *, &#40;id&#41;, time&#40;timestamp&#41; as clocktime, company, case when multiplelocations.classifiedid is not null then concat&#40;multiplelocations.classifiedid&#41; end as hasmultiplelocation, oldprice, case when lb.areacode!=11 then concat&#40;location.location&#41; end as displaylocation, case when location.areacode!=11 then concat&#40;lb.location&#41; end as multiplelocation, DATEDIFF&#40;NOW&#40;&#41;,timestamp&#41; as datediff1, substring&#40;time&#40;timestamp&#41;,1,5&#41; as clock, MONTH&#40;timestamp&#41; as monthnumber, DAYOFMONTH&#40;timestamp&#41; as daynumber, id, id as adnr, subject, imageurl, imageurl2, price, location.location, category, DATEDIFF&#40;NOW&#40;&#41;,timestamp&#41; as datediff from classifieds join location on classifieds.locationid=location.locationid left join multiplelocations on multiplelocations.classifiedid=classifieds.id left join location lb on multiplelocations.locationid=lb.locationid join category on classifieds.categoryid=category.categoryid where &#40;location.areacode=11 and &#40;sell=1 and visible='1' and DATE_SUB&#40;CURDATE&#40;&#41;,INTERVAL 60 DAY&#41; <= timestamp and MATCH &#40;subject,text,color, location.location, lb.location&#41; AGAINST &#40;'sitio' IN BOOLEAN MODE&#41; &#41;&#41; or &#40;lb.areacode=11 and &#40;sell=1 and visible='1' and DATE_SUB&#40;CURDATE&#40;&#41;,INTERVAL 60 DAY&#41; <= timestamp and MATCH &#40;subject,text,color, location.location, lb.location&#41; AGAINST &#40;'sitio' IN BOOLEAN MODE&#41; &#41;&#41; group by id order by timestamp desc limit 0,100