mySQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND deleted = 0 ORDER BY slot ASC' at line 1 Error occurred while running query: SELECT title, CONCAT('uploads/artworks/',picture) AS picture FROM pictures WHERE id_content = AND deleted = 0 ORDER BY slot ASC mySQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND c.active = 1
AND c.deleted = 0
AND a.active = 1
AND a.dele' at line 13 Error occurred while running query:
SELECT c.id_content, c.pubdate, REPLACE(c.title, '&', '|-|') AS title, c.brief, CONCAT('/english/expositions/',c.url,'.html') AS url,
CONCAT('/english/expositions/',YEAR(c.pubdate),'.html') AS viewfull,
IF(LENGTH(c.thumbnail)>0, CONCAT('uploads/exhibitions/',c.thumbnail), 'images/th-expo-1.png') AS thumbnail,
GROUP_CONCAT(DISTINCT CONCAT(a.first_name,' ',a.last_name) ORDER BY CONCAT(a.first_name,' ',a.last_name) DESC SEPARATOR ', ') AS artists
FROM contents AS c
LEFT JOIN artists_by_content AS ac ON c.id_content = ac.id_content
LEFT JOIN artists AS a ON a.id_artist = ac.id_artist
WHERE c.id_content_type = 3
AND c.id_language = 2
AND c.pubdate <= '2010-03-01'
AND c.id_content NOT IN (568)
AND c.id_content <>
AND c.active = 1
AND c.deleted = 0
AND a.active = 1
AND a.deleted = 0
GROUP BY c.id_content
ORDER BY c.pubdate DESC
LIMIT 0,5
kurimanzutto -
