Μια κι έξω!

Σάββατο, 17 Μαΐου 2014 10:57
Γράφτηκε από τον/την NewsRoom

Μια κι έξω, από την πρώτη Κυριακή, αναμένεται – σύμφωνα με τους… εκλογομάγειρες- να τελειώσουν δύο τουλάχιστον δήμοι της Ηλείας, που φαίνεται να είναι οι δήμοι Ανδρίτσαινας- Κρεστένων και Ζαχάρως και παίζεται τουλάχιστον άλλος ένας, ίσως και δύο. Οι υπόλοιποι πάνε με σιγουριά για τον επαναληπτικό γύρο της 25^ης Μαίου, γιατί και να ήθελαν να τελειώσουν, δεν τους βγαίνει αριθμητικά το 50% +1. Οποιαδήποτε άλλη εκτίμηση, θα είναι έκπληξη που ούτε οι ίδιοι δεν θα την περιμένουν!.

Στις δε περιφερειακές, πάμε 100% στο δεύτερο γύρο και η αγωνία κορυφώνεται για το ποιοι θα είναι οι δύο που θα κόψουν το νήμα!

Κονσόλα Αποσφαλάτωσης του Joomla!

Καταγράφηκαν 36 ερωτήματα

SELECT `data` FROM `h5490_session` WHERE `session_id` = 'diiktdkskvejgn5g12lcdehn81'
DELETE FROM `h5490_session` WHERE `time` < '1403290409'
SELECT `session_id` FROM `h5490_session` WHERE `session_id` = 'diiktdkskvejgn5g12lcdehn81' LIMIT 0, 1
INSERT INTO `h5490_session` (`session_id`, `client_id`, `time`) VALUES ('diiktdkskvejgn5g12lcdehn81', 0, '1403291309')
SELECT 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 = 1
SELECT id, rules FROM `h5490_viewlevels`
SELECT count(*) FROM `h5490_cwtraffic` WHERE ip = '174.129.228.67' AND tm + '3600'>'1403291309'
INSERT INTO `h5490_cwtraffic` (tm, ip) VALUES ('1403291309','174.129.228.67')
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.lft
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=36598 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.lft
SELECT alias, catid FROM h5490_content WHERE id = 36598
SHOW TABLES
SHOW 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 a.rules FROM h5490_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
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.lft
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 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 = 36598 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-06-20 19:08:30') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-06-20 19:08:30') 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=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.lft
UPDATE h5490_content SET hits = hits + 1 WHERE id = 36598
SELECT alias, catid FROM h5490_content WHERE id = 36598
SELECT 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 = 1
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-20 19:08:30' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2014-06-20 19:08:30' ) 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=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.lft
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=253 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.lft
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=299 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.lft
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=283 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.lft
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=254 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.lft
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=255 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.lft
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=252 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.lft
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=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.lft
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=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.lft
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=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.lft
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.lft
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=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.lft
UPDATE `h5490_session` SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1403291309;s:18:\"session.timer.last\";i:1403291309;s:17:\"session.timer.now\";i:1403291309;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:1:{s:40:\"6a8193f0ab7522143fffad6cd2a8d068d4ce13a5\";O:8:\"stdClass\":2:{s:4:\"link\";s:73:\"http://www.eproini.gr/index.php/proini/proini-ta-proina/36598-mia-ki-ekso\";s:6:\"expiry\";i:1403291310;}}s:13:\"session.token\";s:32:\"3a33934924f5a5898279e0f1ea10ea2a\";}' , `time` = '1403291312' WHERE `session_id` = 'diiktdkskvejgn5g12lcdehn81'

Καταγράφηκαν 21 είδη ερωτημάτων και ταξινομήθηκαν κατά την εμφάνισή τους.

ΕΠΙΛΟΓΗ από Πίνακες:

14 × 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
2 × SELECT h5490_autotweet_automator.* FROM h5490_autotweet_automator
2 × SELECT alias, catid FROM h5490_content
1 × SELECT b.rules FROM h5490_assets AS a LEFT JOIN h5490_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × 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 contact
1 × SELECT DISTINCT c.id AS CID FROM h5490_categories AS c LEFT JOIN h5490_content AS content ON c.id = content.catid
1 × 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
1 × SELECT a.rules FROM h5490_assets AS a
1 × SELECT b.id FROM h5490_usergroups AS a LEFT JOIN h5490_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × 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_id
1 × SELECT `data` FROM `h5490_session`
1 × SELECT `session_id` FROM `h5490_session`
1 × SELECT id, rules FROM `h5490_viewlevels

ΑΛΛΟΙ Πίνακες:

1 × UPDATE h5490_content SET hits = hits + 1
1 × UPDATE `h5490_session` SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1403291309;s:18:\"session.timer.last\";i:1403291309;s:17:\"session.timer.now\";i:1403291309;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:1:{s:40:\"6a8193f0ab7522143fffad6cd2a8d068d4ce13a5\";O:8:\"stdClass\":2:{s:4:\"link\";s:73:\"http://www.eproini.gr/index.php/proini/proini-ta-proina/36598-mia-ki-ekso\";s:6:\"expiry\";i:1403291310;}}s:13:\"session.token\";s:32:\"3a33934924f5a5898279e0f1ea10ea2a\";}' , `time` = '1403291312'
1 × SHOW FULL COLUMNS FROM `h5490_autotweet_automator
1 × SHOW TABLE
1 × INSERT INTO `h5490_session` (`session_id`, `client_id`, `time`) VALUES ('diiktdkskvejgn5g12lcdehn81', 0, '1403291309'
1 × INSERT INTO `h5490_cwtraffic` (tm, ip) VALUES ('1403291309','174.129.228.67'
1 × DELETE FROM `h5490_session`

Καρπούζι Ηλείας καμουφλάζ…

Tέσσερα παιδιά της Αμαλιά…

Μικτή χορωδία Πύργου: Με…

Η ΣΕΦΑ διδάσκει τα «μυστι…

Πελόπιο : Συνελήφθη 67χρο…

Αναβολή χθες στην εκδίκασ…

Εμπορικός Σύλλογος Πύργου…

Αυτοκτόνησε 24χρονος που…

Digea: Νέα ψηφιακή εποχή …

Έρχονται αυξήσεις στη ΔΕΗ

Τραγωδία στη Νίκαια -Ενας…

Δάσκαλοι: Η καθολική αντί…

Πτώση των βάσεων σε δύο ε…

Όποιον πάρει η…αξιολόγηση…

Ο Μέγας Αλέξανδρος και ο …

Έφυγε ο Γιάννης Γιαννόπο…

Μια κι έξω!

Ηλεια

Ελλαδα

Κοσμος

Πολιτικη

Οικονομια

Αθλητικα

Κονσόλα Αποσφαλάτωσης του Joomla!

Συνεδρία

__default

user

com_mailto.links

6a8193f0ab7522143fffad6cd2a8d068d4ce13a5

Πληροφορίες Προφίλ

Χρήση Μνήμης

Ερωτήματα Βάσης Δεδομένων

Καταγράφηκαν 36 ερωτήματα

Καταγράφηκαν 21 είδη ερωτημάτων και ταξινομήθηκαν κατά την εμφάνισή τους.

ΕΠΙΛΟΓΗ από Πίνακες:

ΑΛΛΟΙ Πίνακες: