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_available BETWEEN '2011-01-01' AND '2011-12-31 23:59:59' GROUP BY ' at line 4 SELECT DISTINCT(WEEK(date_available, 5)+1) as period, COUNT(DISTINCT id) as nb_images FROM paleon_images INNER JOIN paleon_image_category ON id = image_id WHERE (category_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,725,726,727,729,731,732,733,734,735,736,737,738,739,740,741,742,743,744,748,749,750,751,752,753,754,755,756,757,758,759,760,761,7 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_available IS NOT NULL GROUP BY period' at line 3 SELECT CONCAT_WS('-',YEAR(date_available)) AS period FROM paleon_images INNER JOIN paleon_image_category ON id = image_id WHERE (category_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,725,726,727,729,731,732,733,734,735,736,737,738,739,740,741,742,743,744,748,749,750,751,752,753,754,755,756,757,758,759,760,761,763,764,765,766,767,768,769,770,771,772,773,774,775,776,779,780,781, 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_available BETWEEN '2011-01-01' AND '2011-12-31 23:59:59' ORDER ' at line 3 SELECT DISTINCT id FROM paleon_images INNER JOIN paleon_image_category ON id = image_id WHERE (category_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,725,726,727,729,731,732,733,734,735,736,737,738,739,740,741,742,743,744,748,749,750,751,752,753,754,755,756,757,758,759,760,761,763,764,765,766,767,768,769,770,771,772,773,774,775,776,779,780,781,78 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