Мужское нижнее белье футболки и майки

array(11) { [8799]=> array(49) { ["product_id"]=> string(4) "8799" ["name"]=> string(43) "Хлопковая футболка Perofil" ["description"]=> string(582) "Хлопковая футболка Perofil черного цвета&nbsp;сочетается с любыми вещами. Изделие прямого кроя из тонкого мягкого хлопка с короткими рукавами. Плоский шов на V-образном вырезе не натирает шею.</span></span></p> Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</span></span></p> " ["characteristics"]=> string(2192) "<ul> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif"><span style="background-color:white"><span style="color:black">Код товара: </span></span>8799</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif"><span style="background-color:white"><span style="color:black">Артикул: </span></span>24158 black</span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif"><span style="background-color:white"><span style="color:black">Бренд: Perofil</span></span></span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif"><span style="background-color:white"><span style="color:black">Страна: Италия</span></span></span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif"><span style="background-color:white"><span style="color:black">Цвет: черный</span></span></span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif"><span style="background-color:white"><span style="color:black">Рисунок: нет</span></span></span></span></li> <li><span style="font-size:14px"><span style="font-family:Arial,Helvetica,sans-serif"><span style="background-color:white"><span style="color:black">Состав: 100% хлопок</span></span></span></span></li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(17) "Футболка " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(158) "Футболка, мужская, черная, с V-образной горловиной, Perofil, хлопок, натуральный, хлопковая " ["model"]=> string(4) "8799" ["sku"]=> string(11) "24158 black" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(2) "21" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1004-ds.jpg" ["manufacturer_id"]=> string(2) "65" ["manufacturer"]=> string(7) "Perofil" ["manufacturer_size_table"]=> string(1645) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>&nbsp;</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>3</td> <td>4</td> <td>5</td> <td>6</td> <td>7</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>пижамы/домашняя одежда</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1250.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "3800" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-02-11 14:51:36" ["viewed"]=> string(3) "462" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "478" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_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 dn_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, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_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 p2c.category_id = '478' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [8803]=> array(49) { ["product_id"]=> string(4) "8803" ["name"]=> string(69) "Футболка серая мужская хлопковая Perofil" ["description"]=> string(576) "<p>Футболка серая &nbsp;мужская хлопковая Perofil с короткими рукавами выполнена&nbsp;из тонкого хлопкового джерси. Материал хорошо тянется и не теряет форму после многократных стирок. Плоские швы не натирают.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(400) "<ul> <li>Код товара: 8803</li> <li>Артикул: 24147 grey</li> <li>Бренд: Perofil</li> <li>Страна: Италия</li> <li>Цвет: серый</li> <li>Рисунок: нет</li> <li>Состав: 90% хлопок,&nbsp;эластан 10%&nbsp;</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Футболка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(135) "Футболка, мужская, с коротким рукавом, серая, хлопковая, Perofil, белье, нижнее" ["model"]=> string(4) "8803" ["sku"]=> string(10) "24147 grey" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "6" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1010-ds.jpg" ["manufacturer_id"]=> string(2) "65" ["manufacturer"]=> string(7) "Perofil" ["manufacturer_size_table"]=> string(1645) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>&nbsp;</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>3</td> <td>4</td> <td>5</td> <td>6</td> <td>7</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>пижамы/домашняя одежда</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1700.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "3800" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-02-10 15:36:37" ["viewed"]=> string(3) "387" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "478" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_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 dn_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, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_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 p2c.category_id = '478' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [8796]=> array(49) { ["product_id"]=> string(4) "8796" ["name"]=> string(52) "Футболка мужская черная Perofil" ["description"]=> string(548) "<p>Хлопковая футболка Perofil черного цвета&nbsp;сочетается с любыми вещами. Изделие прямого кроя из тонкого мягкого хлопка с короткими рукавами. Плоский шов на V-образном вырезе не натирает шею.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(365) "<ul> <li>Код товара: 8796</li> <li>Артикул: 24157 black</li> <li>Бренд: Perofil</li> <li>Страна: Италия</li> <li>Цвет: черный</li> <li>Рисунок: нет</li> <li>Состав: 100% хлопок</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Футболка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(155) "Футболка, мужская, черная, с круглой горловиной, хлопок, Perofil, хлопковая, нижнее, белье" ["model"]=> string(4) "8796" ["sku"]=> string(11) "24157 black" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(2) "18" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1017-ds.jpg" ["manufacturer_id"]=> string(2) "65" ["manufacturer"]=> string(7) "Perofil" ["manufacturer_size_table"]=> string(1645) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>&nbsp;</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>3</td> <td>4</td> <td>5</td> <td>6</td> <td>7</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>пижамы/домашняя одежда</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1250.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "3800" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-08-02 16:37:48" ["viewed"]=> string(3) "442" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "478" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_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 dn_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, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_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 p2c.category_id = '478' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [8800]=> array(49) { ["product_id"]=> string(4) "8800" ["name"]=> string(60) "Футболка мужская хлопоковая Perofil" ["description"]=> string(557) "<p>Футболка мужская хлопоковая Perofil с короткими рукавами выполнена&nbsp;из тонкого хлопкового джерси. Материал хорошо тянется и не теряет форму после многократных стирок. Плоские швы не натирают.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(401) "<ul> <li>Код товара: 8800</li> <li>Артикул: 24147 white</li> <li>Бренд: Perofil</li> <li>Страна: Италия</li> <li>Цвет: белый</li> <li>Рисунок: нет</li> <li>Состав: 90% хлопок,&nbsp;эластан 10%&nbsp;</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Футболка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(103) "Футболка, мужская, белая, с коротким рукавом, хлопок, Perofil" ["model"]=> string(4) "8800" ["sku"]=> string(11) "24147 white" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "7" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(79) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/0998-ds-2.jpg" ["manufacturer_id"]=> string(2) "65" ["manufacturer"]=> string(7) "Perofil" ["manufacturer_size_table"]=> string(1645) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>&nbsp;</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>3</td> <td>4</td> <td>5</td> <td>6</td> <td>7</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>пижамы/домашняя одежда</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1700.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "3800" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-08-02 16:38:41" ["viewed"]=> string(3) "386" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "478" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_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 dn_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, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_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 p2c.category_id = '478' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [8807]=> array(49) { ["product_id"]=> string(4) "8807" ["name"]=> string(50) "Футболка мужская серая Perofil" ["description"]=> string(691) "<p>Футболка мужская серая Perofil с короткими рукавами выполнена вручную из тонкого хлопкового джерси. Материал хорошо тянется и не теряет форму после многократных стирок. Плоские швы не натирают и не впиваются в тело, поэтому в такой вещи будет удобно в течение всего дня.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(383) "<ul> <li>Код товара: 8807</li> <li>Артикул: 24149 grey</li> <li>Бренд: Perofil</li> <li>Страна: Италия</li> <li>Цвет: серый</li> <li>Рисунок: нет</li> <li>Состав: бавовна 90%, еластан 10%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Футболка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(219) "Футболка, мужская, серая, с V-образной горловиной, хлопковая, Perofil, хлопок, эластан, купить, Украина, натуральный, материал" ["model"]=> string(4) "8807" ["sku"]=> string(10) "24149 grey" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(2) "13" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1015-ds.jpg" ["manufacturer_id"]=> string(2) "65" ["manufacturer"]=> string(7) "Perofil" ["manufacturer_size_table"]=> string(1645) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>&nbsp;</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>3</td> <td>4</td> <td>5</td> <td>6</td> <td>7</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>пижамы/домашняя одежда</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1700.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "3800" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-08-02 16:36:36" ["viewed"]=> string(3) "399" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "478" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_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 dn_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, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_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 p2c.category_id = '478' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [16094]=> array(49) { ["product_id"]=> string(5) "16094" ["name"]=> string(66) "Футболка мужская с надписью Emporio Armani" ["description"]=> string(570) "<p>Классическая футболка Emporio Armani с короткими рукавами и круглым вырезом.</p> <p>Предназначена для создания образа в спортивном стиле.</p> <p>Сшита из джерси бордового цвета, состав 100% хлопок.</p> <p>Украшена мультицветной полосой в оттенках синего цвета и логотипом линии&nbsp; Emporio Armani.</p> " ["characteristics"]=> string(443) "<ul> <li>Код товара: 16094</li> <li>Артикул: 110853 9А510 00020</li> <li>Бренд: Emporio Armani</li> <li>Страна: Италия</li> <li>Цвет: черный</li> <li>Рисунок: принт</li> <li>Материал: трикотаж</li> <li>Состав: 100% хлопок</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(17) "Футболка " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(69) "Футболка, мужская, с надписью, Emporio Armani" ["model"]=> string(5) "16094" ["sku"]=> string(18) "110853 9A510 00020" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "1" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1036-ds.jpg" ["manufacturer_id"]=> string(3) "135" ["manufacturer"]=> string(14) "Emporio Armani" ["manufacturer_size_table"]=> string(4926) "<p>Женская одежда&nbsp;</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>24</td> <td>25</td> <td>26</td> <td>27</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> </tr> <tr> </tr> <tr> <td>Emporio Armani (TOP)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Emporio Armani (BOTTOM)</td> <td>&nbsp;</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP A</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP B</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP C</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP D</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>BRA - CUP DD</td> <td>&nbsp;</td> <td>32</td> <td>34</td> <td>36</td> <td>38</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>Мужская одежда</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>боксеры, слипы</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>футболки, майки</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1600.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "3800" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-08-02 16:39:45" ["viewed"]=> string(3) "555" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "478" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_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 dn_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, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_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 p2c.category_id = '478' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [8795]=> array(49) { ["product_id"]=> string(4) "8795" ["name"]=> string(60) "Футболка мужская однотонная Perofil" ["description"]=> string(554) "<p>Футболка мужская однотонная Perofil синего цвета сочетается с любыми вещами. Изделие прямого кроя из тонкого мягкого хлопка с короткими рукавами. Плоский шов на V-образном вырезе не натирает шею.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(362) "<ul> <li>Код товара: 8795</li> <li>Артикул: 24157 blue</li> <li>Бренд: Perofil</li> <li>Страна: Италия</li> <li>Цвет: синий</li> <li>Рисунок: нет</li> <li>Состав: 100% хлопок</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Футболка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(213) "Футболка, мужская, темно-синяя, синяя, из натурального хлопка, с коротким рукавом, Perofil, хлопок, натуральный, материал " ["model"]=> string(4) "8795" ["sku"]=> string(10) "24157 blue" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(2) "16" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1024-ds.jpg" ["manufacturer_id"]=> string(2) "65" ["manufacturer"]=> string(7) "Perofil" ["manufacturer_size_table"]=> string(1645) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>&nbsp;</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>3</td> <td>4</td> <td>5</td> <td>6</td> <td>7</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>пижамы/домашняя одежда</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1250.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "3800" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-02-11 12:21:32" ["viewed"]=> string(3) "412" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "478" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_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 dn_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, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_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 p2c.category_id = '478' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [8797]=> array(49) { ["product_id"]=> string(4) "8797" ["name"]=> string(50) "Футболка мужская белая Perofil" ["description"]=> string(520) "<p>Футболка мужская белая Perofil сочетается с любыми вещами. Изделие прямого кроя из тонкого мягкого хлопка с короткими рукавами. Плоский шов на V-образном вырезе не натирает шею.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(363) "<ul> <li>Код товара: 8797</li> <li>Артикул: 24158 white</li> <li>Бренд: Perofil</li> <li>Страна: Италия</li> <li>Цвет: белый</li> <li>Рисунок: нет</li> <li>Состав: 100% хлопок</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(50) "Футболка мужская белая Perofil" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(17) "Футболка " ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(219) "Футболка, мужская, из натурального хлопка, белая, с V-образной горловиной, натуральный, материал, хлопок, Киев, заказ, Perofil" ["model"]=> string(4) "8797" ["sku"]=> string(11) "24158 white" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(2) "20" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/0991-ds.jpg" ["manufacturer_id"]=> string(2) "65" ["manufacturer"]=> string(7) "Perofil" ["manufacturer_size_table"]=> string(1645) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>&nbsp;</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>3</td> <td>4</td> <td>5</td> <td>6</td> <td>7</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>пижамы/домашняя одежда</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1250.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "3800" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-02-11 12:33:51" ["viewed"]=> string(3) "401" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "478" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_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 dn_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, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_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 p2c.category_id = '478' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [8798]=> array(49) { ["product_id"]=> string(4) "8798" ["name"]=> string(59) "Футболка мужская хлопковая Perofil" ["description"]=> string(552) "<p>Футболка мужская хлопковая Perofil синего цвета сочетается с любыми вещами. Изделие прямого кроя из тонкого мягкого хлопка с короткими рукавами. Плоский шов на V-образном вырезе не натирает шею.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(371) "<ul> <li>Код товара: 8798</li> <li>Артикул:&nbsp;24158 blue</li> <li>Бренд: Perofil</li> <li>Страна: Италия</li> <li>Цвет: синий</li> <li>Рисунок: нет</li> <li>Состав: 100% хлопок</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(16) "Футболка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(164) "Футболка, мужская, хлопковая, темно-синяя, синяя, синий, натуральный, материал, хлопок, Perofil" ["model"]=> string(4) "8798" ["sku"]=> string(10) "24158 blue" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(2) "17" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1008-ds.jpg" ["manufacturer_id"]=> string(2) "65" ["manufacturer"]=> string(7) "Perofil" ["manufacturer_size_table"]=> string(1645) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>&nbsp;</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>3</td> <td>4</td> <td>5</td> <td>6</td> <td>7</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>пижамы/домашняя одежда</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1250.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "3800" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2021-08-02 16:42:22" ["viewed"]=> string(3) "346" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "478" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_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 dn_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, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_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 p2c.category_id = '478' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [3493]=> array(49) { ["product_id"]=> string(4) "3493" ["name"]=> string(31) "Майка черная Perofil" ["description"]=> string(691) "<p>Майка черная Perofil выполнена из приятного&nbsp;на ощупь хлопка.&nbsp;<span style="background-color:white"><span style="color:black">Материал хорошо тянется и не теряет форму после многократных стирок.</span></span>&nbsp;Края пройм и круглого выреза дополнены мягким кантом в тон.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(384) "<ul> <li>Код товара: 3493</li> <li>Артикул: 24146 black</li> <li>Бренд: Perofil</li> <li>Страна: Италия</li> <li>Цвет: черный</li> <li>Рисунок: нет</li> <li>Состав: Хлопок 90%, эластан 10%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(0) "" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(84) "Майка, мужская, черная, хлопковая, Perofil, хлопок " ["model"]=> string(4) "3493" ["sku"]=> string(11) "24146 black" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(2) "16" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/1003-ds.jpg" ["manufacturer_id"]=> string(2) "65" ["manufacturer"]=> string(7) "Perofil" ["manufacturer_size_table"]=> string(1645) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>&nbsp;</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>3</td> <td>4</td> <td>5</td> <td>6</td> <td>7</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>пижамы/домашняя одежда</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1300.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "3800" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2022-02-18 12:37:18" ["viewed"]=> string(3) "394" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "477" [4]=> string(3) "478" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_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 dn_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, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_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 p2c.category_id = '478' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [3492]=> array(49) { ["product_id"]=> string(4) "3492" ["name"]=> string(29) "Майка белая Perofil" ["description"]=> string(568) "<p>Майка белая Perofil выполнена из приятного&nbsp;на ощупь хлопка.&nbsp;Материал хорошо тянется и не теряет форму после многократных стирок.&nbsp;Края пройм и круглого выреза дополнены мягким кантом в тон.</p> <p>Товар обмену и возврату не подлежит согласно ЗУ &laquo;О защите прав потребителей&raquo;</p> " ["characteristics"]=> string(382) "<ul> <li>Код товара: 3492</li> <li>Артикул: 24146 white</li> <li>Бренд: Perofil</li> <li>Страна: Италия</li> <li>Цвет: белый</li> <li>Рисунок: нет</li> <li>Состав: Хлопок 90%, эластан 10%</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(10) "Майка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(82) "Майка, мужская, белая, хлопковая, Perofil, хлопок " ["model"]=> string(4) "3492" ["sku"]=> string(11) "24146 white" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(2) "10" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(77) "catalog/dn8/fotosessija/2020/ijul/predmetka/muzhskoe_bele_pizhamy/0997-ds.jpg" ["manufacturer_id"]=> string(2) "65" ["manufacturer"]=> string(7) "Perofil" ["manufacturer_size_table"]=> string(1645) "<table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XXS</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>примечание</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>4XL</td> <td>&nbsp;</td> </tr> <tr> <td>белье</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>3</td> <td>4</td> <td>5</td> <td>6</td> <td>7</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>пижамы/домашняя одежда</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>48</td> <td>50</td> <td>52</td> <td>54</td> <td>56</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "1300.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-19" ["weight"]=> string(4) "0.00" ["weight_class_id"]=> string(1) "1" ["length"]=> string(4) "0.00" ["width"]=> string(4) "0.00" ["height"]=> string(4) "0.00" ["length_class_id"]=> string(1) "2" ["subtract"]=> string(1) "1" ["rating"]=> float(0) ["reviews"]=> int(0) ["minimum"]=> string(1) "1" ["sort_order"]=> string(4) "3800" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-19 13:14:48" ["date_modified"]=> string(19) "2022-02-18 12:36:56" ["viewed"]=> string(3) "422" ["categories"]=> array(5) { [0]=> string(2) "20" [1]=> string(2) "85" [2]=> string(3) "295" [3]=> string(3) "477" [4]=> string(3) "478" } [0]=> string(2053) "SELECT p.product_id, (SELECT AVG(rating) AS total FROM dn_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM dn_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 dn_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, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT p2c.category_id FROM dn_product_to_category p2c WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id)) AS sort_main_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 2) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_2_lvl_cat, (SELECT sort_product_order FROM dn_category WHERE category_id = (SELECT cp.path_id FROM dn_product_to_category p2c LEFT JOIN dn_category_path cp ON (cp.level = 1) WHERE p2c.main_category = 1 AND p.product_id = p2c.product_id AND cp.category_id = p2c.category_id AND cp.path_id != p2c.category_id)) AS sort_1_lvl_cat FROM dn_product_to_category p2c LEFT JOIN dn_product p ON (p2c.product_id = p.product_id) LEFT JOIN dn_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN dn_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 p2c.category_id = '478' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }