Colecția „Vreau să citesc!” se adresează copiilor pasionați de cunoaștere, care doresc să citească din ce în ce mai bine, dar care evită literatura. Ei au acum la dispoziție cărți de nonficțiune cu teme din domenii diverse – istorie, geografie, biologie, astronomie –, structurate pe patru niveluri de complexitate, în funcție de fluența lor în citire.
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IF(at_small_image.value_id > 0, at_small_image.value, at_small_image_default.value) AS `small_image`, `stock_status_index`.`stock_status` AS `is_salable`, `reservation`.`quantity` AS `reserved_qty`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `catalog_product_entity_varchar` AS `at_small_image_default` ON (`at_small_image_default`.`entity_id` = `e`.`entity_id`) AND (`at_small_image_default`.`attribute_id` = '88') AND `at_small_image_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_varchar` AS `at_small_image` ON (`at_small_image`.`entity_id` = `e`.`entity_id`) AND (`at_small_image`.`attribute_id` = '88') AND (`at_small_image`.`store_id` = 1)
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id
LEFT JOIN (SELECT `inventory_reservation`.`sku`, SUM(quantity) AS `quantity` FROM `inventory_reservation` WHERE (stock_id = 1) GROUP BY `sku`) AS `reservation` ON reservation.sku = e.sku
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) WHERE (e.entity_id IN (3475, 3478, 3476, 3480, 3481, 3472, 3482, 3473, 3479, 3477, 3474, 3483)) ORDER BY FIELD(e.entity_id,3475,3478,3476,3480,3481,3472,3482,3473,3479,3477,3474,3483)
Nu ai cont? Creează-ți cont aici
Ai deja cont? Intră în cont