kewl's gallery

Shoot whatever inspires you. Red should be the focus of the image. Don't be afraid to be creative. I've been having this red playground in mind for some time since I bike in front of it everyday. When I saw this week's challenge, I hoped they wouldn't remove the red lights; and they didn't ;) Also added a few other candidates for the challenge, all related to red and winter, as it decided to finally show up.
[1] 
SELECT @@SESSION.sql_mode
(this query time : 0.000 s)
(total SQL time  : 0.000 s)
(total time      : 0.002 s)
(num rows        : 1 )
[2] 

SELECT param, value
 FROM g_config
 
;
(this query time : 0.000 s)
(total SQL time  : 0.000 s)
(total time      : 0.002 s)
(num rows        : 92 )
[3] 

SELECT data
  FROM g_sessions
  WHERE id = '36C6lhc7a5b1r91rua3c9n2eqcp234'
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)
(total time      : 0.003 s)
(num rows        : 0 )
[4] 

SELECT * FROM g_plugins
  WHERE state='active'
(this query time : 0.000 s)
(total SQL time  : 0.001 s)
(total time      : 0.003 s)
(num rows        : 15 )
[5] 

SELECT id AS id
     , username AS username
     , password AS password
     , mail_address AS email
  FROM g_users
  WHERE id = '2'
(this query time : 0.000 s)
(total SQL time  : 0.001 s)
(total time      : 0.005 s)
(num rows        : 1 )
[6] 

SELECT
    ui.*,
    uc.*,
    t.name AS theme_name
  FROM g_user_infos AS ui
    LEFT JOIN g_user_cache AS uc ON ui.user_id = uc.user_id
    LEFT JOIN g_themes AS t ON t.id = ui.theme
  WHERE ui.user_id = 2
;
(this query time : 0.000 s)
(total SQL time  : 0.001 s)
(total time      : 0.005 s)
(num rows        : 1 )
[7] 

SELECT id, name
  FROM g_languages
  ORDER BY name ASC
;
(this query time : 0.000 s)
(total SQL time  : 0.002 s)
(total time      : 0.005 s)
(num rows        : 69 )
[8] 

SELECT *
  FROM g_user_infos
  WHERE user_id = 2
;
(this query time : 0.000 s)
(total SQL time  : 0.002 s)
(total time      : 0.006 s)
(num rows        : 1 )
[9] 

SELECT *
  FROM g_categories
  WHERE id = 130
;
(this query time : 0.000 s)
(total SQL time  : 0.002 s)
(total time      : 0.008 s)
(num rows        : 1 )
[10] 

  SELECT id, name, permalink
    FROM g_categories
    WHERE id IN (126,127,130)
  ;
(this query time : 0.000 s)
(total SQL time  : 0.003 s)
(total time      : 0.008 s)
(num rows        : 3 )
[9] 

SELECT DISTINCT(image_id)
  FROM g_image_category
    INNER JOIN g_images ON id = image_id
  WHERE
    category_id = 130
AND (category_id NOT IN (188,201,198,200,182,212) AND level<=0)
  ORDER BY date_creation DESC, file ASC, id ASC
;
(this query time : 0.000 s)
(total SQL time  : 0.002 s)
(total time      : 0.009 s)
(num rows        : 7 )
[10] 

SELECT 
  id, name, permalink, nb_images, global_rank,
  date_last, max_date_last, count_images, count_categories
FROM g_categories INNER JOIN g_user_cache_categories
  ON id = cat_id and user_id = 2
WHERE 
  1 = 1
;
(this query time : 0.000 s)
(total SQL time  : 0.003 s)
(total time      : 0.009 s)
(num rows        : 102 )
[11] 

SELECT SUBDATE(CURRENT_DATE,INTERVAL 30 DAY)
(this query time : 0.000 s)
(total SQL time  : 0.003 s)
(total time      : 0.009 s)
(num rows        : 1 )
[12] 

SELECT t.*, count(*) AS counter
  FROM g_image_tag
    INNER JOIN g_tags t ON tag_id = id
  WHERE image_id IN (4034,4035,4033,4030,4032,4031,4036)
  GROUP BY t.id
  ORDER BY counter DESC
  LIMIT 12
(this query time : 0.001 s)
(total SQL time  : 0.004 s)
(total time      : 0.013 s)
(num rows        : 12 )
[13] 

SELECT *
  FROM g_images
  WHERE id IN (4034,4035,4033,4030,4032,4031,4036)
;
(this query time : 0.000 s)
(total SQL time  : 0.004 s)
(total time      : 0.015 s)
(num rows        : 7 )

[0.016 s, 13 queries] : end include/category_default.inc.php

[14] 

SELECT id FROM g_images
WHERE latitude IS NOT NULL
  AND id IN (4034,4035,4033,4030,4032,4031,4036)
ORDER BY NULL
LIMIT 0,1
(this query time : 0.000 s)
(total SQL time  : 0.004 s)
(total time      : 0.017 s)
(num rows        : 1 )
[15] 

INSERT INTO g_history
  (
    date,
    time,
    user_id,
    IP,
    section,
    category_id,
    image_id,
    image_type,
    format_id,
    auth_key_id,
    tag_ids
  )
  VALUES
  (
    CURRENT_DATE,
    CURRENT_TIME,
    2,
    '54.198.103.13',
    'categories',
    130,
    NULL,
    NULL,
    NULL,
    NULL,
    NULL
  )
;
(this query time : 0.000 s)
(total SQL time  : 0.005 s)
(total time      : 0.018 s)
(affected rows   : 1 )