| SQL Error: Could not execute query in /opt/coresystem/plugins/search/main.php:124 | | Query: |
SELECT DISTINCT(pages.id),
pages.contenttype,
pages.pagetitle,
pages.linktitle,
plugins.pluginname,
plugins.status AS pluginstatus,
pagecontent.content AS htmlcontent,
pages.id IN (13,10,6,1188,1209,1206,1211,1212,1161,1176,1196,15,1215) AS inblock
FROM pages
LEFT JOIN plugins
ON pages.pluginid=plugins.id
LEFT JOIN pagecontent
ON pages.id=pagecontent.pageid
WHERE (pages.status='enabled')
AND (
(pages.contenttype='plugin')
OR ( pages.contenttype='html' AND (pages.linktitle LIKE '%Target%' OR pages.pagetitle LIKE '%Target%' OR pagecontent.content LIKE '%Target%') )
OR (pages.id IN (13,10,6,1188,1209,1206,1211,1212,1161,1176,1196,15,1215))
)
ORDER BY CASE linklocation WHEN 'all' THEN 1 WHEN 'top' THEN 2 WHEN 'block' THEN 3 ELSE 4 END ASC,weight ASC
| | Error: | Expression #1 of ORDER BY clause is not in SELECT list, references column 'lightningmonkey_city.pages.linklocation' which is not in SELECT list; this is incompatible with DISTINCT | | Call: | $SQL->select_query(string="
SELECT DISTINCT(pages.id),...",boolean=false) |
Search results for "Target":
Sorry, there were no matches for your search keyword.
Click here to try another search.
|
