|
|
|
|
לא נמצאו תוצאות חיפוש
Expression #1 of ORDER BY clause is not in SELECT list, references column 'navehroshs_s1qa.Deal_locations.location' which is not in SELECT list; this is incompatible with DISTINCT - SELECT DISTINCT Deals.Deal_ID,Deals.alt_name as alt_name, CONCAT_WS(' | ',sites.phone1,sites.phone2) AS `phones`, Deals.site_desc as site_desc,Deals.link_to,sites.siteID,sites.TITLE as TITLE,sites.prPicture1,sites.link,sites.link_type,sites.enableOutLinks,sites.mr_words , sites.siteText, settlements.TITLE AS settlement_name, settlements.settlementID
FROM Deals INNER JOIN Deal_locations USING(Deal_ID) INNER JOIN siteTypesDetails USING(real_typeID)
INNER JOIN sites ON(Deals.siteID = sites.siteID) LEFT JOIN settlements USING(settlementID)
WHERE Deals.Deal_type_ID = '2' AND Deals.Beginning_date <= CURDATE() AND Deals.Temp_date >= CURDATE() AND Deals.Active = '1'
AND siteTypesDetails.typeID = '6' AND 1 AND Deal_locations.areaID = '0' AND (LENGTH(sites.TITLE) > 0 OR LENGTH(Deals.alt_name) > 0)
ORDER BY Deal_locations.location, RAND()
LIMIT 0 , 20 | |
