kewl's gallery

Home /

Call of the forest

20170124_192704-HDR_HDR-Edit.jpg A bike at nightThumbnailsNight ride in the forestA bike at nightThumbnailsNight ride in the forestA bike at nightThumbnailsNight ride in the forestA bike at nightThumbnailsNight ride in the forest

Forest track at night time, during winter, in Bertrange, Luxembourg.

Visits
2974
Location
View on OpenStreetMap
Rating score
no rate
Rate this photo

0 comments

[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 = '36C6hn6t578p93qncaadhh43pv0ch3'
;
(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.004 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.001 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.001 s)
(total time      : 0.005 s)
(num rows        : 1 )
[9] 
SELECT latitude,longitude FROM g_images WHERE id = '4743' ;
(this query time : 0.000 s)
(total SQL time  : 0.002 s)
(total time      : 0.007 s)
(num rows        : 1 )
[10] 
SELECT i.latitude, i.longitude,
    IFNULL(i.name, '') AS `name`,
    TRIM(LEADING '.' FROM IF(i.representative_ext IS NULL,
        CONCAT(LEFT(i.path,LENGTH(i.path)-1-LENGTH(SUBSTRING_INDEX(i.path, '.', -1 ))), '-sq.', SUBSTRING_INDEX(i.path, '.', -1 )),
            REPLACE(i.path, TRIM(TRAILING '.' FROM SUBSTRING_INDEX(i.path, '/', -1 )),
                CONCAT('pwg_representative/',
                    CONCAT(
                        TRIM(TRAILING '.' FROM SUBSTRING_INDEX( SUBSTRING_INDEX(i.path, '/', -1 ) , '.', 1 )),
                        CONCAT('-sq.', i.representative_ext)
                    )
                )
            )
    )) AS `pathurl`,
    TRIM(TRAILING '/' FROM CONCAT( i.id, '/category/', IFNULL(ic.category_id, '') ) ) AS `imgurl`,
    IFNULL(i.comment, '') AS `comment`,
    IFNULL(i.author, '') AS `author`,
    i.width
        FROM g_images AS i
            INNER JOIN (g_image_category AS ic ) ON i.id = ic.image_id
            WHERE i.id = 4743 AND  i.latitude IS NOT NULL AND i.longitude IS NOT NULL 
 AND (ic.category_id NOT IN (188,201,198,200,182,212) AND i.level<=0) GROUP BY i.id;
(this query time : 0.000 s)
(total SQL time  : 0.002 s)
(total time      : 0.008 s)
(num rows        : 1 )
[11] 

UPDATE
  g_images
  SET hit = hit+1, lastmodified = lastmodified
  WHERE id = 4743
;
(this query time : 0.000 s)
(total SQL time  : 0.003 s)
(total time      : 0.009 s)
(affected rows   : 1 )
[12] 

SELECT id,uppercats,commentable,visible,status,global_rank
  FROM g_image_category
    INNER JOIN g_categories ON category_id = id
  WHERE image_id = 4743
AND (id NOT IN (188,201,198,200,182,212))
;
(this query time : 0.000 s)
(total SQL time  : 0.003 s)
(total time      : 0.009 s)
(num rows        : 3 )
[13] 

SELECT *
  FROM g_images
  WHERE id IN (4743,4746,6069,4744,4568)
;
(this query time : 0.000 s)
(total SQL time  : 0.003 s)
(total time      : 0.009 s)
(num rows        : 5 )
[14] 

SELECT t.*, count(*) AS counter
  FROM g_image_tag
    INNER JOIN g_tags t ON tag_id = id
  WHERE image_id IN (4743)
  GROUP BY t.id
  ORDER BY NULL
(this query time : 0.000 s)
(total SQL time  : 0.004 s)
(total time      : 0.010 s)
(num rows        : 18 )
[15] 

SELECT id, name, permalink
  FROM g_categories
  WHERE id IN (152,169,146,102)
(this query time : 0.000 s)
(total SQL time  : 0.004 s)
(total time      : 0.011 s)
(num rows        : 4 )
[16] 

SELECT
    COUNT(*) AS nb_comments
  FROM g_comments
  WHERE image_id = 4743  AND validated = 'true'
;
(this query time : 0.000 s)
(total SQL time  : 0.004 s)
(total time      : 0.012 s)
(num rows        : 1 )
[17] 

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.23.251',
    'categories',
    NULL,
    4743,
    'picture',
    NULL,
    NULL,
    NULL
  )
;
(this query time : 0.000 s)
(total SQL time  : 0.004 s)
(total time      : 0.014 s)
(affected rows   : 1 )