Στον δήμο Πύργου η καθημερινή παρουσία του αντιδήμαρχου οικονομικών Λάμπη Αριστειδόπουλου αποτελεί φωτεινή εξαίρεση.
Την ώρα που οι εναπομείναντες πιστοί στην δημοτική αρχή απλά μαζεύουν τα αρχεία τους, αυτός εξακολουθεί να το παλεύει. Αν και ως γνωστόν, ένας κούκος δε μπορεί να φέρει την άνοιξη, το καθήκον –όπως αυτός το αντιλαμβάνεται- του επιβάλει να είναι παρών. Κάτι είναι κι αυτό, γιατί τα προβλήματα της καθημερινότητας τελειωμό δεν έχουν…
session.client.forwarded ⇒ 174.129.228.67
session.client.browser ⇒ ia_archiver (+http://www.alexa.com/site/help/webmasters; [email protected])
password_clear ⇒
groups ⇒
link ⇒ http://www.eproini.gr/index.php/ileia/38232-liatsis-tha-apokatastisoume-me-kathe-tropo-tin-aksioprepeia-ton-pyrgioton
link ⇒ http://www.eproini.gr/index.php/ileia/ileia-kampos/38219-stin-andravida-nekros-voylgaros-pou-etroge-apo-ta-skoupidia
link ⇒ http://www.eproini.gr/index.php/menu-ellada-koinonia/38236-paidikoi-stathmoi-espa-allazoun-ta-kritiria-pote-ksekinoyn-oi-aitiseis
link ⇒ http://www.eproini.gr/index.php/menu-politismos-ekdiloseis/38185-deksameni-diimero-afieromeno-se-draseis-ekpaideftikon
link ⇒ http://www.eproini.gr/index.php/menu-politismos-ekdiloseis/38213-22-laografikos-xoreftikos-omilos-giortasan-to-finale-tis-xronias-xoreyontas
link ⇒ http://www.eproini.gr/index.php/politiki/361-pol-tel-nea/38234-ggg-liatsis-ston-pyrgo-tha-epanelthei-to-tmima-mme-kai-pliroforikis-giati-mas-to-xrostane
link ⇒ http://www.eproini.gr/index.php/politismos/politismos-mousiki/38198-mikti-xorodia-pyrgou-enas-pyrgos-apo-ta-palia
link ⇒ http://www.eproini.gr/index.php/proini/proini-gumnastiki/38223-piran-diazygio
link ⇒ http://www.eproini.gr/index.php/proini/proini-gumnastiki/38225-11apotelei-eksairesi
session.token ⇒ 727bb177c7316fb0be3b714e8878d8ba
Application 0.000 seconds (+0.000); 1.21 MB (+1.208) - afterLoadApplication 0.310 seconds (+0.310); 6.76 MB (+5.552) - afterInitialiseApplication 0.360 seconds (+0.050); 10.87 MB (+4.110) - afterRouteApplication 0.880 seconds (+0.520); 15.59 MB (+4.717) - afterDispatchApplication 1.060 seconds (+0.180); 18.28 MB (+2.696) - beforeRenderModule mod_login (Login)Application 1.069 seconds (+0.009); 18.41 MB (+0.127) - afterRenderModule mod_login (Login)Application 1.074 seconds (+0.005); 18.43 MB (+0.020) - beforeRenderModule mod_weather_gk4 (Ο Καιρος)Application 1.342 seconds (+0.268); 18.96 MB (+0.531) - afterRenderModule mod_weather_gk4 (Ο Καιρος)Application 1.349 seconds (+0.006); 18.96 MB (-0.002) - beforeRenderModule mod_news_pro_gk4 (Top banner)Application 3.018 seconds (+1.669); 20.98 MB (+2.020) - afterRenderModule mod_news_pro_gk4 (Top banner)Application 3.035 seconds (+0.018); 20.94 MB (-0.042) - afterRender20.97 MB (21,993,232 Bytes)SELECT `data`
FROM `h5490_session`
WHERE `session_id` = 'g33cr15tccvd2i5o2fo9mglfj7'DELETE
FROM `h5490_session`
WHERE `time` < '1403751557'SELECT count(*)
FROM `h5490_cwtraffic`
WHERE ip = '174.129.228.67'
AND tm + '3600'>'1403752457'SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM h5490_menu AS m
LEFT JOIN h5490_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM h5490_categories as c
LEFT JOIN h5490_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM h5490_categories AS cat JOIN h5490_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=38225
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT alias, catid
FROM h5490_content
WHERE id = 38225SHOW TABLESSHOW FULL COLUMNS
FROM `h5490_autotweet_automator`SELECT h5490_autotweet_automator.*
FROM h5490_autotweet_automator
WHERE `plugin` = 'automator'SELECT h5490_autotweet_automator.*
FROM h5490_autotweet_automator
WHERE `plugin` = 'content'SELECT b.rules
FROM h5490_assets AS a
LEFT JOIN h5490_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT b.id
FROM h5490_usergroups AS a
LEFT JOIN h5490_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
SELECT MAX(contact.id) AS id
FROM h5490_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM h5490_content AS a
LEFT JOIN h5490_categories AS c
on c.id = a.catid
LEFT JOIN h5490_users AS u
on u.id = a.created_by
LEFT JOIN h5490_categories as parent
ON parent.id = c.parent_id
LEFT JOIN h5490_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM h5490_categories AS cat JOIN h5490_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 38225
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-06-26 03:14:17')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-06-26 03:14:17')
AND (a.state = 1 OR a.state =2)SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM h5490_categories as c
LEFT JOIN h5490_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM h5490_categories AS cat JOIN h5490_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=368
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftUPDATE h5490_content
SET hits = hits + 1
WHERE id = 38225SELECT alias, catid
FROM h5490_content
WHERE id = 38225SELECT DISTINCT
c.id AS CID
FROM
h5490_categories AS c
LEFT JOIN
h5490_content AS content
ON
c.id = content.catid
WHERE
( c.id = 181 OR c.id = 257 OR c.id = 259 OR c.id = 368 OR c.id = 370 OR c.id = 260 OR c.id = 258 OR c.id = 250 OR c.id = 251 OR c.id = 252 OR c.id = 253 OR c.id = 254 OR c.id = 255 OR c.id = 256 OR c.id = 363 OR c.id = 264 OR c.id = 265 OR c.id = 266 OR c.id = 267 OR c.id = 324 OR c.id = 361 OR c.id = 268 OR c.id = 270 OR c.id = 271 OR c.id = 272 OR c.id = 273 OR c.id = 362 OR c.id = 274 OR c.id = 275 OR c.id = 276 OR c.id = 277 OR c.id = 278 OR c.id = 279 OR c.id = 280 OR c.id = 281 OR c.id = 282 OR c.id = 283 OR c.id = 284 OR c.id = 285 OR c.id = 315 OR c.id = 316 OR c.id = 317 OR c.id = 318 OR c.id = 319 OR c.id = 286 OR c.id = 287 OR c.id = 288 OR c.id = 291 OR c.id = 179 OR c.id = 180 OR c.id = 364 OR c.id = 292 OR c.id = 350 OR c.id = 351 OR c.id = 352 OR c.id = 349 OR c.id = 347 OR c.id = 348 OR c.id = 346 OR c.id = 293 OR c.id = 294 OR c.id = 295 OR c.id = 296 OR c.id = 297 OR c.id = 298 OR c.id = 299 OR c.id = 360 OR c.id = 369 OR c.id = 300 OR c.id = 301 OR c.id = 302 OR c.id = 303 OR c.id = 305 OR c.id = 307 OR c.id = 311 OR c.id = 312 OR c.id = 313 OR c.id = 314 OR c.id = 372 OR c.id = 328 OR c.id = 329 OR c.id = 330 OR c.id = 140 OR c.id = 339 OR c.id = 340 OR c.id = 341 OR c.id = 338 OR c.id = 331 OR c.id = 332 OR c.id = 342 OR c.id = 343 OR c.id = 344 OR c.id = 333 OR c.id = 126 OR c.id = 127 OR c.id = 128 OR c.id = 129 OR c.id = 130 OR c.id = 131 OR c.id = 132 OR c.id = 133 )
AND
c.extension = 'com_content'
AND
c.published = 1SELECT id, rules
FROM `h5490_viewlevels`SELECT DISTINCT
categories.title AS cat,
users.name AS author,
users.email AS author_email,
content.title AS title,
content.introtext AS text,
content.created AS date,
content.publish_up AS date_publish,
content.id AS IID,
content.hits AS hits,
content.access AS access,
content.images AS images,
content_rating.rating_sum AS rating_sum,
content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias)
THEN CONCAT_WS(":", content.id, content.alias)
ELSE content.id END as ID,
CASE WHEN CHAR_LENGTH(categories.alias)
THEN CONCAT_WS(":", categories.id, categories.alias)
ELSE categories.id END as CID
FROM
h5490_content AS content
LEFT JOIN
h5490_categories AS categories
ON categories.id = content.catid
LEFT JOIN
h5490_users AS users
ON users.id = content.created_by
LEFT JOIN
h5490_content_frontpage AS frontpage
ON content.id = frontpage.content_id
LEFT JOIN
h5490_content_rating AS content_rating
ON content_rating.content_id = content.id
WHERE
content.state = 1
AND content.access IN (1,1)
AND categories.published = 1
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2014-06-26 03:14:18' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2014-06-26 03:14:18' )
AND ( content.catid = 352 OR content.catid = 351 OR content.catid = 348 OR content.catid = 349 OR content.catid = 126 OR content.catid = 127 OR content.catid = 128 OR content.catid = 129 OR content.catid = 130 OR content.catid = 131 OR content.catid = 132 OR content.catid = 133 OR content.catid = 140 OR content.catid = 364 OR content.catid = 362 OR content.catid = 361 OR content.catid = 179 OR content.catid = 180 OR content.catid = 181 OR content.catid = 332 OR content.catid = 274 OR content.catid = 273 OR content.catid = 272 OR content.catid = 271 OR content.catid = 270 OR content.catid = 264 OR content.catid = 265 OR content.catid = 266 OR content.catid = 267 OR content.catid = 268 OR content.catid = 259 OR content.catid = 258 OR content.catid = 254 OR content.catid = 255 OR content.catid = 256 OR content.catid = 257 OR content.catid = 253 OR content.catid = 252 OR content.catid = 251 OR content.catid = 250 OR content.catid = 275 OR content.catid = 276 OR content.catid = 277 OR content.catid = 278 OR content.catid = 279 OR content.catid = 280 OR content.catid = 281 OR content.catid = 282 OR content.catid = 283 OR content.catid = 284 OR content.catid = 285 OR content.catid = 286 OR content.catid = 287 OR content.catid = 288 OR content.catid = 291 OR content.catid = 292 OR content.catid = 293 OR content.catid = 294 OR content.catid = 295 OR content.catid = 296 OR content.catid = 297 OR content.catid = 298 OR content.catid = 299 OR content.catid = 300 OR content.catid = 301 OR content.catid = 302 OR content.catid = 303 OR content.catid = 305 OR content.catid = 307 OR content.catid = 311 OR content.catid = 312 OR content.catid = 313 OR content.catid = 314 OR content.catid = 315 OR content.catid = 316 OR content.catid = 317 OR content.catid = 318 OR content.catid = 319 OR content.catid = 324 OR content.catid = 331 OR content.catid = 330 OR content.catid = 328 OR content.catid = 329 OR content.catid = 333 OR content.catid = 350 OR content.catid = 347 OR content.catid = 346 OR content.catid = 363 OR content.catid = 360 OR content.catid = 338 OR content.catid = 339 OR content.catid = 340 OR content.catid = 341 OR content.catid = 342 OR content.catid = 343 OR content.catid = 344 OR content.catid = 368 OR content.catid = 369 OR content.catid = 370 OR content.catid = 372 )
ORDER BY
content.created DESC
LIMIT
0,16;SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM h5490_categories as c
LEFT JOIN h5490_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM h5490_categories AS cat JOIN h5490_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=180
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM h5490_categories as c
LEFT JOIN h5490_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM h5490_categories AS cat JOIN h5490_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=364
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM h5490_categories as c
LEFT JOIN h5490_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM h5490_categories AS cat JOIN h5490_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=288
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM h5490_categories as c
LEFT JOIN h5490_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM h5490_categories AS cat JOIN h5490_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=287
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM h5490_categories as c
LEFT JOIN h5490_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM h5490_categories AS cat JOIN h5490_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=296
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM h5490_categories as c
LEFT JOIN h5490_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM h5490_categories AS cat JOIN h5490_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=259
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM h5490_categories as c
LEFT JOIN h5490_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM h5490_categories AS cat JOIN h5490_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=282
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM h5490_categories as c
LEFT JOIN h5490_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM h5490_categories AS cat JOIN h5490_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=370
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM h5490_categories as c
LEFT JOIN h5490_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM h5490_categories AS cat JOIN h5490_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=251
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM h5490_categories as c
LEFT JOIN h5490_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM h5490_categories AS cat JOIN h5490_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=267
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftUPDATE `h5490_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:9;s:19:\"session.timer.start\";i:1403752385;s:18:\"session.timer.last\";i:1403752451;s:17:\"session.timer.now\";i:1403752457;s:24:\"session.client.forwarded\";s:14:\"174.129.228.67\";s:22:\"session.client.browser\";s:75:\"ia_archiver (+http://www.alexa.com/site/help/webmasters; [email protected])\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:9:{s:40:\"fbfa5069d751796b9d17b9104096c12a93bc7402\";O:8:\"stdClass\":2:{s:4:\"link\";s:117:\"http://www.eproini.gr/index.php/ileia/38232-liatsis-tha-apokatastisoume-me-kathe-tropo-tin-aksioprepeia-ton-pyrgioton\";s:6:\"expiry\";i:1403752391;}s:40:\"2087179705623b4bd9310566c1b1501e50f6f2c5\";O:8:\"stdClass\":2:{s:4:\"link\";s:116:\"http://www.eproini.gr/index.php/ileia/ileia-kampos/38219-stin-andravida-nekros-voylgaros-pou-etroge-apo-ta-skoupidia\";s:6:\"expiry\";i:1403752400;}s:40:\"c600713ec2a313d2b1b8dd4eaca3284921d3f16b\";O:8:\"stdClass\":2:{s:4:\"link\";s:129:\"http://www.eproini.gr/index.php/menu-ellada-koinonia/38236-paidikoi-stathmoi-espa-allazoun-ta-kritiria-pote-ksekinoyn-oi-aitiseis\";s:6:\"expiry\";i:1403752408;}s:40:\"e4e7cfd0114a3eeb4a1145cd7cfbd00084134eb7\";O:8:\"stdClass\":2:{s:4:\"link\";s:118:\"http://www.eproini.gr/index.php/menu-politismos-ekdiloseis/38185-deksameni-diimero-afieromeno-se-draseis-ekpaideftikon\";s:6:\"expiry\";i:1403752419;}s:40:\"c72bcefb2b3381328180a247be83986b04966201\";O:8:\"stdClass\":2:{s:4:\"link\";s:140:\"http://www.eproini.gr/index.php/menu-politismos-ekdiloseis/38213-22-laografikos-xoreftikos-omilos-giortasan-to-finale-tis-xronias-xoreyontas\";s:6:\"expiry\";i:1403752428;}s:40:\"7a1eda1fdd482f99dcf9d1f135cf030d6b842dde\";O:8:\"stdClass\":2:{s:4:\"link\";s:152:\"http://www.eproini.gr/index.php/politiki/361-pol-tel-nea/38234-ggg-liatsis-ston-pyrgo-tha-epanelthei-to-tmima-mme-kai-pliroforikis-giati-mas-to-xrostane\";s:6:\"expiry\";i:1403752438;}s:40:\"c4543c34bda8d407c80443afc746ff748be8292d\";O:8:\"stdClass\":2:{s:4:\"link\";s:113:\"http://www.eproini.gr/index.php/politismos/politismos-mousiki/38198-mikti-xorodia-pyrgou-enas-pyrgos-apo-ta-palia\";s:6:\"expiry\";i:1403752447;}s:40:\"10c795e753e73c5c6673feab8152539079beee2c\";O:8:\"stdClass\":2:{s:4:\"link\";s:77:\"http://www.eproini.gr/index.php/proini/proini-gumnastiki/38223-piran-diazygio\";s:6:\"expiry\";i:1403752451;}s:40:\"c361b8f8384655fc3888fd8079bdcc82750cc426\";O:8:\"stdClass\":2:{s:4:\"link\";s:83:\"http://www.eproini.gr/index.php/proini/proini-gumnastiki/38225-11apotelei-eksairesi\";s:6:\"expiry\";i:1403752458;}}s:13:\"session.token\";s:32:\"727bb177c7316fb0be3b714e8878d8ba\";}'
, `time` = '1403752460'
WHERE `session_id` = 'g33cr15tccvd2i5o2fo9mglfj7'12 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM h5490_categories as c
LEFT JOIN h5490_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM h5490_categories AS cat JOIN h5490_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt2 × SELECT alias, catid
FROM h5490_content2 × SELECT h5490_autotweet_automator.*
FROM h5490_autotweet_automator1 × SELECT DISTINCT c.id AS CID
FROM h5490_categories AS c
LEFT JOIN h5490_content AS content
ON c.id = content.catid1 × SELECT id, rules
FROM `h5490_viewlevels1 × SELECT DISTINCT categories.title AS cat, users.name AS author, users.email AS author_email, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.id AS IID, content.hits AS hits, content.access AS access, content.images AS images, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as ID,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as CID
FROM h5490_content AS content
LEFT JOIN h5490_categories AS categories
ON categories.id = content.catid
LEFT JOIN h5490_users AS users
ON users.id = content.created_by
LEFT JOIN h5490_content_frontpage AS frontpage
ON content.id = frontpage.content_id
LEFT JOIN h5490_content_rating AS content_rating
ON content_rating.content_id = content.id1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id
FROM h5490_contact_details AS contact1 × SELECT b.id
FROM h5490_usergroups AS a
LEFT JOIN h5490_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT count(*)
FROM `h5490_cwtraffic`1 × SELECT `data`
FROM `h5490_session`1 × SELECT b.rules
FROM h5490_assets AS a
LEFT JOIN h5490_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM h5490_menu AS m
LEFT JOIN h5490_extensions AS e
ON m.component_id = e.extension_id1 × UPDATE `h5490_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:9;s:19:\"session.timer.start\";i:1403752385;s:18:\"session.timer.last\";i:1403752451;s:17:\"session.timer.now\";i:1403752457;s:24:\"session.client.forwarded\";s:14:\"174.129.228.67\";s:22:\"session.client.browser\";s:75:\"ia_archiver (+http://www.alexa.com/site/help/webmasters; [email protected])\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:9:{s:40:\"fbfa5069d751796b9d17b9104096c12a93bc7402\";O:8:\"stdClass\":2:{s:4:\"link\";s:117:\"http://www.eproini.gr/index.php/ileia/38232-liatsis-tha-apokatastisoume-me-kathe-tropo-tin-aksioprepeia-ton-pyrgioton\";s:6:\"expiry\";i:1403752391;}s:40:\"2087179705623b4bd9310566c1b1501e50f6f2c5\";O:8:\"stdClass\":2:{s:4:\"link\";s:116:\"http://www.eproini.gr/index.php/ileia/ileia-kampos/38219-stin-andravida-nekros-voylgaros-pou-etroge-apo-ta-skoupidia\";s:6:\"expiry\";i:1403752400;}s:40:\"c600713ec2a313d2b1b8dd4eaca3284921d3f16b\";O:8:\"stdClass\":2:{s:4:\"link\";s:129:\"http://www.eproini.gr/index.php/menu-ellada-koinonia/38236-paidikoi-stathmoi-espa-allazoun-ta-kritiria-pote-ksekinoyn-oi-aitiseis\";s:6:\"expiry\";i:1403752408;}s:40:\"e4e7cfd0114a3eeb4a1145cd7cfbd00084134eb7\";O:8:\"stdClass\":2:{s:4:\"link\";s:118:\"http://www.eproini.gr/index.php/menu-politismos-ekdiloseis/38185-deksameni-diimero-afieromeno-se-draseis-ekpaideftikon\";s:6:\"expiry\";i:1403752419;}s:40:\"c72bcefb2b3381328180a247be83986b04966201\";O:8:\"stdClass\":2:{s:4:\"link\";s:140:\"http://www.eproini.gr/index.php/menu-politismos-ekdiloseis/38213-22-laografikos-xoreftikos-omilos-giortasan-to-finale-tis-xronias-xoreyontas\";s:6:\"expiry\";i:1403752428;}s:40:\"7a1eda1fdd482f99dcf9d1f135cf030d6b842dde\";O:8:\"stdClass\":2:{s:4:\"link\";s:152:\"http://www.eproini.gr/index.php/politiki/361-pol-tel-nea/38234-ggg-liatsis-ston-pyrgo-tha-epanelthei-to-tmima-mme-kai-pliroforikis-giati-mas-to-xrostane\";s:6:\"expiry\";i:1403752438;}s:40:\"c4543c34bda8d407c80443afc746ff748be8292d\";O:8:\"stdClass\":2:{s:4:\"link\";s:113:\"http://www.eproini.gr/index.php/politismos/politismos-mousiki/38198-mikti-xorodia-pyrgou-enas-pyrgos-apo-ta-palia\";s:6:\"expiry\";i:1403752447;}s:40:\"10c795e753e73c5c6673feab8152539079beee2c\";O:8:\"stdClass\":2:{s:4:\"link\";s:77:\"http://www.eproini.gr/index.php/proini/proini-gumnastiki/38223-piran-diazygio\";s:6:\"expiry\";i:1403752451;}s:40:\"c361b8f8384655fc3888fd8079bdcc82750cc426\";O:8:\"stdClass\":2:{s:4:\"link\";s:83:\"http://www.eproini.gr/index.php/proini/proini-gumnastiki/38225-11apotelei-eksairesi\";s:6:\"expiry\";i:1403752458;}}s:13:\"session.token\";s:32:\"727bb177c7316fb0be3b714e8878d8ba\";}' , `time` = '1403752460'1 × UPDATE h5490_content
SET hits = hits + 11 × SHOW FULL COLUMNS
FROM `h5490_autotweet_automator1 × SHOW TABLE1 × DELETE
FROM `h5490_session`