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
)
Κατάλογος προϊόντων κατά προμηθευτή Σταθόγιαννης Πάνος
Ο Πάνος Σταθόγιαννης γεννήθηκε στα Λευκάκια Ναυπλίου, στις 29 Αυγούστου του
1959. Σπούδασε Δημοσιογραφία και έκανε μεταπτυχιακά πάνω σε ζητήματα
Κοινωνιολογίας της Μαζικής Επικοινωνίας. Εχει γράψει τα σενάρια σε
πολλά ντοκιμαντέρ της Ελληνικής Τηλεόρασης.
Προηγούμενα έργα του είναι: Η Εποχή της Αλεπούς (ποίηση, 1984)·
Το Μοβ Γοητεύει τα Σαλιγκάρια (νουβέλα, 1993)· Η Κιβωτός με
τις Πρόθυμες Γυναίκες (μυθιστόρημα, 1995, Β' έκδοση 1996).
Εχει μεταφράσει και κυκλοφορούν από τις εκδόσεις μας τα έργα: Βέρα
Μουταφτσίεβα, Εγώ, η Αννα Κομνηνή (μυθιστόρημα, 1996, Βραβείο
Ελληνικής Εταιρείας Μεταφραστών Λογοτεχνίας)· Βέρα Μουταφτσίεβα,
Αλκιβιάδης ο Μικρός, Αλκιβιάδης ο Μέγας (μυθιστόρημα, 1997)·
Αντρέι Πλάτονοφ, Ταξίδι με Ανοιχτή Καρδιά (μυθιστόρημα, 1997).
Επίσης έχει μεταφράσει: Ιορντάν Ραντίτσκοφ, Το Εύηχον Σκεύος
(νουβέλες, 1998). Ποιήματα και πεζά κείμενά του έχουν μεταφραστεί
σε πολλές γλώσσες. Ζει και εργάζεται στην Αθήνα.