# Time: 140113 17:56:39
# User@Host: sylvie[sylvie] @ localhost []
# Query_time: 5.387156  Lock_time: 0.000188 Rows_sent: 252  Rows_examined: 71663
use rythmes-croisesorg;
SET timestamp=1389632199;
SELECT DISTINCT id ,date_creation FROM YYYpiwigo_images
INNER JOIN YYYpiwigo_image_category ON id = image_id
    WHERE (category_id NOT IN (107,280,427,1006,1005,308,403,51,52,54,55,9,943) AND level<=0)
   AND date_creation BETWEEN '2011-01-01' AND '2011-12-31 23:59:59' AND WEEK(date_creation, 5)+1=13 AND WEEKDAY(date_creation)=2
  ORDER BY date_creation ASC, file ASC, date_creation ASC, id ASC;


# Time: 140113 19:37:56
# User@Host: sylvie[sylvie] @ localhost []
# Query_time: 7.132841  Lock_time: 0.000123 Rows_sent: 70491  Rows_examined: 282074
use rythmes-croisesorg;
SET timestamp=1389638276;
SELECT DISTINCT(image_id)
  FROM YYYpiwigo_image_category
    INNER JOIN YYYpiwigo_images ON id = image_id
  WHERE
    1=1
AND (category_id NOT IN (107,280,427,1006,1005,308,403,51,52,54,55,9,943) AND level<=0)
  ORDER BY file ASC, date_creation ASC, id ASC;


# Time: 140113 20:20:45
# User@Host: sylvie[sylvie] @ localhost []
# Query_time: 55.957563  Lock_time: 0.000140 Rows_sent: 1704  Rows_examined: 213287
use rythmes-croisesorg;
SET timestamp=1389640845;
SELECT DISTINCT(image_id)
  FROM YYYpiwigo_image_category
    INNER JOIN YYYpiwigo_images ON id = image_id
  WHERE
    1=1
AND (category_id NOT IN (107,280,427,1006,1005,308,403,51,52,54,55,9,943) AND level<=0)
  ORDER BY file ASC, date_creation ASC, id ASC;


# Time: 140113 20:21:10
# User@Host: sylvie[sylvie] @ localhost []
# Query_time: 6.258313  Lock_time: 0.000104 Rows_sent: 2  Rows_examined: 2051057
SET timestamp=1389640870;
SELECT COUNT(*)
    FROM YYYpiwigo_history
    WHERE ip="157.55.33.16"
    AND date = CURDATE()
    AND time > ADDTIME(CURTIME(), "-00:00:10")
    

    UNION ALL

    SELECT COUNT(*)
    FROM YYYpiwigo_history
    WHERE ip="157.55.33.16"
    AND date = CURDATE()
    AND time > ADDTIME(CURTIME(), "-00:00:30")
    AND category_id = 262
    AND image_id IS NULL;


# Time: 140113 20:21:14
# User@Host: sylvie[sylvie] @ localhost []
# Query_time: 11.154151  Lock_time: 0.401931 Rows_sent: 70491  Rows_examined: 282074
SET timestamp=1389640874;
SELECT DISTINCT(image_id)
  FROM YYYpiwigo_image_category
    INNER JOIN YYYpiwigo_images ON id = image_id
  WHERE
    1=1
AND (category_id NOT IN (107,280,427,1006,1005,308,403,51,52,54,55,9,943) AND level<=0)
  ORDER BY file ASC, date_creation ASC, id ASC;