Λυπούμαστε για την ταλαιπωρία.
Ψάξτε ξανά αυτό που θέλετε να βρείτε
Array ( [id_posvegamenu_item] => 1 [type_link] => 0 [link] => https://goldenbooks.gr/ [type_icon] => 0 [icon] => [icon_class] => [submenu_type] => 2 [item_class] => [new_window] => 0 [position] => 0 [active] => 1 [item_bg_color] => [item_bg_colorh] => [item_color] => [item_colorh] => [item_fontsize] => 0 [item_lineheight] => 0 [item_transform] => 0 [subtitle_bg_color] => [subtitle_color] => [subtitle_fontsize] => 0 [subtitle_lineheight] => 0 [subtitle_transform] => 0 [id_lang] => 1 [title] => ΑΡΧΙΚΗ [custom_link] => [subtitle] => [selected_item] => [sub_menu] => Array ( ) ) 1ΑΡΧΙΚΗ
Array ( [id_posvegamenu_item] => 3 [type_link] => 0 [link] => https://goldenbooks.gr/148-vivlia [type_icon] => 0 [icon] => [icon_class] => [submenu_type] => 1 [item_class] => ProductCat [new_window] => 0 [position] => 1 [active] => 1 [item_bg_color] => [item_bg_colorh] => [item_color] => [item_colorh] => [item_fontsize] => 0 [item_lineheight] => 0 [item_transform] => 0 [subtitle_bg_color] => [subtitle_color] => [subtitle_fontsize] => 0 [subtitle_lineheight] => 0 [subtitle_transform] => 0 [id_lang] => 1 [title] => ΒΙΒΛΙΑ [custom_link] => # [subtitle] => [selected_item] => [catID] => 148 [img] => [sub_menu] =>
Array ( [0] => Array ( [id_category] => 172 [name] => Βιβλία Παιδικής & Εφηβικής Λογοτεχνίας [link_rewrite] => -vivliapaidikiskaiefhvikhslogotexnias [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 172 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 174 [name] => ΒΙΒΛΙΑ ΟΙΚΟΝΟΜΙΚΩΝ [link_rewrite] => -vivliaoikonomikon [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 174 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )) 1 ΒΙΒΛΙΑ
Array ( [id_posvegamenu_item] => 4 [type_link] => 0 [link] => https://goldenbooks.gr/152-paidika-vivlia [type_icon] => 0 [icon] => [icon_class] => [submenu_type] => 1 [item_class] => ProductCat [new_window] => 0 [position] => 2 [active] => 1 [item_bg_color] => [item_bg_colorh] => [item_color] => [item_colorh] => [item_fontsize] => 0 [item_lineheight] => 0 [item_transform] => 0 [subtitle_bg_color] => [subtitle_color] => [subtitle_fontsize] => 0 [subtitle_lineheight] => 0 [subtitle_transform] => 0 [id_lang] => 1 [title] => ΠΑΙΔΙΚΑ ΒΙΒΛΙΑ [custom_link] => # [subtitle] => [selected_item] => [catID] => 152 [img] => [sub_menu] =>
Array ( [0] => Array ( [id_category] => 158 [name] => ΨΥΧΟΓΙΟΣ KIDS [link_rewrite] => psichogios-kids [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 158 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )) 1 ΠΑΙΔΙΚΑ ΒΙΒΛΙΑ
Array ( [id_posvegamenu_item] => 5 [type_link] => 0 [link] => https://goldenbooks.gr/162-set-vivlion [type_icon] => 0 [icon] => [icon_class] => [submenu_type] => 2 [item_class] => [new_window] => 0 [position] => 3 [active] => 1 [item_bg_color] => [item_bg_colorh] => [item_color] => [item_colorh] => [item_fontsize] => 0 [item_lineheight] => 0 [item_transform] => 0 [subtitle_bg_color] => [subtitle_color] => [subtitle_fontsize] => 0 [subtitle_lineheight] => 0 [subtitle_transform] => 0 [id_lang] => 1 [title] => ΣΕΤ ΒΙΒΛΙΩΝ [custom_link] => # [subtitle] => [selected_item] => [sub_menu] => Array ( ) ) 1ΣΕΤ ΒΙΒΛΙΩΝ
Array ( [id_posvegamenu_item] => 6 [type_link] => 0 [link] => https://goldenbooks.gr/443-janod [type_icon] => 0 [icon] => [icon_class] => [submenu_type] => 2 [item_class] => [new_window] => 0 [position] => 4 [active] => 1 [item_bg_color] => [item_bg_colorh] => [item_color] => [item_colorh] => [item_fontsize] => 0 [item_lineheight] => 0 [item_transform] => 0 [subtitle_bg_color] => [subtitle_color] => [subtitle_fontsize] => 0 [subtitle_lineheight] => 0 [subtitle_transform] => 0 [id_lang] => 1 [title] => ΠΑΙΧΝΙΔΙΑ [custom_link] => # [subtitle] => [selected_item] => [sub_menu] => Array ( ) ) 1ΠΑΙΧΝΙΔΙΑ
Array ( [id_posvegamenu_item] => 7 [type_link] => 0 [link] => https://goldenbooks.gr/295-metaixmio [type_icon] => 0 [icon] => [icon_class] => [submenu_type] => 1 [item_class] => ProductCat [new_window] => 0 [position] => 5 [active] => 1 [item_bg_color] => [item_bg_colorh] => [item_color] => [item_colorh] => [item_fontsize] => 0 [item_lineheight] => 0 [item_transform] => 0 [subtitle_bg_color] => [subtitle_color] => [subtitle_fontsize] => 0 [subtitle_lineheight] => 0 [subtitle_transform] => 0 [id_lang] => 1 [title] => METAΙΧΜΙΟ [custom_link] => # [subtitle] => [selected_item] => [catID] => 295 [img] => [sub_menu] =>
Array ( [0] => Array ( [id_category] => 376 [name] => Τέχνες και πολιτισμός [link_rewrite] => technes-ke-politismos [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 376 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 387 [name] => Μελέτες [link_rewrite] => meletes [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 387 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 364 [name] => Εκπαιδευτική βιβλιοθήκη [link_rewrite] => ekpedeftiki-vivliothiki [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 364 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 413 [name] => Ιστορία [link_rewrite] => istoria [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 413 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 403 [name] => Βιογραφίες [link_rewrite] => viografies [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 403 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 337 [name] => Υγεία / Διατροφή [link_rewrite] => igia-diatrofi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 337 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 339 [name] => Μαρτυρία [link_rewrite] => martiria [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 339 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 340 [name] => Επιστήμες της αγωγής [link_rewrite] => epistimes-tis-agogis [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 340 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 352 [name] => Σύγχρονος προβληματισμός [link_rewrite] => sigchronos-provlimatismos [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 352 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 353 [name] => Επιστήμη - Τεχνολογία - Κοινωνία [link_rewrite] => epistimi-technologia-kinonia [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 353 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 370 [name] => Ευ ζην [link_rewrite] => ef-zin [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 370 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 358 [name] => Ψυχολογία - Συμβουλευτική - Πρακτικοί οδηγοί [link_rewrite] => psichologia-simvouleftiki-praktiki-odigi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 358 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 398 [name] => Ιστορία [link_rewrite] => istoria [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 398 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 371 [name] => Επιστήμες της αγωγής [link_rewrite] => epistimes-tis-agogis [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 371 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 372 [name] => Εκπαιδευτική βιβλιοθήκη [link_rewrite] => ekpedeftiki-vivliothiki [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 372 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 385 [name] => Εκπαίδευση ενηλίκων [link_rewrite] => ekpedefsi-enilikon [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 385 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 395 [name] => Κοινωνικό [link_rewrite] => kinoniko [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 395 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 345 [name] => Εκλαϊκευμένη επιστήμη [link_rewrite] => eklaikevmeni-epistimi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 345 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 396 [name] => Κοινωνιολογία - Ανθρωπολογία [link_rewrite] => kinoniologia-nthropologia [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 396 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 309 [name] => Θρίλερ [link_rewrite] => thriler [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 309 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )) 1 METAΙΧΜΙΟ
Array ( [id_posvegamenu_item] => 8 [type_link] => 0 [link] => https://goldenbooks.gr/414-psixogios [type_icon] => 0 [icon] => [icon_class] => [submenu_type] => 1 [item_class] => ProductCat [new_window] => 0 [position] => 6 [active] => 1 [item_bg_color] => [item_bg_colorh] => [item_color] => [item_colorh] => [item_fontsize] => 0 [item_lineheight] => 0 [item_transform] => 0 [subtitle_bg_color] => [subtitle_color] => [subtitle_fontsize] => 0 [subtitle_lineheight] => 0 [subtitle_transform] => 0 [id_lang] => 1 [title] => ΨΥΧΟΓΙΟΣ [custom_link] => # [subtitle] => [selected_item] => [catID] => 414 [img] => [sub_menu] =>
Array ( [0] => Array ( [id_category] => 439 [name] => Σκληρόδετα βιβλία παιδικής λογοτεχνίας [link_rewrite] => sklirodeta-vivlia-pedikis-logotechnias [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 439 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [id_posvegamenu_item] => 9 [type_link] => 0 [link] => https://goldenbooks.gr/456-patakis [type_icon] => 0 [icon] => [icon_class] => [submenu_type] => 1 [item_class] => ProductCat [new_window] => 0 [position] => 7 [active] => 1 [item_bg_color] => [item_bg_colorh] => [item_color] => [item_colorh] => [item_fontsize] => 0 [item_lineheight] => 0 [item_transform] => 0 [subtitle_bg_color] => [subtitle_color] => [subtitle_fontsize] => 0 [subtitle_lineheight] => 0 [subtitle_transform] => 0 [id_lang] => 1 [title] => ΠΑΤΑΚΗΣ [custom_link] => # [subtitle] => [selected_item] => [catID] => 456 [img] => [sub_menu] =>
Array ( [0] => Array ( [id_category] => 469 [name] => Σημειωματάρια – Ημερολόγια [link_rewrite] => simiomataria-imerologia [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 469 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 503 [name] => Νέες κυκλοφορίες [link_rewrite] => nees-kiklofories [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 503 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 514 [name] => Ελληνική εκπαίδευση [link_rewrite] => elliniki-ekpedefsi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 514 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 516 [name] => Λατινική Γραμματεία και Φιλολογία [link_rewrite] => latiniki-grammatia-ke-filologia [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 516 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 517 [name] => Δημόσια Διοίκηση [link_rewrite] => dimosia-diikisi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 517 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 532 [name] => Ταξίδι [link_rewrite] => taxidi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 532 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 540 [name] => Λοιπά εκτός σειράς [link_rewrite] => lipa-ektos-siras [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 540 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 541 [name] => Σημειωματάρια [link_rewrite] => simiomataria [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 541 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 543 [name] => Κουπόνια-eBooks [link_rewrite] => kouponia-ebooks [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 543 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 547 [name] => Να ένα μήλο [link_rewrite] => na-ena-milo [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 547 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 548 [name] => Σύγκριση [link_rewrite] => sigkrisi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 548 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 549 [name] => Άτλαντες [link_rewrite] => tlantes [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 549 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 550 [name] => Audio CD-DVD [link_rewrite] => audio-cd-dvd [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 550 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 552 [name] => Πληροφορική [link_rewrite] => pliroforiki [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 552 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )) 1 ΠΑΤΑΚΗΣ
Array ( [0] => Array ( [id_category] => 172 [name] => Βιβλία Παιδικής & Εφηβικής Λογοτεχνίας [link_rewrite] => -vivliapaidikiskaiefhvikhslogotexnias [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 172 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 174 [name] => ΒΙΒΛΙΑ ΟΙΚΟΝΟΜΙΚΩΝ [link_rewrite] => -vivliaoikonomikon [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 174 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 158 [name] => ΨΥΧΟΓΙΟΣ KIDS [link_rewrite] => psichogios-kids [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 158 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 376 [name] => Τέχνες και πολιτισμός [link_rewrite] => technes-ke-politismos [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 376 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 387 [name] => Μελέτες [link_rewrite] => meletes [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 387 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 364 [name] => Εκπαιδευτική βιβλιοθήκη [link_rewrite] => ekpedeftiki-vivliothiki [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 364 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 413 [name] => Ιστορία [link_rewrite] => istoria [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 413 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 403 [name] => Βιογραφίες [link_rewrite] => viografies [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 403 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 337 [name] => Υγεία / Διατροφή [link_rewrite] => igia-diatrofi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 337 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 339 [name] => Μαρτυρία [link_rewrite] => martiria [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 339 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 340 [name] => Επιστήμες της αγωγής [link_rewrite] => epistimes-tis-agogis [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 340 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 352 [name] => Σύγχρονος προβληματισμός [link_rewrite] => sigchronos-provlimatismos [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 352 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 353 [name] => Επιστήμη - Τεχνολογία - Κοινωνία [link_rewrite] => epistimi-technologia-kinonia [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 353 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 370 [name] => Ευ ζην [link_rewrite] => ef-zin [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 370 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 358 [name] => Ψυχολογία - Συμβουλευτική - Πρακτικοί οδηγοί [link_rewrite] => psichologia-simvouleftiki-praktiki-odigi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 358 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 398 [name] => Ιστορία [link_rewrite] => istoria [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 398 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 371 [name] => Επιστήμες της αγωγής [link_rewrite] => epistimes-tis-agogis [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 371 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 372 [name] => Εκπαιδευτική βιβλιοθήκη [link_rewrite] => ekpedeftiki-vivliothiki [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 372 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 385 [name] => Εκπαίδευση ενηλίκων [link_rewrite] => ekpedefsi-enilikon [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 385 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 395 [name] => Κοινωνικό [link_rewrite] => kinoniko [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 395 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 345 [name] => Εκλαϊκευμένη επιστήμη [link_rewrite] => eklaikevmeni-epistimi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 345 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 396 [name] => Κοινωνιολογία - Ανθρωπολογία [link_rewrite] => kinoniologia-nthropologia [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 396 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 309 [name] => Θρίλερ [link_rewrite] => thriler [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 309 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 439 [name] => Σκληρόδετα βιβλία παιδικής λογοτεχνίας [link_rewrite] => sklirodeta-vivlia-pedikis-logotechnias [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 439 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 469 [name] => Σημειωματάρια – Ημερολόγια [link_rewrite] => simiomataria-imerologia [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 469 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 503 [name] => Νέες κυκλοφορίες [link_rewrite] => nees-kiklofories [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 503 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 514 [name] => Ελληνική εκπαίδευση [link_rewrite] => elliniki-ekpedefsi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 514 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 516 [name] => Λατινική Γραμματεία και Φιλολογία [link_rewrite] => latiniki-grammatia-ke-filologia [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 516 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 517 [name] => Δημόσια Διοίκηση [link_rewrite] => dimosia-diikisi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 517 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 532 [name] => Ταξίδι [link_rewrite] => taxidi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 532 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 540 [name] => Λοιπά εκτός σειράς [link_rewrite] => lipa-ektos-siras [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 540 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 541 [name] => Σημειωματάρια [link_rewrite] => simiomataria [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 541 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 543 [name] => Κουπόνια-eBooks [link_rewrite] => kouponia-ebooks [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 543 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 547 [name] => Να ένα μήλο [link_rewrite] => na-ena-milo [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 547 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 548 [name] => Σύγκριση [link_rewrite] => sigkrisi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 548 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 549 [name] => Άτλαντες [link_rewrite] => tlantes [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 549 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 550 [name] => Audio CD-DVD [link_rewrite] => audio-cd-dvd [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 550 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 552 [name] => Πληροφορική [link_rewrite] => pliroforiki [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 552 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 172 [name] => Βιβλία Παιδικής & Εφηβικής Λογοτεχνίας [link_rewrite] => -vivliapaidikiskaiefhvikhslogotexnias [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 172 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 174 [name] => ΒΙΒΛΙΑ ΟΙΚΟΝΟΜΙΚΩΝ [link_rewrite] => -vivliaoikonomikon [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 174 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 158 [name] => ΨΥΧΟΓΙΟΣ KIDS [link_rewrite] => psichogios-kids [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 158 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 376 [name] => Τέχνες και πολιτισμός [link_rewrite] => technes-ke-politismos [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 376 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 387 [name] => Μελέτες [link_rewrite] => meletes [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 387 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 364 [name] => Εκπαιδευτική βιβλιοθήκη [link_rewrite] => ekpedeftiki-vivliothiki [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 364 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 413 [name] => Ιστορία [link_rewrite] => istoria [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 413 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 403 [name] => Βιογραφίες [link_rewrite] => viografies [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 403 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 337 [name] => Υγεία / Διατροφή [link_rewrite] => igia-diatrofi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 337 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 339 [name] => Μαρτυρία [link_rewrite] => martiria [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 339 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 340 [name] => Επιστήμες της αγωγής [link_rewrite] => epistimes-tis-agogis [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 340 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 352 [name] => Σύγχρονος προβληματισμός [link_rewrite] => sigchronos-provlimatismos [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 352 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 353 [name] => Επιστήμη - Τεχνολογία - Κοινωνία [link_rewrite] => epistimi-technologia-kinonia [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 353 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 370 [name] => Ευ ζην [link_rewrite] => ef-zin [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 370 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 358 [name] => Ψυχολογία - Συμβουλευτική - Πρακτικοί οδηγοί [link_rewrite] => psichologia-simvouleftiki-praktiki-odigi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 358 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 398 [name] => Ιστορία [link_rewrite] => istoria [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 398 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 371 [name] => Επιστήμες της αγωγής [link_rewrite] => epistimes-tis-agogis [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 371 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 372 [name] => Εκπαιδευτική βιβλιοθήκη [link_rewrite] => ekpedeftiki-vivliothiki [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 372 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 385 [name] => Εκπαίδευση ενηλίκων [link_rewrite] => ekpedefsi-enilikon [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 385 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 395 [name] => Κοινωνικό [link_rewrite] => kinoniko [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 395 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 345 [name] => Εκλαϊκευμένη επιστήμη [link_rewrite] => eklaikevmeni-epistimi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 345 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 396 [name] => Κοινωνιολογία - Ανθρωπολογία [link_rewrite] => kinoniologia-nthropologia [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 396 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 309 [name] => Θρίλερ [link_rewrite] => thriler [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 309 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 439 [name] => Σκληρόδετα βιβλία παιδικής λογοτεχνίας [link_rewrite] => sklirodeta-vivlia-pedikis-logotechnias [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 439 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 469 [name] => Σημειωματάρια – Ημερολόγια [link_rewrite] => simiomataria-imerologia [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 469 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 503 [name] => Νέες κυκλοφορίες [link_rewrite] => nees-kiklofories [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 503 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 514 [name] => Ελληνική εκπαίδευση [link_rewrite] => elliniki-ekpedefsi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 514 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 516 [name] => Λατινική Γραμματεία και Φιλολογία [link_rewrite] => latiniki-grammatia-ke-filologia [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 516 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 517 [name] => Δημόσια Διοίκηση [link_rewrite] => dimosia-diikisi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 517 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 532 [name] => Ταξίδι [link_rewrite] => taxidi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 532 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 540 [name] => Λοιπά εκτός σειράς [link_rewrite] => lipa-ektos-siras [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 540 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 541 [name] => Σημειωματάρια [link_rewrite] => simiomataria [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 541 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 543 [name] => Κουπόνια-eBooks [link_rewrite] => kouponia-ebooks [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 543 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 547 [name] => Να ένα μήλο [link_rewrite] => na-ena-milo [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 547 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 548 [name] => Σύγκριση [link_rewrite] => sigkrisi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 548 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 549 [name] => Άτλαντες [link_rewrite] => tlantes [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 549 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 550 [name] => Audio CD-DVD [link_rewrite] => audio-cd-dvd [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 550 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 552 [name] => Πληροφορική [link_rewrite] => pliroforiki [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 552 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 172 [name] => Βιβλία Παιδικής & Εφηβικής Λογοτεχνίας [link_rewrite] => -vivliapaidikiskaiefhvikhslogotexnias [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 172 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 174 [name] => ΒΙΒΛΙΑ ΟΙΚΟΝΟΜΙΚΩΝ [link_rewrite] => -vivliaoikonomikon [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 174 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 158 [name] => ΨΥΧΟΓΙΟΣ KIDS [link_rewrite] => psichogios-kids [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 158 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 376 [name] => Τέχνες και πολιτισμός [link_rewrite] => technes-ke-politismos [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 376 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 387 [name] => Μελέτες [link_rewrite] => meletes [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 387 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 364 [name] => Εκπαιδευτική βιβλιοθήκη [link_rewrite] => ekpedeftiki-vivliothiki [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 364 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 413 [name] => Ιστορία [link_rewrite] => istoria [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 413 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 403 [name] => Βιογραφίες [link_rewrite] => viografies [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 403 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 337 [name] => Υγεία / Διατροφή [link_rewrite] => igia-diatrofi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 337 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 339 [name] => Μαρτυρία [link_rewrite] => martiria [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 339 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 340 [name] => Επιστήμες της αγωγής [link_rewrite] => epistimes-tis-agogis [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 340 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 352 [name] => Σύγχρονος προβληματισμός [link_rewrite] => sigchronos-provlimatismos [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 352 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 353 [name] => Επιστήμη - Τεχνολογία - Κοινωνία [link_rewrite] => epistimi-technologia-kinonia [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 353 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 370 [name] => Ευ ζην [link_rewrite] => ef-zin [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 370 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 358 [name] => Ψυχολογία - Συμβουλευτική - Πρακτικοί οδηγοί [link_rewrite] => psichologia-simvouleftiki-praktiki-odigi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 358 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 398 [name] => Ιστορία [link_rewrite] => istoria [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 398 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 371 [name] => Επιστήμες της αγωγής [link_rewrite] => epistimes-tis-agogis [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 371 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 372 [name] => Εκπαιδευτική βιβλιοθήκη [link_rewrite] => ekpedeftiki-vivliothiki [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 372 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 385 [name] => Εκπαίδευση ενηλίκων [link_rewrite] => ekpedefsi-enilikon [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 385 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 395 [name] => Κοινωνικό [link_rewrite] => kinoniko [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 395 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 345 [name] => Εκλαϊκευμένη επιστήμη [link_rewrite] => eklaikevmeni-epistimi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 345 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 396 [name] => Κοινωνιολογία - Ανθρωπολογία [link_rewrite] => kinoniologia-nthropologia [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 396 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 309 [name] => Θρίλερ [link_rewrite] => thriler [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 309 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 439 [name] => Σκληρόδετα βιβλία παιδικής λογοτεχνίας [link_rewrite] => sklirodeta-vivlia-pedikis-logotechnias [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 439 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 469 [name] => Σημειωματάρια – Ημερολόγια [link_rewrite] => simiomataria-imerologia [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 469 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 503 [name] => Νέες κυκλοφορίες [link_rewrite] => nees-kiklofories [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 503 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 514 [name] => Ελληνική εκπαίδευση [link_rewrite] => elliniki-ekpedefsi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 514 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 516 [name] => Λατινική Γραμματεία και Φιλολογία [link_rewrite] => latiniki-grammatia-ke-filologia [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 516 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 517 [name] => Δημόσια Διοίκηση [link_rewrite] => dimosia-diikisi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 517 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 532 [name] => Ταξίδι [link_rewrite] => taxidi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 532 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 540 [name] => Λοιπά εκτός σειράς [link_rewrite] => lipa-ektos-siras [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 540 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 541 [name] => Σημειωματάρια [link_rewrite] => simiomataria [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 541 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 543 [name] => Κουπόνια-eBooks [link_rewrite] => kouponia-ebooks [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 543 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 547 [name] => Να ένα μήλο [link_rewrite] => na-ena-milo [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 547 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 548 [name] => Σύγκριση [link_rewrite] => sigkrisi [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 548 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 549 [name] => Άτλαντες [link_rewrite] => tlantes [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 549 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 550 [name] => Audio CD-DVD [link_rewrite] => audio-cd-dvd [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 550 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Array ( [0] => Array ( [id_category] => 552 [name] => Πληροφορική [link_rewrite] => pliroforiki [id_shop] => 1 ) [1] => Array ( ) [2] => SELECT cp.`id_product` as id FROM `ps_category_product` cp LEFT JOIN `ps_product` as ps ON cp.`id_product` = ps.`id_product` LEFT JOIN `ps_stock_available` as psa ON cp.`id_product` = psa.`id_product` AND psa.`id_product_attribute` = 0 WHERE ( cp.`id_category` = 552 ) AND ps.`active` = 1 AND psa.quantity > 0 ORDER BY `position` ASC LIMIT 3 )
Ο Σακελλάρης Ν. Τρικοίλης γεννήθηκε στην Κάλυμνο το 1943,
σπούδασε Κλασική Φιλολογία στο Πανεπιστήμιο Αθηνών, υπηρέτησε ως καθηγητής στα
λύκεια του νησιού του και τα τελευταία χρόνια είναι διευθυντής του Νικηφορείου
1ου Λυκείου Καλύμνου.
Άρθρα σε αθηναϊκές & ροδιακές εφημερίδες και σε περιοδικά πάνω σε θέματα εκπαιδευτικά, πολιτικά, πολιτιστικά, κοινωνικά.
Ανακοινώσεις - Εισηγήσεις σε συνέδρια και συμπόσια επιστημονικά, εκπαιδευτικά και αναπτυξιακά της Δωδεκανήσου και της Περιφέρειας Νοτίου Αιγαίου.
Εκπαίδευση, Κοινωνία & Παραγωγικές Δυνάμεις - μια Διαλεκτική Σχέση – Εκδόσεις Δημ. Παπαδήμα, Αθήνα 1987.
Ιστορία και Πολιτισμός της Καλύμνου (σχολικό εγχειρίδιο, συλλογικό έργο) - Έκδοση Επαρχείου Καλύμνου, Αθήνα 1997.
Οι προσευχές των σφουγγαράδων στον Απόλλωνα (Οππιανός) - Έκδοση Επαρχείου Καλύμνου, Ρόδος 2002.
Παράθυρο στο Φως - 10 Διηγήματα (διαγωνισμός διηγήματος) - Έκδοση ι. μητροπόλεως Λέρου, Καλύμνου & Αστυπαλαίας, Ρόδος 2002.
Πολιτισμική-Γεωπολιτική Αναμέτρηση (υπό έκδοση).
Η Αργώ της Καλύμνου - Για το Περιβάλλον και τον Πολιτισμό (έτος ίδρυσης 1990).
Ψάξτε ξανά αυτό που θέλετε να βρείτε