Λυπούμαστε για την ταλαιπωρία.
Ψάξτε ξανά αυτό που θέλετε να βρείτε
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 )
Ο Ντομένικο Λαουρέντσα ασχολείται με την ιστορία των εικόνων την περίοδο της Αναγέννησης, την ιστορία της επιστημονικής εικονογραφίας και ιδιαίτερα με το έργο του Λεονάρντο. Συνεργάζεται με το Ίδρυμα και το Μουσείο Ιστορίας της Επιστήμης της Φλωρεντίας και διεξάγει ερευνητική δραστηριότητα στο Πανεπιστήμιο της Σιένα. Δημοσιεύσεις του: Leonardo. La scienza trasfigurata in arte (Λεονάρντο. Η Eπιστήμη Mετασχηματίζεται σε Tέχνη), Μιλάνο, 1999· De figura umana. Fisiognomica, anatomia e arte in Leonardo (Περί Ανθρώπινης Μορφής. Φυσιογνωμική, Ανατομία και Τέχνη στον Λεονάρντο), Φλωρεντία, 2001· La ricerca dell’ armonia. Rappresentazioni anatomiche nel Rinascimento (Η Aναζήτηση της Αρμονίας. Ανατομικές Απεικονίσεις της Αναγέννησης), Φλωρεντία, 2003· Leonardo nella Roma di Leone X (1513-1516) [Ο Λεονάρντο στη Ρώμη του Λέοντα ΙΔ (1513-1516)], Φλωρεντία, 2004. Υπήρξε επιστημονικός διευθυντής και συγγραφέας του πεντάτομου έργου Leonardo. Uomo del Rinascimento. Genio del futuro (Λεονάρντο. Άνθρωπος της Αναγέννησης. Πνεύμα του Μέλλοντος) (Μιλάνο, 2001-2003).
Ψάξτε ξανά αυτό που θέλετε να βρείτε