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 ') GROUP BY c.id ORDER BY c.id ASC' at line 8 SELECT c.id AS cat_id, id_uppercat, MAX(date_available) AS date_last, COUNT(date_available) AS nb_images FROM paleon_categories as c LEFT JOIN paleon_image_category AS ic ON ic.category_id = c.id LEFT JOIN paleon_images AS i ON ic.image_id = i.id AND i.level<=0 AND i.date_available > SUBDATE(CURRENT_DATE,INTERVAL 7 DAY) WHERE c.id NOT IN (444,445,446,447,448,449,450,452,453,454,455,456,457,458,460,461,462,463,464,465,466,468,469,470,471,472,473,474,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,666,667,668,669,670,671,672,674,675,676,677,678,679,680,682,683,684,685,686,687,688,689,690,691,692,693,694,695,700,701,702,703,704,705,706,707,708,709,710,711,712,713,715,716,717,718,719,720,721,722,723,724,72 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 ')) ORDER BY rank' at line 15 SELECT c.*, user_representative_picture_id, nb_images, date_last, max_date_last, count_images, nb_categories, count_categories FROM paleon_categories c INNER JOIN paleon_user_cache_categories ucc ON id = cat_id AND user_id = 2 WHERE id_uppercat is NULL AND (id IN (-)) ORDER BY rank 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
Photos posted within the last 7 days only.