Λυπούμαστε για την ταλαιπωρία.
Ψάξτε ξανά αυτό που θέλετε να βρείτε
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 )
Ο Δημήτρης Μυταράς γεννήθηκε στη Χαλκίδα το 1934.
Σπούδασε ζωγραφική στην Ανωτάτη Σχολή Καλών Τεχνών Αθηνών και σκηνογραφία στην
Ανωτάτη Σχολή Διακοσμητικών Τεχνών του Παρισιού.
Η ζωγραφική του χαρακτηρίζεται από έντονο κινησιακό σχέδιο και χρωματική
διαύγεια. Σ’ όλες τις περιόδους της ζωγραφικής του υπάρχει μια διάχυτη
εξπρεσιονιστική ατμόσφαιρα με φανερή κριτική διάθεση. Οι πλαστικές του αξίες
έχουν κλασική δομή και η επαφή με την ελληνική παράδοση είναι φανερή.
Καθηγητής στην Ανωτάτη Σχολή Καλών Τεχνών Αθηνών καιι πρύτανης το 1982-85, ο
Μυταράς έχει εκθέσει σε πολλές πρωτεύουσες του κόσμου και έχει λάβει μέρος σ’
όλες τις σημαντικές Μπιενάλε.
Σημαντικές περίοδοι της ζωγραφικής του είναι «Οι καθρέφτες» (1960-64), η
«Δικτατορία» (1966-70), τα «Επιτύμβια» (1988-91), τα «Πορτρέτα» (1977-87), οι
«Σκηνές από το φανταστικό θέατρο» (1988-91), το «Εργαστήρι μου» (1994), τα
«Όστρακα» (1998), τα «Αδέσποτα σκυλιά» (2001), «Τα παιχνίδια» (2005).
Παράλληλα έχει εκθέσει και στην Εθνική πινακοθήκη, στο Château Chenonceau στη
Γαλλία, στο Μουσείο Millesgörden στη Στοκχόλμη, το Palazzo Vecchio στη
Φλωρεντία.
Τιμήθηκε από την πολιτεία με τον Χρυσό Ταξιάρχη του Φοίνικα, και από τον Δήμο
Χαλκιδέων με το χρυσό μετάλλιο της πόλης.
Έχει εκδόσει μελέτες, ερευνητικά προγράμματα, επιφυλλίδες, ποίηση κτλ.
Ψάξτε ξανά αυτό που θέλετε να βρείτε