SELECT p.*, pd.name AS name, pd.description, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '205' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,20 stdClass Object
(
[num_rows] => 20
[row] => Array
(
[product_id] => 8916
[model] => КН112451
[sku] => КН112451
[upc] =>
[ean] => 4606782290729
[jan] =>
[isbn] =>
[mpn] =>
[location] =>
[quantity] => 0
[stock_status_id] => 8
[image] => import_files/ac/ac17c90b2a4c11ea8acf24be051db987_54739bcb2a5611ea8acf24be051db987.jpeg
[manufacturer_id] => 0
[shipping] => 1
[price] => 25.0000
[points] => 0
[tax_class_id] => 0
[date_available] => 0000-00-00
[weight] => 0.000
[weight_class_id] => 1
[length] => 0.00000000
[width] => 0.00000000
[height] => 0.00000000
[length_class_id] => 1
[subtract] => 1
[minimum] => 1
[sort_order] => 0
[status] => 1
[viewed] => 3
[date_added] => 2021-01-14 22:30:39
[date_modified] => 2021-02-26 12:13:41
[sima_update] => 0
[name] => Тетрадь 24л клетка "Animals Yoga" (056513) Хатбер-М {Россия}
[description] =>
[rating] =>
[discount] =>
[special] =>
)
[rows] => Array
(
[0] => Array
(
[product_id] => 8916
[model] => КН112451
[sku] => КН112451
[upc] =>
[ean] => 4606782290729
[jan] =>
[isbn] =>
[mpn] =>
[location] =>
[quantity] => 0
[stock_status_id] => 8
[image] => import_files/ac/ac17c90b2a4c11ea8acf24be051db987_54739bcb2a5611ea8acf24be051db987.jpeg
[manufacturer_id] => 0
[shipping] => 1
[price] => 25.0000
[points] => 0
[tax_class_id] => 0
[date_available] => 0000-00-00
[weight] => 0.000
[weight_class_id] => 1
[length] => 0.00000000
[width] => 0.00000000
[height] => 0.00000000
[length_class_id] => 1
[subtract] => 1
[minimum] => 1
[sort_order] => 0
[status] => 1
[viewed] => 3
[date_added] => 2021-01-14 22:30:39
[date_modified] => 2021-02-26 12:13:41
[sima_update] => 0
[name] => Тетрадь 24л клетка "Animals Yoga" (056513) Хатбер-М {Россия}
[description] =>
[rating] =>
[discount] =>
[special] =>
)
[1] => Array
(
[product_id] => 107047
[model] => КН98586
[sku] => КН98586
[upc] =>
[ean] => 2009999992714
[jan] =>
[isbn] =>
[mpn] =>
[location] =>
[quantity] => 0
[stock_status_id] => 8
[image] => no_image.png
[manufacturer_id] => 0
[shipping] => 1
[price] => 16.0000
[points] => 0
[tax_class_id] => 0
[date_available] => 0000-00-00
[weight] => 0.000
[weight_class_id] => 1
[length] => 0.00000000
[width] => 0.00000000
[height] => 0.00000000
[length_class_id] => 1
[subtract] => 1
[minimum] => 1
[sort_order] => 0
[status] => 1
[viewed] => 3
[date_added] => 2021-01-16 19:11:27
[date_modified] => 2021-02-26 12:15:46
[sima_update] => 0
[name] => Тетрадь 24л клетка "Choco&Milk" блестки 3943 BG {Россия}
[description] =>
[rating] =>
[discount] =>
[special] =>
)
[2] => Array
(
[product_id] => 8917
[model] => КН117104
[sku] => КН117104
[upc] =>
[ean] => 4690326200572
[jan] =>
[isbn] =>
[mpn] =>
[location] =>
[quantity] => 0
[stock_status_id] => 8
[image] => import_files/ac/ac17c90c2a4c11ea8acf24be051db987_54739bcc2a5611ea8acf24be051db987.jpeg
[manufacturer_id] => 0
[shipping] => 1
[price] => 15.0000
[points] => 0
[tax_class_id] => 0
[date_available] => 0000-00-00
[weight] => 0.000
[weight_class_id] => 1
[length] => 0.00000000
[width] => 0.00000000
[height] => 0.00000000
[length_class_id] => 1
[subtract] => 1
[minimum] => 1
[sort_order] => 0
[status] => 1
[viewed] => 3
[date_added] => 2021-01-14 22:30:39
[date_modified] => 2021-02-26 12:13:41
[sima_update] => 0
[name] => Тетрадь 24л клетка "Classic" (ассорти) 6885 BG {Россия}
[description] =>
[rating] =>
[discount] =>
[special] =>
)
[3] => Array
(
[product_id] => 109801
[model] => КН132275
[sku] => КН132275
[upc] =>
[ean] => 4690326222871
[jan] =>
[isbn] =>
[mpn] =>
[location] =>
[quantity] => 0
[stock_status_id] => 8
[image] => import_files/46/46c19b8cf76b11eaa3d724be051db987_46c19b8df76b11eaa3d724be051db987.jpeg
[manufacturer_id] => 0
[shipping] => 1
[price] => 18.0000
[points] => 0
[tax_class_id] => 0
[date_available] => 0000-00-00
[weight] => 0.000
[weight_class_id] => 1
[length] => 0.00000000
[width] => 0.00000000
[height] => 0.00000000
[length_class_id] => 1
[subtract] => 1
[minimum] => 1
[sort_order] => 0
[status] => 1
[viewed] => 4
[date_added] => 2021-01-16 19:19:52
[date_modified] => 2021-02-26 12:16:48
[sima_update] => 0
[name] => Тетрадь 24л клетка "Cool boy" (ассорти) 9020 BG {Россия}
[description] => Ст.Уп: 12\120 шт
Тетради 24 л клетка
Тетрадь 24л клетка "Animals Yoga" (056513) Хатбер-М {Россия}
Тетрадь 24л клетка "MIX-10 Девочки" (ассорти) 10 дизайнов 8541 BG {Россия}
Тетрадь 24л клетка "MIX-10 Мальчики" (ассорти) 10 дизайнов 8540 BG {Россия}
Тетрадь 24л клетка "MonsterTruck" (051530) Хатбер-М {Россия}
Тетрадь 24л клетка "Алиса в Стране Чудес - Gapchinska" 5659 BG {Россия}
Тетрадь 24л клетка "ВЕЛИКОЛЕПНАЯ ПЯТЁРОЧКА" ТШК24КР-ВП Creativiki {Россия}
Тетрадь 24л клетка "Веселый горошек" (046943) Хатбер-М {Россия}
Тетрадь 24л клетка "Вся правда о медведях- (We Bare Bears)" (058159) Хатбер-М {Россия}
