Warning: [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 date_creation IS NOT NULL GROUP BY period' at line 5 SELECT DISTINCT(YEAR(date_creation)) as period, COUNT(DISTINCT id) as nb_images FROM paleon_images INNER JOIN paleon_image_category ON id = image_id WHERE category_id IN (1345,1346,1347,1348,1357,1366,1375,1384,1393,1397,1402,1411,1537,1538,1539,1547,1548,1549,1646,1647,1648,1732,1741,1752,1753,1764,1765,2084,2092,2093,2101,2102,2175,2174,2173,2172,2171,2164,2186,2187,2192,2753,2761,2762,2771,2779,2788) AND (level<)) AND date_creation IS NOT NULL GROUP BY period; in /var/www/piwigo274/include/dblayer/functions_mysql.inc.php on line 763
Warning: [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 date_creation IS NOT NULL ORDER BY date_creation DESC, date_availabl' at line 4 SELECT DISTINCT id FROM paleon_images INNER JOIN paleon_image_category ON id = image_id WHERE category_id IN (1345,1346,1347,1348,1357,1366,1375,1384,1393,1397,1402,1411,1537,1538,1539,1547,1548,1549,1646,1647,1648,1732,1741,1752,1753,1764,1765,2084,2092,2093,2101,2102,2175,2174,2173,2172,2171,2164,2186,2187,2192,2753,2761,2762,2771,2779,2788) AND (level<)) AND date_creation IS NOT NULL ORDER BY date_creation DESC, date_available DESC, file ASC, id ASC in /var/www/piwigo274/include/dblayer/functions_mysql.inc.php on line 763
By ESRF
Please cite the original articles linked to the data you are using, as well as the repository institutions. CC BY-NC-SA Attribution-NonCommercial-ShareAlike