Λυπούμαστε για την ταλαιπωρία.
Ψάξτε ξανά αυτό που θέλετε να βρείτε
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 )
Ο σερ Άρθουρ Κλαρκ γεννήθηκε στο Σόμερσετ το 1917. Έχει
γράψει και έχει συνεργαστεί στη συγγραφή περισσότερων από εκατό βιβλίων
επιστημονικής φαντασίας, ενώ το 1945 συνέλαβε την ιδέα των δορυφορικών
τηλεπικοινωνιών. Ανάμεσα στα κλασικά έργα του συγκαταλέγεται το μικρό διήγημα
Ο Φρουρός, που αποτέλεσε τη βάση για το 2001: Η Οδύσσεια του Διαστήματος,
το οποίο συνέγραψε με τον Στάνλεϊ Κιούμπρικ.
Στη διάρκεια της ζωής του τιμήθηκε με όλα τα σημαντικά βραβεία επιστημονικής
φαντασίας και ήταν συνυποψήφιος, μαζί με τον Κιούμπρικ, για Όσκαρ σεναρίου. Το
1998 του απονεμήθηκε ο τίτλος του σερ.
Ζούσε στη Σρι Λάνκα από το 1956 και απεβίωσε εκεί το 2008, λίγο μετά την
ολοκλήρωση του παρόντος βιβλίου.
Ψάξτε ξανά αυτό που θέλετε να βρείτε