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 Ρεσάτ Νουρί Γκιούντεκιν είναι ένας από τους σπουδαιότερους Τούρκους μυθιστοριογράφους. Γεννήθηκε
στην Κωνσταντινούπολη το 1889
και πέθανε στο Λονδίνο το 1956. Αποφοίτησε από το Γαλλικό Λύκειο
της Σμύρνης και στη συνέχεια
σπούδασε Φιλολογία στο Πανεπιστήμιο
της Κωνσταντινούπολης.
Διετέλεσε καθηγητής και διευθυντής
σε πολλά λύκεια, ενώ υπηρέτησε
και ως επιθεωρητής. Υπήρξε μορφωτικός ακόλουθος της Τουρκίας στο Παρίσι
και εκπρόσωπός της στην UNESCO.
Έγραψε πολλά μυθιστορήματα,
μεταξύ των οποίων ξεχωρίζουν ιδιαίτερα τα Τσαλίκουσου, Κισμέτ και
Ο Τεκές των Αναχωρητών.
Πολλά από τα έργα του μεταφέρθηκαν
στο θέατρο, στον κινηματογράφο
αλλά και στην τηλεόραση. Εκτός από μυθιστορήματα και διηγήματα, έγραψε
και θεατρικά έργα, ενώ αρθρογραφούσε σε εφημερίδες και περιοδικά.
Στα πρώτα του έργα αντανακλώνται
τα ήθη και τα έθιμα της εποχής του.
Μετά το 1928 εστιάζει περισσότερο
στα κοινωνικά προβλήματα,
παρά στις προσωπικές αναζητήσεις.
Όλα του τα μυθιστορήματα είναι γραμμένα σε γλώσσα απλή και απευθύνονται
σε όλες τις κατηγορίες των ανθρώπων,
γι’ αυτό εξάλλου παραμένει
πάντα επίκαιρος.