kewl's gallery

Home /

Two champions

20170803_202813_1_HDR.jpg Bike parking in MamerThumbnailsHaystacksBike parking in MamerThumbnailsHaystacksBike parking in MamerThumbnailsHaystacksBike parking in MamerThumbnailsHaystacks

Nicolas Frantz and Josy Barthel, Mamer, Luxembourg. Located in Mamer Park, 200 metres away from PC 13.

Visits
540
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 = '36C6tlrjedm5qn44iq58odgps65r92'
;
(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.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.002 s)
(total time      : 0.006 s)
(num rows        : 1 )
[9] 
SELECT latitude,longitude FROM g_images WHERE id = '5463' ;
(this query time : 0.000 s)
(total SQL time  : 0.002 s)
(total time      : 0.008 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 = 5463 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.009 s)
(num rows        : 1 )
[11] 

UPDATE
  g_images
  SET hit = hit+1, lastmodified = lastmodified
  WHERE id = 5463
;
(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 = 5463
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.010 s)
(num rows        : 2 )
[13] 

SELECT *
  FROM g_images
  WHERE id IN (5463,5551,6069,5464,4568)
;
(this query time : 0.000 s)
(total SQL time  : 0.003 s)
(total time      : 0.010 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 (5463)
  GROUP BY t.id
  ORDER BY NULL
(this query time : 0.000 s)
(total SQL time  : 0.004 s)
(total time      : 0.011 s)
(num rows        : 14 )
[15] 

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

SELECT
    COUNT(*) AS nb_comments
  FROM g_comments
  WHERE image_id = 5463  AND validated = 'true'
;
(this query time : 0.000 s)
(total SQL time  : 0.004 s)
(total time      : 0.013 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.103.13',
    'categories',
    NULL,
    5463,
    'picture',
    NULL,
    NULL,
    NULL
  )
;
(this query time : 0.000 s)
(total SQL time  : 0.004 s)
(total time      : 0.015 s)
(affected rows   : 1 )