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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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
)
Κατάλογος προϊόντων κατά προμηθευτή Μαρκάρης Πέτρος
Γεννήθηκε στην Πόλη, όπου πέρασε τα εφηβικά του χρόνια. Στην Ελλάδα εγκαταστάθηκε μόνιμα από το
1964. Σπούδασε οικονομικές επιστήμες και δούλεψε για πολλά χρόνια ως στέλεχος επιχειρήσεων.
Από το 1976 εργάζεται ως ελεύθερος συγγραφέας.
Στο θέατρο εμφανίστηκε για πρώτη φορά το 1965 με το έργο του Η Ιστορία του Αλή Ρέτζο.
Ακολούθησαν τα έργα Το Επος του Βασιλιά Υμπύ (1972), Οι Φιλοξενούμενοι (1981),
Οπως και τ' Αλογα (1986) και το τηλεοπτικό έργο Τυχαίο Πάθος (1988). Ασχολήθηκε
συστηματικά με τη μετάφραση, κυρίως έργων του Μπρεχτ (Η Μάνα Κουράγιο και τα Παιδιά της, Βίος
του Γαλιλαίου, Ανοδος και Πτώση του Γ' Ράιχ, Βάαλ, Οι Γάμοι των Μικροαστών, Ιστορίες του Κυρίου
Κόυνερ, Ποιήματα - Επιλογή), αλλά και των Πέτερ Βάις (Η Ανάκριση), Γκρέοργκ Μπύχνερ
(Βόιτσεκ), Φρανκ Βέντεκιντ (Λούλου), Αρτουρ Σνίτσλερ (Γαϊτανάκι) και
Φραντς Ξαβέρ Κραιτς (Ούτε Κρύο Ούτε Ζέστη και Αγρότες Πεθαίνουν).
Συνεργάστηκε με τον Θόδωρο Αγγελόπουλο στα σενάρια των ταινιών του Μέρες του '36,
Μεγαλέξανδρος, Το Μετέωρο Βήμα του Πελαργού και Το Βλέμμα του Οδυσσέα. Εγραψε τα
σενάρια των τηλεοπτικών σειρών Ιστορίες Μυστηρίου και Φαντασίας, Μια Γυναίκα από το
Παρελθόν. Η τρίτη τηλεοπτική σειρά που έγραψε, η Ανατομία Ενός Εγκλήματος, απ' όπου
βγήκε και το ομότιτλο βιβλίο, γνώρισε τεράστια επιτυχία.
Μια σειρά δοκιμίων του πάνω στο έργο του Μπρεχτ κυκλοφόρησε από τις εκδόσεις «Ιθάκη» με τίτλο
Ο Μπρεχτ και ο Διαλεκτικός Λόγος.