ΕΣΗΕΑ: Διαγωνισμός-παρωδία για προσλήψεις δημοσιογράφων στη ΝΕΡΙΤ

Τρίτη, 17 Ιουνίου 2014 15:37
Γράφτηκε από τον/την NewsRoom

Η ΕΣΗΕΑ εξέδωσε την παρακάτω ανακοίνωση, αναφορικά με τον διαγωνισμό για τις προσλήψεις δημοσιογράφων στη ΝΕΡΙΤ:

‘Το Διοικητικό Συμβούλιο της ΕΣΗΕΑ για ακόμη μια φορά καταγγέλλει τον διαγωνισμό-παρωδία που εξελίσσεται για τις υποτιθέμενες αξιοκρατικές προσλήψεις δημοσιογράφων στη ΝΕΡΙΤ.

Πληροφορούμαστε ότι από σήμερα, ουσιαστικά εν κρυπτώ, καλούνται συνάδελφοι δημοσιογράφοι να «περάσουν από συνέντευξη», γεγονός που με βάση την προκήρυξη αποτελεί το δεύτερο στάδιο του διαγωνισμού. Μόνο που το πρώτο στάδιο παραμένει ακόμη ανοιχτό, αφού μετά τις εκατοντάδες ενστάσεις που υποβλήθηκαν, ουδείς γνωρίζει αν υπάρχει και πώς έχει διαμορφωθεί η κατάταξη των υποψηφίων με βάση τα αντικειμενικά κριτήρια (πτυχία, προϋπηρεσία κ.λπ.).

Με ποια δεδομένα καλούνται τώρα δημοσιογράφοι να μπουν στη δεύτερη φάση του διαγωνισμού και μάλιστα μυστικά;

Το Δ.Σ. της ΕΣΗΕΑ θεωρεί αδιανόητο συνάδελφοι δημοσιογράφοι να νομιμοποιήσουν με τη συμμετοχή τους μια τέτοια διαβλητή διαδικασία, που κινείται έξω από κάθε έννοια διαφάνειας, αξιοκρατίας και δεοντολογίας”.

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

__default

session.client.forwarded ⇒ 174.129.228.67

