Digea: Νέα ψηφιακή εποχή αλλά όχι για όλους !

Παρασκευή, 20 Ιουνίου 2014 14:26
Γράφτηκε από τον/την NewsRoom

Δεκάδες χωριά της ημιορεινής Ηλείας ακάλυπτα από το ψηφιακό σήμα της Digea
Στους δήμους το κόστος των «βοηθητικών» κέντρων εκπομπής

Μεγάλες περιοχές του νομού μας, νομού με «δύσκολη» και για τούτο γοητευτική τοπογραφία, θα μείνουν εκτός της «νέας, ψηφιακής εποχής» στην οποία θα περάσουμε όλοι, θέλοντας και μη από τις 27 Ιουνίου και μετά. Το βασικό όφελος για τους τηλεθεατές είναι η καλύτερη ποιότητα σήματος, που σημαίνει καλύτερη ποιότητα ήχου και εικόνας, χωρίς «χιόνια» και παρεμβολές στον ήχο.Ως γνωστόν στις 27 Ιουνίου 2014 περίπου 1 εκατομμύριο κάτοικοι στην Πελοπόννησο θα αποκτήσουν πρόσβαση στο επίγειο ψηφιακό σήμα. Πρόκειται για το πρώτο περιοχικό switch – off (δηλαδή 19 κέντρα εκπομπής θα ενεργοποιηθούν ταυτόχρονα) που θα πραγματοποιηθεί ενόψει της ολοκλήρωσης της ψηφιακής μετάβασης.

Λευκές και γκρίζες ζώνες !
Στο νομό μας, τα κέντρα εκπομπής είναι δυο, το Φραγκαπήδημα και η Σμέρνα!
Τα οποία ωστόσο αφήνουν «ακάλυπτες» πολλές περιοχές της Ηλείας σύμφωνα με τον χάρτη των περιοχών κάλυψης που κυκλοφόρησε η ίδια η Digea ! Θα συνεχίσουν δηλαδή να απολαμβάνουν τα αγαπημένα τους τηλεοπτικά προγράμματα αναλογικά, αν και εφόσον έχουν πρόσβαση στους πομπούς του Αίνου της Κεφαλονιάς που θα συνεχίσει να εκπέμπει αναλογικά ως το τέλος του χρόνου.Στο χάρτη αυτό λοιπόν μπορεί κανείς να δει εκατοντάδες χωριά του νομού μας που είναι ενταγμένα στις λευκές ζώνες, όπου η Digea μας πληροφορεί ότι οι Δήμοι οφείλουν (!) να αναλάβουν το οικονομικό κόστος της μετάβασης στην ψηφιακή εποχή, των βοηθητικών, όπως τα ονομάζει, κέντρων εκπομπής σε μεταγενέστερο χρόνο και πάντως ως τα τέλη του 2015. Η Digea θα βοηθήσει σε αυτή την περίπτωση στο τεχνικό σκέλος !Σε ο.τι αφορά τις «γκρίζες ζώνες» θα πρέπει να βρεθούν «εναλλακτικοί» τρόποι. (μια και σήμερα δεν προβλέπονται), ήτοι το κράτος θα πρέπει να πληρώσει για την ψηφιακή κάλυψη μέσω δορυφορικών πλατφορμών

Κάποιοι ακόμη, δηλαδή οι κάτοικοι που ανήκουν στην περιοχή κάλυψης των κέντρων Αρόη, Ξυλόκαστρο και Πεταλίδι που ήδη είχαν περάσει στην ψηφιακή εποχή θα χρειαστεί να επανασυντονίσουν τους δέκτες τους στις νέες συχνότητες.Όπου πολλές από τις νέες συχνότητες, επικαλύπτουν άλλες στις οποίες εκπέμπουν με αναλογικό σήμα, τόσο τοπικά και περιφερειακά κανάλια, όσο και εθνικής εμβέλειας, όπως αναφέρουν τεχνικοί που γνωρίζουν πρόσωπα και πράγματα. Όσοι κάτοικοι ανήκουν σε περιοχή που επηρεάζεται χρειάζεται να διαθέτουν δέκτη (τηλεόραση ή εξωτερικό αποκωδικοποιητή) τεχνολογίας DVB-T MPEG4 ή H.264 και να τον συντονίσουν στις νέες συχνότητες στις 27 Ιουνίου. Αν σύμφωνα με τους χάρτες ανήκουν σε περιοχή ενδεχόμενης κάλυψης, τότε ενδέχεται να χρειάζεται και η εγκατάσταση ενισχυτή στην εγκατάστασή τους.Δεν απαιτείται καμία αλλαγή στην εγκατάσταση της ήδη υπάρχουσας κεραίας προκειμένου να λάβουμε το ψηφιακό σήμα. Η μετατροπή του σήματος γίνεται εξ ολοκλήρου από τον αποκωδικοποιητή που θα τοποθετήσουμε.Θα χρειαστεί βέβαια ένας διαφορετικός αποκωδικοποιητής για κάθε τηλεόραση που υπάρχει στο σπίτι και δεν διαθέτει ψηφιακό δέκτη που υποστηρίζει το σύστημα ΜΡΕG-4. Ο κάθε αποκωδικοποιητής που συνδέεται στην τηλεόρασή μας ουσιαστικά υποκαθιστά μόνο τον δικό της αναλογικό δέκτη. Επομένως κάθε τηλεόραση που έχουμε στο σπίτι θα χρειαστεί τον δικό της ξεχωριστό αποκωδικοποιητή.

