Συνέβη και αυτό στον Πύργο. Άγνωστοι έβαλαν στο μάτι χώρο στάθμευσης και το ποσό που είχε συγκεντρωθεί από το αντίτιμο της φύλαξης των αυτοκινήτων. Τα 150 ευρώ σε κέρματα που υπήρχαν στο συρτάρι του ταμείου έκαναν «φτερά». Για την ιστορία, οι δράστες μπήκαν στο κουβούκλιο του πάρκινγκ κόβωντας τα κάγκελα του παραθύρου και σπάζοντας αυτό.
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/agrotika/agrotika-tel-nea/38360-aaaa-proslipseis-gia-ti-dakoktonia
link ⇒ http://www.eproini.gr/index.php/arthografia/diafora/38284-o-kostas-karamanlis-i-kina-o-agogos-kai-to-lefta-yparxoun
link ⇒ http://www.eproini.gr/index.php/arthografia/diafora/38347-pagkosmia-imera-kata-ton-narkotikon-oi-xristes-kai-oi-oikogeneies-tous-zitoyn-apantiseis
link ⇒ http://www.eproini.gr/index.php/athlitika/athlitika-ileia/38364-to-thriamvo-treis-pyrgiotes
link ⇒ http://www.eproini.gr/index.php/ellada/ellada-astunomika/38329-akoma-dyo-syllipseis-gia-tin-listeia-sto-lefkoxori
link ⇒ http://www.eproini.gr/index.php/ellada/ellada-astunomika/38336-pyrgos-eklepsan-ta-xrimata-apo-parkingk
session.token ⇒ 729953287b9f5573f7f663ea53ca8a70
Application 0.001 seconds (+0.001); 1.21 MB (+1.208) - afterLoadApplication 0.446 seconds (+0.446); 6.76 MB (+5.550) - afterInitialiseApplication 0.495 seconds (+0.048); 10.87 MB (+4.109) - afterRouteApplication 0.573 seconds (+0.078); 15.58 MB (+4.716) - afterDispatchApplication 0.754 seconds (+0.181); 18.29 MB (+2.708) - beforeRenderModule mod_login (Login)Application 0.763 seconds (+0.009); 18.42 MB (+0.127) - afterRenderModule mod_login (Login)Application 0.768 seconds (+0.006); 18.44 MB (+0.020) - beforeRenderModule mod_weather_gk4 (Ο Καιρος)Application 6.147 seconds (+5.379); 18.97 MB (+0.531) - afterRenderModule mod_weather_gk4 (Ο Καιρος)Application 6.150 seconds (+0.003); 18.96 MB (-0.008) - beforeRenderModule mod_tcvn_banner_slider (Καιρός Ηλεία)Application 6.174 seconds (+0.024); 19.27 MB (+0.313) - afterRenderModule mod_tcvn_banner_slider (Καιρός Ηλεία)Application 6.183 seconds (+0.008); 19.26 MB (-0.013) - beforeRenderModule mod_tcvn_banner_slider (Ζώδια)Application 6.190 seconds (+0.007); 19.28 MB (+0.021) - afterRenderModule mod_tcvn_banner_slider (Ζώδια)Application 6.201 seconds (+0.011); 19.27 MB (-0.016) - beforeRenderModule mod_tcvn_banner_slider (webcam)Application 6.210 seconds (+0.009); 19.29 MB (+0.021) - afterRenderModule mod_tcvn_banner_slider (webcam)Application 6.219 seconds (+0.009); 19.27 MB (-0.015) - beforeRenderModule mod_tcvn_banner_slider (Δευτερη Σελιδα 219Χ122 Θέση 002-inset)Application 6.226 seconds (+0.006); 19.30 MB (+0.024) - afterRenderModule mod_tcvn_banner_slider (Δευτερη Σελιδα 219Χ122 Θέση 002-inset)Application 6.230 seconds (+0.004); 19.28 MB (-0.012) - beforeRenderModule mod_tcvn_banner_slider (Εσωτερικες σελιδες 219Χ122 Θέση 001-Αριστερή λωρίδα)Application 6.235 seconds (+0.006); 19.30 MB (+0.016) - afterRenderModule mod_tcvn_banner_slider (Εσωτερικες σελιδες 219Χ122 Θέση 001-Αριστερή λωρίδα)Application 6.243 seconds (+0.007); 19.29 MB (-0.012) - beforeRenderModule mod_tcvn_banner_slider (Εσωτερικες σελιδες 219Χ122 Θέση 002-Αριστερή λωρίδα)Application 6.248 seconds (+0.005); 19.30 MB (+0.016) - afterRenderModule mod_tcvn_banner_slider (Εσωτερικες σελιδες 219Χ122 Θέση 002-Αριστερή λωρίδα)Application 6.252 seconds (+0.004); 19.29 MB (-0.012) - beforeRenderModule mod_tcvn_banner_slider (Εσωτερικες σελιδες 219Χ122 Θέση 003-Αριστερή λωρίδα)Application 6.258 seconds (+0.006); 19.31 MB (+0.016) - afterRenderModule mod_tcvn_banner_slider (Εσωτερικες σελιδες 219Χ122 Θέση 003-Αριστερή λωρίδα)Application 6.262 seconds (+0.004); 19.30 MB (-0.009) - beforeRenderModule mod_news_pro_gk4 (Top banner)Application 9.754 seconds (+3.492); 21.33 MB (+2.026) - afterRenderModule mod_news_pro_gk4 (Top banner)Application 9.775 seconds (+0.020); 21.29 MB (-0.037) - afterRender21.34 MB (22,379,856 Bytes)SELECT `data`
FROM `h5490_session`
WHERE `session_id` = 'vs54ng2tqda52olcqkhfg0gmo4'DELETE
FROM `h5490_session`
WHERE `time` < '1403846773'SELECT count(*)
FROM `h5490_cwtraffic`
WHERE ip = '174.129.228.67'
AND tm + '3600'>'1403847673'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=38336
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 = 38336SHOW 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 = 38336
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-06-27 05:41:13')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-06-27 05:41:13')
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=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.lftUPDATE h5490_content
SET hits = hits + 1
WHERE id = 38336SELECT alias, catid
FROM h5490_content
WHERE id = 38336SELECT *
FROM h5490_banners
WHERE '2014-06-27 05:41:13' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM h5490_banners as a
LEFT JOIN h5490_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (217)
ORDER BY a.sticky DESC,a.orderingSELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM h5490_banners as a
LEFT JOIN h5490_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (217)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 5UPDATE h5490_banners
SET impmade = (impmade + 1)
WHERE id = 78SELECT *
FROM h5490_banners
WHERE '2014-06-27 05:41:13' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM h5490_banners as a
LEFT JOIN h5490_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (219)
ORDER BY a.sticky DESC,a.orderingSELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM h5490_banners as a
LEFT JOIN h5490_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (219)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 5UPDATE h5490_banners
SET impmade = (impmade + 1)
WHERE id = 80SELECT *
FROM h5490_banners
WHERE '2014-06-27 05:41:13' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM h5490_banners as a
LEFT JOIN h5490_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (221)
ORDER BY a.sticky DESC,a.orderingSELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM h5490_banners as a
LEFT JOIN h5490_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (221)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 5UPDATE h5490_banners
SET impmade = (impmade + 1)
WHERE id = 82SELECT *
FROM h5490_banners
WHERE '2014-06-27 05:41:13' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM h5490_banners as a
LEFT JOIN h5490_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (322)
ORDER BY a.sticky DESC,a.orderingSELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM h5490_banners as a
LEFT JOIN h5490_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (322)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 10SELECT *
FROM h5490_banners
WHERE '2014-06-27 05:41:13' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM h5490_banners as a
LEFT JOIN h5490_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (321)
ORDER BY a.sticky DESC,RAND()SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM h5490_banners as a
LEFT JOIN h5490_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (321)
ORDER BY a.sticky DESC,RAND()
LIMIT 0, 10SELECT *
FROM h5490_banners
WHERE '2014-06-27 05:41:13' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM h5490_banners as a
LEFT JOIN h5490_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (322)
ORDER BY a.sticky DESC,RAND()SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM h5490_banners as a
LEFT JOIN h5490_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (322)
ORDER BY a.sticky DESC,RAND()
LIMIT 0, 10SELECT *
FROM h5490_banners
WHERE '2014-06-27 05:41:13' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM h5490_banners as a
LEFT JOIN h5490_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (323)
ORDER BY a.sticky DESC,RAND()SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM h5490_banners as a
LEFT JOIN h5490_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (323)
ORDER BY a.sticky DESC,RAND()
LIMIT 0, 10SELECT 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-27 05:41:19' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2014-06-27 05:41:19' )
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=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=272
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=305
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=307
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=285
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=270
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=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=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=266
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=256
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:6;s:19:\"session.timer.start\";i:1403847217;s:18:\"session.timer.last\";i:1403847657;s:17:\"session.timer.now\";i:1403847673;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:6:{s:40:\"0f929233e4e8d2eca503e7e433ff03d669f2ca2e\";O:8:\"stdClass\":2:{s:4:\"link\";s:98:\"http://www.eproini.gr/index.php/agrotika/agrotika-tel-nea/38360-aaaa-proslipseis-gia-ti-dakoktonia\";s:6:\"expiry\";i:1403847219;}s:40:\"2dfa4df2a4ae80fe7b72844743dca31aca7353fa\";O:8:\"stdClass\":2:{s:4:\"link\";s:115:\"http://www.eproini.gr/index.php/arthografia/diafora/38284-o-kostas-karamanlis-i-kina-o-agogos-kai-to-lefta-yparxoun\";s:6:\"expiry\";i:1403847430;}s:40:\"e426c72a3ae040460477287f5ffad13a21943201\";O:8:\"stdClass\":2:{s:4:\"link\";s:146:\"http://www.eproini.gr/index.php/arthografia/diafora/38347-pagkosmia-imera-kata-ton-narkotikon-oi-xristes-kai-oi-oikogeneies-tous-zitoyn-apantiseis\";s:6:\"expiry\";i:1403847444;}s:40:\"04b40b1caa8b03e1b86d0252f729a9f211784dcb\";O:8:\"stdClass\":2:{s:4:\"link\";s:91:\"http://www.eproini.gr/index.php/athlitika/athlitika-ileia/38364-to-thriamvo-treis-pyrgiotes\";s:6:\"expiry\";i:1403847458;}s:40:\"03f4207fc7f6b6ebcf2e225eeeacbbb357f1528e\";O:8:\"stdClass\":2:{s:4:\"link\";s:113:\"http://www.eproini.gr/index.php/ellada/ellada-astunomika/38329-akoma-dyo-syllipseis-gia-tin-listeia-sto-lefkoxori\";s:6:\"expiry\";i:1403847662;}s:40:\"75f886418163d7c209f583aec360bb3c8e91f547\";O:8:\"stdClass\":2:{s:4:\"link\";s:102:\"http://www.eproini.gr/index.php/ellada/ellada-astunomika/38336-pyrgos-eklepsan-ta-xrimata-apo-parkingk\";s:6:\"expiry\";i:1403847673;}}s:13:\"session.token\";s:32:\"729953287b9f5573f7f663ea53ca8a70\";}'
, `time` = '1403847682'
WHERE `session_id` = 'vs54ng2tqda52olcqkhfg0gmo4'14 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM h5490_banners as a
LEFT JOIN h5490_banner_clients AS cl
ON cl.id = a.cid13 × 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.rgt7 × SELECT *
FROM h5490_banners2 × SELECT h5490_autotweet_automator.*
FROM h5490_autotweet_automator2 × SELECT alias, catid
FROM h5490_content1 × 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 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 b.rules
FROM h5490_assets AS a
LEFT JOIN h5490_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT count(*)
FROM `h5490_cwtraffic`1 × 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 × SELECT `data`
FROM `h5490_session`1 × 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 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 contact3 × UPDATE h5490_banners
SET impmade = (impmade + 1)1 × UPDATE `h5490_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:6;s:19:\"session.timer.start\";i:1403847217;s:18:\"session.timer.last\";i:1403847657;s:17:\"session.timer.now\";i:1403847673;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:6:{s:40:\"0f929233e4e8d2eca503e7e433ff03d669f2ca2e\";O:8:\"stdClass\":2:{s:4:\"link\";s:98:\"http://www.eproini.gr/index.php/agrotika/agrotika-tel-nea/38360-aaaa-proslipseis-gia-ti-dakoktonia\";s:6:\"expiry\";i:1403847219;}s:40:\"2dfa4df2a4ae80fe7b72844743dca31aca7353fa\";O:8:\"stdClass\":2:{s:4:\"link\";s:115:\"http://www.eproini.gr/index.php/arthografia/diafora/38284-o-kostas-karamanlis-i-kina-o-agogos-kai-to-lefta-yparxoun\";s:6:\"expiry\";i:1403847430;}s:40:\"e426c72a3ae040460477287f5ffad13a21943201\";O:8:\"stdClass\":2:{s:4:\"link\";s:146:\"http://www.eproini.gr/index.php/arthografia/diafora/38347-pagkosmia-imera-kata-ton-narkotikon-oi-xristes-kai-oi-oikogeneies-tous-zitoyn-apantiseis\";s:6:\"expiry\";i:1403847444;}s:40:\"04b40b1caa8b03e1b86d0252f729a9f211784dcb\";O:8:\"stdClass\":2:{s:4:\"link\";s:91:\"http://www.eproini.gr/index.php/athlitika/athlitika-ileia/38364-to-thriamvo-treis-pyrgiotes\";s:6:\"expiry\";i:1403847458;}s:40:\"03f4207fc7f6b6ebcf2e225eeeacbbb357f1528e\";O:8:\"stdClass\":2:{s:4:\"link\";s:113:\"http://www.eproini.gr/index.php/ellada/ellada-astunomika/38329-akoma-dyo-syllipseis-gia-tin-listeia-sto-lefkoxori\";s:6:\"expiry\";i:1403847662;}s:40:\"75f886418163d7c209f583aec360bb3c8e91f547\";O:8:\"stdClass\":2:{s:4:\"link\";s:102:\"http://www.eproini.gr/index.php/ellada/ellada-astunomika/38336-pyrgos-eklepsan-ta-xrimata-apo-parkingk\";s:6:\"expiry\";i:1403847673;}}s:13:\"session.token\";s:32:\"729953287b9f5573f7f663ea53ca8a70\";}' , `time` = '1403847682'1 × UPDATE h5490_content
SET hits = hits + 11 × SHOW FULL COLUMNS
FROM `h5490_autotweet_automator1 × SHOW TABLE1 × DELETE
FROM `h5490_session`