session.client.browser ⇒ ia_archiver (+http://www.alexa.com/site/help/webmasters; [email protected])

user

password_clear ⇒

groups ⇒

com_mailto.links

session.token ⇒ 435fd9557e4b410959db0274a2df8873

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

SELECT `data` FROM `h5490_session` WHERE `session_id` = 'a9eugm6hhn2e9im3ounlaq6qc1'
SELECT count(*) FROM `h5490_cwtraffic` WHERE ip = '174.129.228.67' AND tm + '3600'>'1403132426'
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=37965 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 = 37965
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 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 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 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 = 37965 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-06-18 23:00:26') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-06-18 23:00:26') 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=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.lft
UPDATE h5490_content SET hits = hits + 1 WHERE id = 37965
SELECT alias, catid FROM h5490_content WHERE id = 37965
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 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-18 23:00:27' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2014-06-18 23:00:27' ) 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=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=312 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=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=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.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=360 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=181 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=302 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=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.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=291 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=301 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=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_session` SET `data` = '__default|a:10:{s:15:\"session.counter\";i:12;s:19:\"session.timer.start\";i:1403132365;s:18:\"session.timer.last\";i:1403132417;s:17:\"session.timer.now\";i:1403132426;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:12:{s:40:\"15a53a1ba685601a5aea4dcf936cc7de8fbfd9dc\";O:8:\"stdClass\":2:{s:4:\"link\";s:164:\"http://www.eproini.gr/index.php/agrotika/agrotika-tel-nea/37945-anthrakes-o-thisavros-molis-65-ekat-evro-apo-ta-psea-gia-tin-akarpia-tis-elias-kai-se-vathos-dietias\";s:6:\"expiry\";i:1403132366;}s:40:\"ca67305897664e08e9d4a7f475ce806e4bdfc53e\";O:8:\"stdClass\":2:{s:4:\"link\";s:90:\"http://www.eproini.gr/index.php/arthografia/arthografia-koinonia/37970-2014-06-17-17-58-42\";s:6:\"expiry\";i:1403132372;}s:40:\"769f5f7d91beab8ae4699c9ba7dc586d59059f0c\";O:8:\"stdClass\":2:{s:4:\"link\";s:142:\"http://www.eproini.gr/index.php/arthografia/arthografia-oikonomika/37966-ixitiko-o-enallaktikos-dromos-eksodou-apo-tin-krisi-einai-realistikos\";s:6:\"expiry\";i:1403132377;}s:40:\"e5ae6428da994c59ac6a73bd5060de497ec89890\";O:8:\"stdClass\":2:{s:4:\"link\";s:96:\"http://www.eproini.gr/index.php/arthografia/arthrografia-arthra/37930-kata-fantasian-fantasiakos\";s:6:\"expiry\";i:1403132382;}s:40:\"14c8a52d55be79b4c277aaf95f2f755e043caa33\";O:8:\"stdClass\":2:{s:4:\"link\";s:77:\"http://www.eproini.gr/index.php/ellada/menu-paideia/37967-2014-06-17-15-13-48\";s:6:\"expiry\";i:1403132387;}s:40:\"58c2b2d13993abd8262e38ffab06c113fdfef909\";O:8:\"stdClass\":2:{s:4:\"link\";s:115:\"http://www.eproini.gr/index.php/ileia/ileia-amaliada/37958-anthropini-allileggyi-amaliada-fagito-gia-80-oikogeneies\";s:6:\"expiry\";i:1403132393;}s:40:\"a7e7947461ce472cb6f1751511d21acdd2851a48\";O:8:\"stdClass\":2:{s:4:\"link\";s:88:\"http://www.eproini.gr/index.php/lifestyle/37963-ekapsan-zontano-ton-diasimo-greek-kamaki\";s:6:\"expiry\";i:1403132399;}s:40:\"e37dae35b35bd947c2efa3631ad4654c66650160\";O:8:\"stdClass\":2:{s:4:\"link\";s:86:\"http://www.eproini.gr/index.php/lifestyle/37968-synelifthi-o-remos-gia-xrei-tou-irakli\";s:6:\"expiry\";i:1403132403;}s:40:\"fb855df5eac3ca626071ce459d3f7924f48f426e\";O:8:\"stdClass\":2:{s:4:\"link\";s:101:\"http://www.eproini.gr/index.php/menu-ellada-koinonia/37969-foto-aftos-einai-o-satanistis-tis-glyfadas\";s:6:\"expiry\";i:1403132408;}s:40:\"90e08d558d4487068deaadf34090d6b583f81c8d\";O:8:\"stdClass\":2:{s:4:\"link\";s:121:\"http://www.eproini.gr/index.php/menu-ileia-purgos/37931-d-s-pyrgou-diaparataksiaki-synergasia-gia-to-thema-ton-skoupidion\";s:6:\"expiry\";i:1403132413;}s:40:\"0e83c59a2b13127e639b2fcebf5373766e4ecc31\";O:8:\"stdClass\":2:{s:4:\"link\";s:103:\"http://www.eproini.gr/index.php/oikonomia/oikonomia-teleutaia-nea/37964-veto-kai-sto-espa-apo-ti-troika\";s:6:\"expiry\";i:1403132420;}s:40:\"2e9d700b0c7e45ececfb5ebcc2e559bb4030d9b9\";O:8:\"stdClass\":2:{s:4:\"link\";s:128:\"http://www.eproini.gr/index.php/politiki/politiki-ellada/37965-esiea-diagonismos-parodia-gia-proslipseis-dimosiografon-sti-nerit\";s:6:\"expiry\";i:1403132426;}}s:13:\"session.token\";s:32:\"435fd9557e4b410959db0274a2df8873\";}' , `time` = '1403132428' WHERE `session_id` = 'a9eugm6hhn2e9im3ounlaq6qc1'

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

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

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
2 × SELECT alias, catid FROM h5490_content
2 × SELECT h5490_autotweet_automator.* FROM h5490_autotweet_automator
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 id, rules FROM `h5490_viewlevels
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.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 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 `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.rgt
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 × UPDATE `h5490_session` SET `data` = '__default|a:10:{s:15:\"session.counter\";i:12;s:19:\"session.timer.start\";i:1403132365;s:18:\"session.timer.last\";i:1403132417;s:17:\"session.timer.now\";i:1403132426;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:12:{s:40:\"15a53a1ba685601a5aea4dcf936cc7de8fbfd9dc\";O:8:\"stdClass\":2:{s:4:\"link\";s:164:\"http://www.eproini.gr/index.php/agrotika/agrotika-tel-nea/37945-anthrakes-o-thisavros-molis-65-ekat-evro-apo-ta-psea-gia-tin-akarpia-tis-elias-kai-se-vathos-dietias\";s:6:\"expiry\";i:1403132366;}s:40:\"ca67305897664e08e9d4a7f475ce806e4bdfc53e\";O:8:\"stdClass\":2:{s:4:\"link\";s:90:\"http://www.eproini.gr/index.php/arthografia/arthografia-koinonia/37970-2014-06-17-17-58-42\";s:6:\"expiry\";i:1403132372;}s:40:\"769f5f7d91beab8ae4699c9ba7dc586d59059f0c\";O:8:\"stdClass\":2:{s:4:\"link\";s:142:\"http://www.eproini.gr/index.php/arthografia/arthografia-oikonomika/37966-ixitiko-o-enallaktikos-dromos-eksodou-apo-tin-krisi-einai-realistikos\";s:6:\"expiry\";i:1403132377;}s:40:\"e5ae6428da994c59ac6a73bd5060de497ec89890\";O:8:\"stdClass\":2:{s:4:\"link\";s:96:\"http://www.eproini.gr/index.php/arthografia/arthrografia-arthra/37930-kata-fantasian-fantasiakos\";s:6:\"expiry\";i:1403132382;}s:40:\"14c8a52d55be79b4c277aaf95f2f755e043caa33\";O:8:\"stdClass\":2:{s:4:\"link\";s:77:\"http://www.eproini.gr/index.php/ellada/menu-paideia/37967-2014-06-17-15-13-48\";s:6:\"expiry\";i:1403132387;}s:40:\"58c2b2d13993abd8262e38ffab06c113fdfef909\";O:8:\"stdClass\":2:{s:4:\"link\";s:115:\"http://www.eproini.gr/index.php/ileia/ileia-amaliada/37958-anthropini-allileggyi-amaliada-fagito-gia-80-oikogeneies\";s:6:\"expiry\";i:1403132393;}s:40:\"a7e7947461ce472cb6f1751511d21acdd2851a48\";O:8:\"stdClass\":2:{s:4:\"link\";s:88:\"http://www.eproini.gr/index.php/lifestyle/37963-ekapsan-zontano-ton-diasimo-greek-kamaki\";s:6:\"expiry\";i:1403132399;}s:40:\"e37dae35b35bd947c2efa3631ad4654c66650160\";O:8:\"stdClass\":2:{s:4:\"link\";s:86:\"http://www.eproini.gr/index.php/lifestyle/37968-synelifthi-o-remos-gia-xrei-tou-irakli\";s:6:\"expiry\";i:1403132403;}s:40:\"fb855df5eac3ca626071ce459d3f7924f48f426e\";O:8:\"stdClass\":2:{s:4:\"link\";s:101:\"http://www.eproini.gr/index.php/menu-ellada-koinonia/37969-foto-aftos-einai-o-satanistis-tis-glyfadas\";s:6:\"expiry\";i:1403132408;}s:40:\"90e08d558d4487068deaadf34090d6b583f81c8d\";O:8:\"stdClass\":2:{s:4:\"link\";s:121:\"http://www.eproini.gr/index.php/menu-ileia-purgos/37931-d-s-pyrgou-diaparataksiaki-synergasia-gia-to-thema-ton-skoupidion\";s:6:\"expiry\";i:1403132413;}s:40:\"0e83c59a2b13127e639b2fcebf5373766e4ecc31\";O:8:\"stdClass\":2:{s:4:\"link\";s:103:\"http://www.eproini.gr/index.php/oikonomia/oikonomia-teleutaia-nea/37964-veto-kai-sto-espa-apo-ti-troika\";s:6:\"expiry\";i:1403132420;}s:40:\"2e9d700b0c7e45ececfb5ebcc2e559bb4030d9b9\";O:8:\"stdClass\":2:{s:4:\"link\";s:128:\"http://www.eproini.gr/index.php/politiki/politiki-ellada/37965-esiea-diagonismos-parodia-gia-proslipseis-dimosiografon-sti-nerit\";s:6:\"expiry\";i:1403132426;}}s:13:\"session.token\";s:32:\"435fd9557e4b410959db0274a2df8873\";}' , `time` = '1403132428'
1 × UPDATE h5490_content SET hits = hits + 1
1 × SHOW FULL COLUMNS FROM `h5490_autotweet_automator
1 × SHOW TABLE

Ηλεια

Ελλαδα

Κοσμος

Πολιτικη

Οικονομια

Αθλητικα

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

Συνεδρία

__default

user

com_mailto.links

15a53a1ba685601a5aea4dcf936cc7de8fbfd9dc

ca67305897664e08e9d4a7f475ce806e4bdfc53e

769f5f7d91beab8ae4699c9ba7dc586d59059f0c

e5ae6428da994c59ac6a73bd5060de497ec89890

14c8a52d55be79b4c277aaf95f2f755e043caa33

58c2b2d13993abd8262e38ffab06c113fdfef909

a7e7947461ce472cb6f1751511d21acdd2851a48

e37dae35b35bd947c2efa3631ad4654c66650160

fb855df5eac3ca626071ce459d3f7924f48f426e

90e08d558d4487068deaadf34090d6b583f81c8d

0e83c59a2b13127e639b2fcebf5373766e4ecc31

2e9d700b0c7e45ececfb5ebcc2e559bb4030d9b9

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

Χρήση Μνήμης

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

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

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

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

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