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
)
Ο Νίκος Ρίγγας γεννήθηκε το 1937 στην πόλη της Άρτας, όπου τέλειωσε το Δημοτικό και το Γυμνάσιο.
Σπούδασε νομικά στο Πανεπιστήμιο της Αθήνας, στην οποία δικηγορεί και κατοικεί με τους δυο γιους του, αφού στις 3.4.1988 έφυγε απ' τη ζωή η σύντροφός του Ντίνα, η Φεγγαρένια του.
Διατηρεί άρρηκτους δεσμούς με τις ρίζες του.
Ανήκει στη γενιά του 1-1-4 και προέρχεται από γνωστή αντιστασιακή οικογένεια, αφού η Μάνα του, η Ρίγγενα, με την από 5.5.1944 διασωμένη Ημερήσια Διαταγή του 3/40 Συντάγματος του Ε.Λ.Α.Σ. τιμήθηκε με «έπαινον ηρωίδος» και ο μεγάλος του αδερφός, αντάρτης του Ε.Λ.Α.Σ., στάλθηκε εξορία στη Μακρόνησο.
Η μέχρι τώρα παρουσία του στα γράμματα έχει εκδηλωθεί με ποίηση, μουσική, θεατρικά έργα, δοκίμια, άρθρα, ομιλίες, ποιητικές και μουσικές βραδιές, κι όλ' αυτά για τον Έρωτα, τον Άνθρωπο, τις Ιδέες, τη Δικαιοσύνη, τον Πολιτισμό.
Εφέτος (2002) εκδόθηκε και κυκλοφορεί από τις Εκδόσεις Λιβάνη το μυθιστόρημα, Οι Κλητικές των Φωνηέντων, στο οποίο συναντιώνται και αντιμετριώνται οι ανθρώπινες αξίες με τη μάστιγα των ναρκωτικών, οι ομορφιές με τις ασκήμιες, και μεσ' απ' την αντιπαράθεση αυτή αναδείχνεται το ανθρώπινο μεγαλείο και οι παναιώνιες ανθρώπινες και γήινες ομορφιές.