Λυπούμαστε για την ταλαιπωρία.
Ψάξτε ξανά αυτό που θέλετε να βρείτε
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 )
Ο Δημήτριος Σ. Πανάγος είναι ο επίσημος φωτογράφος της Ιεράς Αρχιεπισκοπής Αμερικής. Γεννημένος στον Πραγματευτή Κυνουρίας το 1958, μετανάστευσε με την οικογένειά του στις ΗΠΑ σε ηλικία 11 ετών. Από το 1988 συνεργάζεται με τον «Ορθόδοξο Παρατηρητή» της Ιεράς Αρχιεπισκοπής Αμερικής, ενώ από το 1994 είναι ο ανταποκριτής του ΑΠΕ στη Νέα Υόρκη. Φωτογραφίες του έχουν δημοσιευθεί σε εφημερίδες και περιοδικά στις ΗΠΑ, την Ελλάδα, την Κύπρο και παγκοσμίως. Ανάμεσά τους: «TIME Magazine», «Newsweek», «People», «Έθνος», «Τα Νέα», «Ελευθεροτυπία», «Πρωινή» και «Εθνικός Κήρυξ». Είναι μέλος των National Press Photographers Association (NPPA), United Nations Correspondents Association (UNCA), Senate Press Photographers και της Ένωσης Φωτορεπόρτερ Ελλάδας. Με τις φωτογραφίες του συνέβαλε στις εκδόσεις DIMITRIOS in the USA 1990 και IAKOVOS: The Making of an Archbishop. Είναι συνεκδότης της εφημερίδας «Greek News».
Dimitrios S. Panagos (b. 1958 in Pragmateftis, Greece) is the Official photographer of the Greek Orthodox Archdiocese of America. He emigrated with his family to New York at the age of 11. He contributes to the Archdiocese’s “Orthodox Observer” since 1988 and is the corresponding photographer for “Athens News Agency” since 1994. His work has been published in many news publications in the US, Greece, Cyprus and worldwide, including “TIME Magazine”, “Newsweek”, “People”, “Ethnos”, “Ta Nea”, “Eleytherotypia”, “Proini” and “The National Herald”. He is a member of the National Press Photographers Association (NPPA), United Nations Correspondents Association (UNCA) and the Senate Press Photographers. He was the main contributor for the books DIMITRIOS in the USA 1990 and IAKOVOS: The Making of an Archbishop. He is the co-publisher of the weekly “Greek News”.
Ψάξτε ξανά αυτό που θέλετε να βρείτε