Warning: [mysql error 1146] Table 'cvlt.piwigo_categories' doesn't exist SELECT c.id cat_id, global_rank, MAX(date_available) date_last, COUNT(date_available) nb_images FROM piwigo_categories as c LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id LEFT JOIN piwigo_images AS i ON ic.image_id = i.id AND i.level<=0 AND i.date_available > SUBDATE(CURRENT_DATE,INTERVAL 7 DAY) GROUP BY c.id in /mnt/101/sdb/c/6/cvlt/include/functions.inc.php on line 918
Warning: [mysql error 1146] Table 'cvlt.piwigo_image_category' doesn't exist SELECT distinct image_id FROM piwigo_image_category INNER JOIN piwigo_images ON image_id = id WHERE category_id IN (-1) and date_available >= SUBDATE( CURRENT_DATE,INTERVAL 7 DAY) in /mnt/101/sdb/c/6/cvlt/include/functions.inc.php on line 918
Warning: [mysql error 1146] Table 'cvlt.piwigo_categories' doesn't exist SELECT id, name, permalink, nb_images, global_rank, date_last, max_date_last, count_images, count_categories FROM piwigo_categories INNER JOIN piwigo_user_cache_categories ON id = cat_id and user_id = 2 WHERE (id IN (-1)) ; in /mnt/101/sdb/c/6/cvlt/include/functions.inc.php on line 918
Warning: [mysql error 1146] Table 'cvlt.piwigo_categories' doesn't exist SELECT c.*, nb_images, date_last, max_date_last, count_images, count_categories FROM piwigo_categories c INNER JOIN piwigo_user_cache_categories ON id = cat_id and user_id = 2 WHERE id_uppercat is NULL AND (id IN (-1)) ORDER BY rank ; in /mnt/101/sdb/c/6/cvlt/include/functions.inc.php on line 918
L'ensemble des éléments est filtré pour n'afficher que les éléments récents de moins de 7 jours.