{"id":1259,"date":"2011-09-30T17:25:54","date_gmt":"2011-09-30T15:25:54","guid":{"rendered":"http:\/\/ale3andro.gr\/blog\/?p=1259"},"modified":"2011-09-30T17:25:54","modified_gmt":"2011-09-30T15:25:54","slug":"%ce%b4%ce%b5%cf%8d%cf%84%ce%b5%cf%81%ce%b7-%cf%86%ce%ac%cf%83%ce%b7-%ce%b1%cf%80%ce%bf%cf%83%cf%80%ce%ac%cf%83%ce%b5%cf%89%ce%bd-%ce%b2%ce%b8%ce%bc%ce%b9%ce%b1%cf%82-%ce%b5%ce%ba%cf%80%cf%83%ce%b7","status":"publish","type":"post","link":"https:\/\/ale3andro.gr\/blog\/2011\/09\/30\/%ce%b4%ce%b5%cf%8d%cf%84%ce%b5%cf%81%ce%b7-%cf%86%ce%ac%cf%83%ce%b7-%ce%b1%cf%80%ce%bf%cf%83%cf%80%ce%ac%cf%83%ce%b5%cf%89%ce%bd-%ce%b2%ce%b8%ce%bc%ce%b9%ce%b1%cf%82-%ce%b5%ce%ba%cf%80%cf%83%ce%b7\/","title":{"rendered":"\u0394\u03b5\u03cd\u03c4\u03b5\u03c1\u03b7 \u03c6\u03ac\u03c3\u03b7 \u03b1\u03c0\u03bf\u03c3\u03c0\u03ac\u03c3\u03b5\u03c9\u03bd \u0392\/\u03b8\u03bc\u03b9\u03b1\u03c2 \u0395\u03ba\u03c0\/\u03c3\u03b7\u03c2 \u03ba\u03b1\u03b9 \u03ad\u03bd\u03b1 \u03b4\u03c9\u03c1\u03ac\u03ba\u03b9!"},"content":{"rendered":"

\u039c\u03b1\u03b6\u03af \u03bc\u03b5 \u03c4\u03b7\u03bd \u03b1\u03bd\u03b1\u03ba\u03bf\u03af\u03bd\u03c9\u03c3\u03b7 \u03c4\u03b7\u03c2 \u03b4\u03b5\u03cd\u03c4\u03b5\u03c1\u03b7\u03c2 \u03c6\u03ac\u03c3\u03b7\u03c2 \u03b1\u03c0\u03bf\u03c3\u03c0\u03ac\u03c3\u03b5\u03c9\u03bd \u03b5\u03ba\u03c0\u03b1\u03b9\u03b4\u03b5\u03c5\u03c4\u03b9\u03ba\u03ce\u03bd \u03c4\u03b7\u03c2 \u0394\u03b5\u03c5\u03c4\u03b5\u03c1\u03bf\u03b2\u03ac\u03b8\u03bc\u03b9\u03b1\u03c2 \u0395\u03ba\u03c0\u03b1\u03af\u03b4\u03b5\u03c5\u03c3\u03b7\u03c2, \u03c4\u03bf \u03a5\u03a0\u0394\u0392\u039c\u0398 \u03bc\u03b1\u03c2 \u03ad\u03b4\u03c9\u03c3\u03b5 \u03ba\u03b1\u03b9 \u03bc\u03b9\u03b1 \u03bc\u03b9\u03ba\u03c1\u03ae \u03b9\u03b4\u03ad\u03b1 \u03c4\u03bf\u03c5 \u03c3\u03c7\u03ae\u03bc\u03b1\u03c4\u03bf\u03c2 \u03c4\u03b7\u03c2 \u0392\u0394 \u03c4\u03bf\u03c5 \u03c0\u03bb\u03b7\u03c1\u03bf\u03c6\u03bf\u03c1\u03b9\u03b1\u03ba\u03bf\u03cd \u03c4\u03bf\u03c5 \u03c3\u03c5\u03c3\u03c4\u03ae\u03bc\u03b1\u03c4\u03bf\u03c2. \u039a\u03b1\u03c4\u03ac \u03bb\u03ac\u03b8\u03bf\u03c2; \u039c\u03ac\u03bb\u03bb\u03bf\u03bd…<\/p>\n

SELECT CASE WHEN en.vathait=1 THEN ‘\u0391\/\u03b8\u03bc\u03b9\u03b1’ ELSE ‘\u0392\/\u03b8\u03bc\u03b9\u03b1’ END AS “\u0392\u03b1\u03b8\u03bc\u03af\u03b4\u03b1 \u0391\u03af\u03c4\u03b7\u03c3\u03b7\u03c2”, en.omada AS “\u0395\u03b9\u03b4\u03b9\u03ba\u03cc\u03c4\u03b7\u03c4\u03b1”, EN.mitroo AS “\u0391\u039c”, EN.AFM AS “\u0391\u03a6\u039c”, en.aitisi_id, en.eponimo AS “\u0395\u03c0\u03ce\u03bd\u03c5\u03bc\u03bf”, en.onoma AS “\u038c\u03bd\u03bf\u03bc\u03b1”, CASE WHEN en.eidkat_rank=5 THEN ‘\u03a3\u03cd\u03b6\u03c5\u03b3\u03bf\u03c2 \u03a3\u03c4\u03c1\u03b1\u03c4\u03b9\u03c9\u03c4\u03b9\u03ba\u03bf\u03cd’ WHEN en.eidkat_rank=6 THEN ‘\u0391\u03b9\u03c1\u03b5\u03c4\u03cc\u03c2 \u039f.\u03a4.\u0391.’ WHEN en.eidkat_rank=7 THEN ‘\u03a3\u03cd\u03b6\u03c5\u03b3\u03bf\u03c2 \u03b4\u03b9\u03ba\u03b1\u03c3\u03c4\u03b9\u03ba\u03bf\u03cd’ WHEN en.eidkat_rank=100 THEN ‘\u039c\u03b7 \u03b5\u03b9\u03b4\u03b9\u03ba\u03ae \u03ba\u03b1\u03c4\u03b7\u03b3\u03bf\u03c1\u03af\u03b1’ ELSE en.eidiki_kathgoria END AS “\u0395\u03b9\u03b4\u03b9\u03ba\u03ae \u03ba\u03b1\u03c4\u03b7\u03b3\u03bf\u03c1\u03af\u03b1”, en.eidkat_rank, topoth.moria AS “\u039c\u03cc\u03c1\u03b9\u03b1 \u03a0\u03a5\u03a3\u0394\u0395\/\u03a0\u03a5\u03a3\u03a0\u0395 \u03a4\u03bf\u03c0\u03bf\u03b8\u03ad\u03c4\u03b7\u03c3\u03b7\u03c2”, topoth.pysde AS “\u03a0\u03a5\u03a3\u0394\u0395\/\u03a0\u03a5\u03a3\u03a0\u0395 \u03a4\u03bf\u03c0\u03bf\u03b8\u03ad\u03c4\u03b7\u03c3\u03b7\u03c2”, en.seira AS “\u03a3\u03b5\u03b9\u03c1\u03ac \u03a0\u03c1\u03bf\u03c4\u03af\u03bc\u03b7\u03c3\u03b7\u03c2 \u03a4\u03bf\u03c0\u03bf\u03b8\u03ad\u03c4\u03b7\u03c3\u03b7\u03c2”, topoth.proto AS vathtop, en.pyspde_org AS “\u03a0\u03a5\u03a3\u0394\u0395\/\u03a0\u03a5\u03a3\u03a0\u0395 \u039f\u03c1\u03b3\u03b1\u03bd\u03b9\u03ba\u03ae\u03c2”, en.kaiseathmia FROM (SELECT lu.proto AS vathait, a.id_klados AS omada, ait.id_klados AS id_klados, a.mitroo, a.eponimo, a.onoma, a.pateras, a.aitisi_id, a.protokolo, b.lektiko_perioxi AS pysde_prot, a.eidiki_kathgoria, a.eidiki_kathgoria_flag, CASE WHEN eidiki_kathgoria = ‘\u03a0\u03bf\u03bb\u03cd\u03c4\u03b5\u03ba\u03bd\u03bf\u03c2’ THEN 1 WHEN eidiki_kathgoria=’\u039f\u03bc\u03cc\u03b6\u03c5\u03b3\u03bf\u03c2 \u03bc\u03b5\u03c3\u03bf\u03b3\u03b5\u03b9\u03b1\u03ba\u03ae \u03ae \u03b4\u03c1\u03b5\u03c0\u03b1\u03bd\u03bf\u03ba\u03c5\u03c4\u03c4\u03b1\u03c1\u03b9\u03ba\u03ae \u03ba\u03b1\u03b9 \u03bc\u03b9\u03ba\u03c1\u03bf\u03b4\u03c1\u03b5\u03c0\u03b1\u03bd\u03bf\u03ba\u03c5\u03c4\u03c4\u03b1\u03c1\u03b9\u03ba\u03ae \u03b1\u03bd\u03b1\u03b9\u03bc\u03af\u03b1’ THEN 2 WHEN eidiki_kathgoria=’\u03a3\u03ba\u03bb\u03ae\u03c1\u03c5\u03bd\u03c3\u03b7 \u03ba\u03b1\u03c4\u03ac \u03a0\u03bb\u03ac\u03ba\u03b1\u03c2’ THEN 3 WHEN eidiki_kathgoria=’\u039b\u03bf\u03b9\u03c0\u03ad\u03c2 \u03b5\u03b9\u03b4\u03b9\u03ba\u03ad\u03c2 \u03ba\u03b1\u03c4\u03b7\u03b3\u03bf\u03c1\u03af\u03b5\u03c2’ THEN 4 WHEN (suzugos_stratiwtikou=1 AND prwth_prot =sinipiretisi_pyspde) THEN 5 WHEN airetos_ota=1 THEN 6 WHEN (suzugos_dikastikou=1 AND prwth_prot =sinipiretisi_pyspde) THEN 7 ELSE 100 END AS eidkat_rank, a.suzugos_stratiwtikou, a.afm, a.airetos_ota, a.suzugos_dikastikou, b.moria_perioxi, b.seira, lpys.lektiko AS pyspde_org, lbatt.avakue AS kaiseathmia FROM folder_apospasi_2011_b.apospasi_eniaios a, folder_apospasi_2011_b.apospasi_moria_perioxi b, folder_apospasi_2011_b.apospasi_aitisi ait, folder_run.lu_pyspde_perioxes lpyper, folder_run.lu_pyspde lpys, folder_run.lu_user lu, (SELECT aitisi_id, lektiko_perioxi AS prwth_prot FROM folder_apospasi_2011_b.apospasi_moria_perioxi WHERE seira=1 ) pera, folder_apospasi_2011_b.apospasi_aitisi_b_attributes lbatt WHERE a.aitisi_id =b.aitisi_id AND a.aitisi_id =ait.id_aitisi AND a.aitisi_id =lbatt.id_aitisi AND a.aitisi_id = pera.aitisi_id AND lbatt.id_attribute=59 AND ait.id_perioxi = lpyper.id_perioxi AND lpys.id_pyspde =lpyper.id_pyspde AND ait.id_user =lu.id_user ) en, FOLDER_APOSPASI_2011_B.apospasi_topothetisi topoth WHERE en.aitisi_id =topoth.id_aitisi AND topoth.id_aitisi NOT IN (SELECT id_aitisi FROM FOLDER_APOSPASI_2011_B.topot_after_apospathmias_fasi2 ) AND en.pysde_prot =topoth.pysde \/**\/ AND vathait =0 AND omada not IN (‘\u03a0\u039570′,’\u03a0\u039560’) ORDER BY omada, vathait DESC, vathtop, eidkat_rank, moria_perioxi DESC<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

\u039c\u03b1\u03b6\u03af \u03bc\u03b5 \u03c4\u03b7\u03bd \u03b1\u03bd\u03b1\u03ba\u03bf\u03af\u03bd\u03c9\u03c3\u03b7 \u03c4\u03b7\u03c2 \u03b4\u03b5\u03cd\u03c4\u03b5\u03c1\u03b7\u03c2 \u03c6\u03ac\u03c3\u03b7\u03c2 \u03b1\u03c0\u03bf\u03c3\u03c0\u03ac\u03c3\u03b5\u03c9\u03bd \u03b5\u03ba\u03c0\u03b1\u03b9\u03b4\u03b5\u03c5\u03c4\u03b9\u03ba\u03ce\u03bd \u03c4\u03b7\u03c2 \u0394\u03b5\u03c5\u03c4\u03b5\u03c1\u03bf\u03b2\u03ac\u03b8\u03bc\u03b9\u03b1\u03c2 \u0395\u03ba\u03c0\u03b1\u03af\u03b4\u03b5\u03c5\u03c3\u03b7\u03c2, \u03c4\u03bf \u03a5\u03a0\u0394\u0392\u039c\u0398 \u03bc\u03b1\u03c2 \u03ad\u03b4\u03c9\u03c3\u03b5 \u03ba\u03b1\u03b9 \u03bc\u03b9\u03b1 \u03bc\u03b9\u03ba\u03c1\u03ae \u03b9\u03b4\u03ad\u03b1 \u03c4\u03bf\u03c5 \u03c3\u03c7\u03ae\u03bc\u03b1\u03c4\u03bf\u03c2 \u03c4\u03b7\u03c2 \u0392\u0394 \u03c4\u03bf\u03c5 \u03c0\u03bb\u03b7\u03c1\u03bf\u03c6\u03bf\u03c1\u03b9\u03b1\u03ba\u03bf\u03cd \u03c4\u03bf\u03c5 \u03c3\u03c5\u03c3\u03c4\u03ae\u03bc\u03b1\u03c4\u03bf\u03c2. \u039a\u03b1\u03c4\u03ac \u03bb\u03ac\u03b8\u03bf\u03c2; \u039c\u03ac\u03bb\u03bb\u03bf\u03bd… SELECT CASE WHEN en.vathait=1 THEN ‘\u0391\/\u03b8\u03bc\u03b9\u03b1’ ELSE ‘\u0392\/\u03b8\u03bc\u03b9\u03b1’ END AS “\u0392\u03b1\u03b8\u03bc\u03af\u03b4\u03b1 \u0391\u03af\u03c4\u03b7\u03c3\u03b7\u03c2”, en.omada AS “\u0395\u03b9\u03b4\u03b9\u03ba\u03cc\u03c4\u03b7\u03c4\u03b1”, EN.mitroo AS “\u0391\u039c”, EN.AFM AS “\u0391\u03a6\u039c”, en.aitisi_id, en.eponimo AS […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,8,23],"tags":[],"class_list":["post-1259","post","type-post","status-publish","format-standard","hentry","category-blogging","category-developing","category-23"],"_links":{"self":[{"href":"https:\/\/ale3andro.gr\/blog\/wp-json\/wp\/v2\/posts\/1259","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ale3andro.gr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ale3andro.gr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ale3andro.gr\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ale3andro.gr\/blog\/wp-json\/wp\/v2\/comments?post=1259"}],"version-history":[{"count":0,"href":"https:\/\/ale3andro.gr\/blog\/wp-json\/wp\/v2\/posts\/1259\/revisions"}],"wp:attachment":[{"href":"https:\/\/ale3andro.gr\/blog\/wp-json\/wp\/v2\/media?parent=1259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ale3andro.gr\/blog\/wp-json\/wp\/v2\/categories?post=1259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ale3andro.gr\/blog\/wp-json\/wp\/v2\/tags?post=1259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}