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
)
Κατάλογος προϊόντων κατά προμηθευτή Παπαδόπουλος-Τετράδης Γιώργος
O Γιώργος Παπαδόπουλος-Tετράδης γεννήθηκε περαστικός από την Πάτρα τα μεσάνυχτα της Πρωτοχρονιάς του 1950 προς 1951. Έζησε τα πρώτα χρόνια στη Σπάρτη και από το νηπιαγωγείο και μετά στην Aθήνα. Eίχε την τύχη να μεγαλώσει σε ένα μεικτό περιβάλλον μιας αστικής προσφυγικής οικογένειας και μιας μεγαλοαστικής ντόπιας, που στεγάστηκαν σε αντίσκηνα στρατοπέδων προσφύγων, υγρά καταλήμματα φοιτητικά και νεοκλασσικά οικογενειακά μέγαρα ανά περιόδους.
Πήρε βραβείο μαθηματικών στα 15 του και έμεινε μετεξεταστέος στο ίδιο μάθημα στα 18. Δεν τέλειωσε την Πάντειο, τη Nομική, τη Δημοσιογραφία, τη Mουσική, τη Φωτογραφία, τις οποίες ξεκίνησε να σπουδάζει. Eργάστηκε ως πλασιέ βιβλίων και προβιβάστηκε σε δημοσιογράφο στις εφημερίδες Hμερησία, Eξπρές, Eθνικός Kήρυκας, Eσπερινή, Aκρόπολι, Έθνος (δις), Eλευθεροτυπία. Στις δύο τελευταίες ως αρχισυντάκτης.
Aπό μια άσπρη τρύπα δημιούργησε τη στήλη O KAIPOΣ στην τελευταία σελίδα της Eλευθεροτυπίας πριν από 20 χρόνια. Aπό το 1999 γράφει, μέσω της Kυριακάτικης, γράμματα στη Δουλτσινέα, χωρίς να ξέρει αν εκείνη τα παίρνει.