Το κόστος για έναν απλό αποκωδικοποιητή που αναβαθμίζει την τηλεόρασή σας με μια απλή σύνδεση υπολογίζεται κάτω από 40 ευρώ. Όταν σταματήσει εντελώς η εκπομπή αναλογικού τηλεοπτικού σήματος στην Πελοπόννησο, όσοι δεν έχουν φροντίσει να προμηθευτούν τον αποκωδικοποιητή, δεν θα έχουν πλέον εικόνα στην τηλεόρασή τους.

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

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

SELECT `data` FROM `h5490_session` WHERE `session_id` = 'nmpjnk5jmmcbbjck60nqfperc3'
SELECT count(*) FROM `h5490_cwtraffic` WHERE ip = '174.129.228.67' AND tm + '3600'>'1403531942'
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=38101 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 = 38101
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 = 38101 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-06-23 13:59:02') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-06-23 13:59:02') 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=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
UPDATE h5490_content SET hits = hits + 1 WHERE id = 38101
SELECT extension_id AS id, element AS "option", params, enabled FROM h5490_extensions WHERE `type` = 'component' AND `element` = 'com_contact'
SELECT extension_id AS id, element AS "option", params, enabled FROM h5490_extensions WHERE `type` = 'component' AND `element` = 'com_newsfeeds'
SELECT alias, catid FROM h5490_content WHERE id = 38101
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-23 13:59:04' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2014-06-23 13:59:04' ) 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=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=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.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=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.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=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
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=361 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=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.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
SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM h5490_categories as c LEFT JOIN h5490_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM h5490_categories AS cat JOIN h5490_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=368 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id ORDER BY c.lft
UPDATE `h5490_session` SET `data` = '__default|a:10:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1403531869;s:18:\"session.timer.last\";i:1403531869;s:17:\"session.timer.now\";i:1403531942;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:2:{s:40:\"3cca9efa7e7b24852a23e0b473f0b7b57d5e786d\";O:8:\"stdClass\":2:{s:4:\"link\";s:134:\"http://www.eproini.gr/index.php/agrotika/agrotika-tel-nea/38044-agrotikos-synetairismos-amaliadas-ekseftelistiki-i-timi-tou-karpouzioy\";s:6:\"expiry\";i:1403531869;}s:40:\"75edb983afdd3e0939eaa56d1e1c38aaf1a08eb2\";O:8:\"stdClass\":2:{s:4:\"link\";s:107:\"http://www.eproini.gr/index.php/ileia/ileia-teleutaia-nea/38101-digea-nea-psifiaki-epoxi-alla-oxi-gia-olous\";s:6:\"expiry\";i:1403531942;}}s:13:\"session.token\";s:32:\"da46aa5febc968b1dcdc488e92b6a5bd\";}' , `time` = '1403531945' WHERE `session_id` = 'nmpjnk5jmmcbbjck60nqfperc3'

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

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

12 × SELECT c.*, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM h5490_categories as c LEFT JOIN h5490_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM h5490_categories AS cat JOIN h5490_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
2 × SELECT extension_id AS id, element AS "option", params, enabled FROM h5490_extensions
2 × SELECT h5490_autotweet_automator.* FROM h5490_autotweet_automator
2 × SELECT alias, catid FROM h5490_content
1 × SELECT id, rules FROM `h5490_viewlevels
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 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 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 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 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 b.id FROM h5490_usergroups AS a LEFT JOIN h5490_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt

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

1 × UPDATE `h5490_session` SET `data` = '__default|a:10:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1403531869;s:18:\"session.timer.last\";i:1403531869;s:17:\"session.timer.now\";i:1403531942;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:2:{s:40:\"3cca9efa7e7b24852a23e0b473f0b7b57d5e786d\";O:8:\"stdClass\":2:{s:4:\"link\";s:134:\"http://www.eproini.gr/index.php/agrotika/agrotika-tel-nea/38044-agrotikos-synetairismos-amaliadas-ekseftelistiki-i-timi-tou-karpouzioy\";s:6:\"expiry\";i:1403531869;}s:40:\"75edb983afdd3e0939eaa56d1e1c38aaf1a08eb2\";O:8:\"stdClass\":2:{s:4:\"link\";s:107:\"http://www.eproini.gr/index.php/ileia/ileia-teleutaia-nea/38101-digea-nea-psifiaki-epoxi-alla-oxi-gia-olous\";s:6:\"expiry\";i:1403531942;}}s:13:\"session.token\";s:32:\"da46aa5febc968b1dcdc488e92b6a5bd\";}' , `time` = '1403531945'
1 × UPDATE h5490_content SET hits = hits + 1
1 × SHOW FULL COLUMNS FROM `h5490_autotweet_automator
1 × SHOW TABLE

Τραγωδία στην Ανδραβίδα: …

Μικτή Χορωδία Πύργου: Ένα…

Λιατσής : «Θα αποκαταστή…

Ορεινή Ηλεία: Εκεί που η …

Λαογραφικός Χορευτικός Όμ…

Γιόρτασε στο Κατάκολο η Φ…

Στάχτη 30 στρέμματα στην …

Προσφυγιά

Γ. Λιατσής: «Στον Πύργο θ…

Λιατσής για τα σκουπίδια:…

Μουσικές διαδρομές

Εκτός νυμφώνος ξανά

Ας το σκεφθεί καλύτερα

Δήμαρχο βγάζει ο λαός

Αποτελεί εξαίρεση

Στους ΑΝ-ΕΛ

Digea: Νέα ψηφιακή εποχή αλλά όχι για όλους !

Ηλεια

Ελλαδα

Κοσμος

Πολιτικη

Οικονομια

Αθλητικα

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

Συνεδρία

__default

user

com_mailto.links

3cca9efa7e7b24852a23e0b473f0b7b57d5e786d

75edb983afdd3e0939eaa56d1e1c38aaf1a08eb2

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

Χρήση Μνήμης

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

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

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

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

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