Брендові жіночі шкіряні куртки

array(12) { [3212]=> array(49) { ["product_id"]=> string(4) "3212" ["name"]=> string(55) "Куртка жіноча екошкіра Maison Espin" ["description"]=> string(854) "<p>Куртка жіноча екошкіра Maison Espin укороченої моделі на підкладці. Виріз горловини - круглий. Застібка блискавка. Спинка декорована оборкою в кілька рядів. З боків врізні кишені. Практична модель з висого якості матеріалів. Ефектна куртка, створена для цікавих луків, а урізноманітнити образ допоможуть аксесуари.</p> <p>Якщо вам сподобалася модель, замовити куртку жіночу Maison Espin ви зможете в нашому магазині, оформивши заявку по телефону або через сайт.</p> " ["characteristics"]=> string(501) "<ul> <li>Модель: куртка;</li> <li>Фасон: приталений;</li> <li>Колір бежевий;</li> <li>Візерунок: немає;</li> <li>Склад: поліестер 100%;</li> <li>Сезон: осінь-весна;</li> <li>Виробник: Maison Espin (Мейсон Еспін);</li> <li>Країна бренду: Італія.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(25) "Куртка Maison Espin" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Куртка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "3212" ["sku"]=> string(9) "MW16S06KE" ["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(43) "data/1c/utp005815_catalog_news_img_5908.jpg" ["manufacturer_id"]=> string(2) "97" ["manufacturer"]=> string(12) "Maison Espin" ["manufacturer_size_table"]=> string(1341) "<table class="size-table"> <tbody> <tr> <td>Міжнародний&nbsp; (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>&nbsp;</td> <td>нотатки</td> </tr> <tr> <td>Maison Espin</td> <td>XXS</td> <td>XS</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> <td>&nbsp;</td> </tr> <tr> <td>Maison Espin(жіночі штани, шорти)</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> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "8500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["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(2) "49" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-20 16:59:20" ["date_modified"]=> string(19) "2021-11-30 10:50:46" ["viewed"]=> string(3) "993" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "220" [3]=> string(3) "224" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '224' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [3211]=> array(49) { ["product_id"]=> string(4) "3211" ["name"]=> string(40) "Куртка коротка Maison Espin" ["description"]=> string(653) "<p>Куртка коротка Maison Espin виконана з високоякісної&nbsp;эко шкіри. Силует приталений. Застібка блискавка. Виріз горловини - круглий. Така куртка просто необхідна для створення сучасного весняного лука.</p> <p>Якщо вам сподобалася модель, замовити куртку коротку Maison Espin ви зможете в нашому магазині, оформивши заявку по телефону або через сайт.</p> " ["characteristics"]=> string(566) "<ul> <li>Модель: куртка;</li> <li>Фасон: приталений;</li> <li>Колір синій;</li> <li>Візерунок: немає;</li> <li>Склад: поліуретан 57%, віскоза 35%, поліестер 5%, інші волокна;</li> <li>Сезон: осінь-весна;</li> <li>Виробник: Maison Espin (Мейсон Еспін);</li> <li>Країна бренду: Італія.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(25) "Куртка Maison Espin" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Куртка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "3211" ["sku"]=> string(9) "MW16S02KE" ["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(43) "data/1c/utp005814_catalog_news_img_6082.jpg" ["manufacturer_id"]=> string(2) "97" ["manufacturer"]=> string(12) "Maison Espin" ["manufacturer_size_table"]=> string(1341) "<table class="size-table"> <tbody> <tr> <td>Міжнародний&nbsp; (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>&nbsp;</td> <td>нотатки</td> </tr> <tr> <td>Maison Espin</td> <td>XXS</td> <td>XS</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> <td>&nbsp;</td> </tr> <tr> <td>Maison Espin(жіночі штани, шорти)</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> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "6450.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["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(2) "48" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-20 16:59:20" ["date_modified"]=> string(19) "2021-11-30 10:51:00" ["viewed"]=> string(4) "1054" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "220" [3]=> string(3) "224" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '224' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [3210]=> array(49) { ["product_id"]=> string(4) "3210" ["name"]=> string(45) "Куртка з екошкіри Maison Espin" ["description"]=> string(697) "<p>Куртка з екошкіри Maison Espin чорного кольор, укороченого силуету на блискавці. Куртка декорована бахрамою. Виріз горловини круглий. Куртка виглядає красиво і стильно. Вона відмінно впишеться в весняно-літній гардероб.</p> <p>Якщо вам сподобалася модель, замовити куртку з екошкіри&nbsp;Maison Espin ви зможете в нашому магазині, оформивши заявку по телефону або через сайт.</p> " ["characteristics"]=> string(501) "<ul> <li>Модель: куртка;</li> <li>Фасон: приталений;</li> <li>Колір чорний;</li> <li>Візерунок: немає;</li> <li>Склад: поліуретан 40%, поліестер 60%;</li> <li>Сезон: осінь-весна;</li> <li>Бренд: Oakwood (Оквуд);</li> <li>Країна бренду: Франція</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(25) "Куртка Maison Espin" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Куртка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "3210" ["sku"]=> string(9) "MW16S01KE" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "5" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(61) "data/1c/utp005813_catalog_kocca_richroyal_mayson_img_2910.jpg" ["manufacturer_id"]=> string(2) "97" ["manufacturer"]=> string(12) "Maison Espin" ["manufacturer_size_table"]=> string(1341) "<table class="size-table"> <tbody> <tr> <td>Міжнародний&nbsp; (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>&nbsp;</td> <td>нотатки</td> </tr> <tr> <td>Maison Espin</td> <td>XXS</td> <td>XS</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> <td>&nbsp;</td> </tr> <tr> <td>Maison Espin(жіночі штани, шорти)</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> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "5500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["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(2) "47" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-20 16:59:20" ["date_modified"]=> string(19) "2021-11-30 10:51:12" ["viewed"]=> string(4) "1122" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "220" [3]=> string(3) "224" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '224' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [3213]=> array(49) { ["product_id"]=> string(4) "3213" ["name"]=> string(38) "Куртка жіноча Maison Espin" ["description"]=> string(1070) "<p>Куртка жіноча Maison Espin укороченого силуету. Куртка `косуха` в поточному сезоні перейшла в базовий предмет гардеробу, який повинен бути у кожної дівчини, незалежно від віку і статури. Виконана з якісної еко-шкіри, вільного крою, звуженою лінією талії, зміщеною застібкою блискавкою і кнопками. Вона просто необхідна для створення сучасного весняного лука. По низу куртки пояс з металевою пряжкою. На рукавах декоративні блискавки.</p> <p>Якщо вам сподобалася модель, замовити куртку жіночу Maison Espin ви зможете в нашому магазині, оформивши заявку по телефону або через сайт.</p> " ["characteristics"]=> string(571) "<ul> <li>Модель: куртка;</li> <li>Фасон: вільний;</li> <li>Колір чорний;</li> <li>Візерунок: немає;</li> <li>Склад: верх - віскоза 53%, поліуретан 47%; підкладка - поліестер 100%;</li> <li>Сезон: осінь-весна;</li> <li>Виробник: Maison Espin (Мейсон Еспін);</li> <li>Країна бренду: Італія.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(25) "Куртка Maison Espin" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Куртка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "3213" ["sku"]=> string(14) "MW15W16KE nero" ["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(45) "data/1c/utp003963_catalog_820f8775_kopiya.jpg" ["manufacturer_id"]=> string(2) "97" ["manufacturer"]=> string(12) "Maison Espin" ["manufacturer_size_table"]=> string(1341) "<table class="size-table"> <tbody> <tr> <td>Міжнародний&nbsp; (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>&nbsp;</td> <td>нотатки</td> </tr> <tr> <td>Maison Espin</td> <td>XXS</td> <td>XS</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> <td>&nbsp;</td> </tr> <tr> <td>Maison Espin(жіночі штани, шорти)</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> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(9) "4500.0000" ["special"]=> string(9) "1800.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-31" ["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(2) "46" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2017-01-01 16:59:20" ["date_modified"]=> string(19) "2021-11-30 10:51:28" ["viewed"]=> string(4) "1085" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "220" [3]=> string(3) "224" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '224' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14903]=> array(49) { ["product_id"]=> string(5) "14903" ["name"]=> string(47) "Куртка жіноча металік Sfizio" ["description"]=> string(693) "<p>Куртка жіноча (бомбер) кольору металік Sfizio з гладкого однотонного матеріалу ідеально підходить для теплої погоди. Бейсбольний комір. Застібка на блискавку. Манжети і облямівка на резинці. Бічні кишені. Рукава 3/4. Пряма лінія плечей. Класичний крій.</p> <p>Якщо вам сподобалася модель, ви зможете купити куртку жіночу (бомбер) кольору металік Sfizio в нашому магазині.</p> " ["characteristics"]=> string(565) "<ul> <li>Модель: куртка-бомбер коротка;</li> <li>Фасон: вільний;</li> <li>Колір: сріблястий;</li> <li>Візерунок: немає;</li> <li>Верх: шкіра 100%;</li> <li>Підкладка: поліестер 100%;</li> <li>Сезон: осінь-весна;</li> <li>Бренд: Sfizio (Сфіціо);</li> <li>Країна бренду: Італія.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Куртка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(5) "14903" ["sku"]=> string(14) "19FE3643SILVER" ["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(42) "catalog/campaignss2019/4etazh/ao6b6532.jpg" ["manufacturer_id"]=> string(2) "54" ["manufacturer"]=> string(6) "Sfizio" ["manufacturer_size_table"]=> string(1576) "<table class="women"> <tbody> <tr> <td>Міжнародний&nbsp; (INT)</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> </tr> <tr> <td>Sfizio (одяг)</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> </tr> </tbody> </table> <table class="women"> <tbody> <tr> <td>Міжнародний&nbsp; (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> <td>Sfizio (джинси)</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> </tbody> </table> " ["price"]=> string(10) "13400.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-04-01" ["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(1) "8" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-31 16:59:20" ["date_modified"]=> string(19) "2021-07-13 15:16:11" ["viewed"]=> string(4) "2152" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "220" [3]=> string(3) "224" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '224' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [3236]=> array(49) { ["product_id"]=> string(4) "3236" ["name"]=> string(48) "Шкіряна куртка жіноча Oakwood" ["description"]=> string(642) "<p>Шкіряна куртка жіноча Oakwood яскравого теракотового кольору. Застібка на блискавку. Колір фурнітури срібло. Рукав повний, внизу блискавка. Комір відкладний. З боків врізні кишені на блискавці.</p> <p>Якщо вам сподобалася модель, замовити шкіряну куртку жіночу Oakwood ви зможете в нашому магазині, оформив заявку по телефону або через сайт.</p> " ["characteristics"]=> string(481) "<ul> <li>Модель: куртка;</li> <li>Фасон: приталений;</li> <li>Колір терракотовий;</li> <li>Візерунок: немає;</li> <li>Склад: шкіра 100%;</li> <li>Сезон: осінь-весна;</li> <li>Бренд: Oakwood (Оквуд);</li> <li>Країна бренду: Франція.</li> </ul> " ["color"]=> string(7) "#c5594c" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Куртка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(218) "Куртка, жіноча, шкіряна, з кишенями, з довгими рукавами, Oakwood, руда, червона, оранжева, шкіра, осіння, весняна, демісезонна" ["model"]=> string(4) "3236" ["sku"]=> string(9) "61836-538" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "2" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(58) "catalog/dn8/fotosessija/2020/zhenskaya_1_etag/img_7489.jpg" ["manufacturer_id"]=> string(2) "22" ["manufacturer"]=> string(7) "Oakwood" ["manufacturer_size_table"]=> string(644) "<p>Увага! Розміри маломірять</p> <table class="men"> <tbody> <tr> <td>Міжнародний&nbsp; (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> </tr> <tr> <td>Oakwood</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> </tr> </tbody> </table> " ["price"]=> string(9) "7980.0000" ["special"]=> string(9) "3990.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-28" ["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(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-31 16:59:20" ["date_modified"]=> string(19) "2021-06-07 11:21:01" ["viewed"]=> string(4) "1476" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "220" [3]=> string(3) "224" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '224' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [3233]=> array(49) { ["product_id"]=> string(4) "3233" ["name"]=> string(55) "Куртка шкіряна з бахромою Oakwood" ["description"]=> string(761) "<p>Куртка шкіряна з бахромою Oakwood виконана з якісного матеріалу, вільного крою. Рукава втачні. Застібка коса блискавка. Комір відкладний. Рукава і кокетка по спинці декоровані бахрамою. У такій куртці в стилі кантрі складно залишитися непоміченою.</p> <p>Якщо вам сподобалася модель, замовити куртку шкірянУ&nbsp;з бахромою Oakwood ви зможете в нашому магазині, оформивши заявку по телефону або через сайт.</p> " ["characteristics"]=> string(471) "<ul> <li>Модель: куртка;</li> <li>Фасон: приталений;</li> <li>Колір бежевий;</li> <li>Візерунок: немає;</li> <li>Склад: шкіра 100%;</li> <li>Сезон: осінь-весна;</li> <li>Бренд: Oakwood (Оквуд);</li> <li>Країна бренду: Франція.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Куртка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(146) "Куртка, жіноча, шкіряна, з бахромою, Oakwood, замша, замшева, осіння, весняна, коротка" ["model"]=> string(4) "3233" ["sku"]=> string(5) "61910" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "4" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(58) "catalog/dn8/fotosessija/2020/zhenskaya_1_etag/img_0016.jpg" ["manufacturer_id"]=> string(2) "22" ["manufacturer"]=> string(7) "Oakwood" ["manufacturer_size_table"]=> string(644) "<p>Увага! Розміри маломірять</p> <table class="men"> <tbody> <tr> <td>Міжнародний&nbsp; (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> </tr> <tr> <td>Oakwood</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> </tr> </tbody> </table> " ["price"]=> string(10) "14900.0000" ["special"]=> string(9) "7450.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-28" ["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(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-31 16:59:20" ["date_modified"]=> string(19) "2021-06-07 16:31:11" ["viewed"]=> string(4) "1093" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "220" [3]=> string(3) "224" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '224' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [3230]=> array(49) { ["product_id"]=> string(4) "3230" ["name"]=> string(48) "Куртка шкіряна жіноча Oakwood" ["description"]=> string(662) "<p>Куртка шкіряна жіноча Oakwood яскравого і незвичайного кольору фуксія. Застібка на блискавку. Колір фурнітури срібло. Рукав повний, внизу блискавка. Комір відкладний. З боків врізні кишені на блискавці.</p> <p>Якщо вам сподобалася модель, замовити куртку шкіряну жіночу Oakwood ви зможете в нашому магазині, оформивши заявку по телефону або через сайт.</p> " ["characteristics"]=> string(469) "<ul> <li>Модель: куртка;</li> <li>Фасон: приталений;</li> <li>Колір фуксія;</li> <li>Візерунок: немає;</li> <li>Склад: шкіра 100%;</li> <li>Сезон: осінь-весна;</li> <li>Бренд: Oakwood (Оквуд);</li> <li>Країна бренду: Франція.</li> </ul> " ["color"]=> string(7) "#b53559" ["video"]=> string(0) "" ["meta_title"]=> string(20) "Куртка Oakwood" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Куртка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(129) "Куртка, жіноча, рожева, шкіряна, Oakwood, натуральна, шкіра, осіння, весняна" ["model"]=> string(4) "3230" ["sku"]=> string(9) "61836 545" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "3" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(58) "catalog/dn8/fotosessija/2020/zhenskaya_1_etag/img_7455.jpg" ["manufacturer_id"]=> string(2) "22" ["manufacturer"]=> string(7) "Oakwood" ["manufacturer_size_table"]=> string(644) "<p>Увага! Розміри маломірять</p> <table class="men"> <tbody> <tr> <td>Міжнародний&nbsp; (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> </tr> <tr> <td>Oakwood</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> </tr> </tbody> </table> " ["price"]=> string(9) "7980.0000" ["special"]=> string(9) "3990.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-30" ["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(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-31 16:59:20" ["date_modified"]=> string(19) "2021-06-07 16:31:55" ["viewed"]=> string(4) "1452" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "220" [3]=> string(3) "224" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '224' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [3231]=> array(49) { ["product_id"]=> string(4) "3231" ["name"]=> string(48) "Куртка жіноча шкіряна Oakwood" ["description"]=> string(704) "<p>Куртка жіноча шкіряна Oakwood чорного кольору з тонкої шкіри. Фасон приталений. Комірець стійка.По переду&nbsp; і на рукавах вставки з перфорованої&nbsp;шкіри. Застібка блискавка сірого кольору.&nbsp;З боків врізні кишені з листочкою.</p> <p>Якщо вам сподобалася модель, замовити куртку жіночу Oakwood ви зможете в нашому магазині, оформивши заявку по телефону або через сайт.</p> " ["characteristics"]=> string(470) "<ul> <li>Модель: куртка;</li> <li>Фасон: приталений;</li> <li>Колір: чорний;</li> <li>Візерунок: немає;</li> <li>Склад: шкіра 100%;</li> <li>Сезон: осінь-весна;</li> <li>Бренд: Oakwood (Оквуд);</li> <li>Країна бренду: Франція.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Куртка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(176) "Куртка, жіноча, шкіряна, чорна, на блискавці, Oakwood, натуральна, шкіра, осіння, весняна, демісезонна" ["model"]=> string(4) "3231" ["sku"]=> string(5) "61848" ["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(60) "catalog/dn8/fotosessija/2020/zhenskaya_1_etag/img_7509-2.jpg" ["manufacturer_id"]=> string(2) "22" ["manufacturer"]=> string(7) "Oakwood" ["manufacturer_size_table"]=> string(644) "<p>Увага! Розміри маломірять</p> <table class="men"> <tbody> <tr> <td>Міжнародний&nbsp; (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> </tr> <tr> <td>Oakwood</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> </tr> </tbody> </table> " ["price"]=> string(9) "7980.0000" ["special"]=> string(9) "3990.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-28" ["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(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-31 16:59:20" ["date_modified"]=> string(19) "2021-04-21 12:34:49" ["viewed"]=> string(4) "1396" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "220" [3]=> string(3) "224" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '224' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [3234]=> array(49) { ["product_id"]=> string(4) "3234" ["name"]=> string(44) "Куртка жіноча чорна Oakwood" ["description"]=> string(736) "<p>Куртка жіноча чорна Oakwood- виконана із замші. Застібка кнопки закриті планкою. Рукав втачний. По лінії талії оздоблення декоративною бахрамою зі шкіри в тон куртки. Силует приталений, укорочений. Модель куртки це втілення витонченості і стилю.</p> <p>Якщо вам сподобалася модель, замовити куртку жіночу чорна Oakwood ви зможете в нашому магазині, оформивши заявку по телефону або через сайт.</p> " ["characteristics"]=> string(470) "<ul> <li>Модель: куртка;</li> <li>Фасон: приталений;</li> <li>Колір: чорний;</li> <li>Візерунок: немає;</li> <li>Склад: шкіра 100%;</li> <li>Сезон: осінь-весна;</li> <li>Бренд: Oakwood (Оквуд);</li> <li>Країна бренду: Франція.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Куртка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(122) "Куртка, жіноча, нубук, чорна, з бахромою, Oakwood, шкіра, осіння, весняна" ["model"]=> string(4) "3234" ["sku"]=> string(5) "61919" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "4" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(58) "catalog/dn8/fotosessija/2020/zhenskaya_1_etag/img_7526.jpg" ["manufacturer_id"]=> string(2) "22" ["manufacturer"]=> string(7) "Oakwood" ["manufacturer_size_table"]=> string(644) "<p>Увага! Розміри маломірять</p> <table class="men"> <tbody> <tr> <td>Міжнародний&nbsp; (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> </tr> <tr> <td>Oakwood</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> </tr> </tbody> </table> " ["price"]=> string(10) "12800.0000" ["special"]=> string(9) "6400.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-28" ["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(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-31 16:59:20" ["date_modified"]=> string(19) "2021-06-07 16:34:06" ["viewed"]=> string(3) "740" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "220" [3]=> string(3) "224" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '224' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [3178]=> array(49) { ["product_id"]=> string(4) "3178" ["name"]=> string(37) "Куртка жіноча Beatrice .b" ["description"]=> string(659) "<p>Куртка жіноча Beatrice .b чорна приталеного силуету, укорочена. Виріз горловини - круглий. Застібка блискавка. Створити стильний, вільний образ&nbsp;допоможе цікавий крій і оригінальний контрастний орнамент.</p> <p>Якщо вам сподобалася модель, замовити куртку жіночу Beatrice .b ви зможете в нашому магазині, оформивши заявку по телефону або через сайт.</p> " ["characteristics"]=> string(455) "<ul> <li>Модель: куртка;</li> <li>Фасон: прямий;</li> <li>Колір чорний;</li> <li>Візерунок: немає;</li> <li>Склад: шкіра 100%;</li> <li>Сезон: осінь-весна;</li> <li>Виробник: Beatrice. b</li> <li>Країна бренду: Італія.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(22) "Куртка Вeatrice" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Куртка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(0) "" ["model"]=> string(4) "3178" ["sku"]=> string(13) "16FE3453PELLE" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "3" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(38) "data/1c/utp006089_catalog_820f0033.jpg" ["manufacturer_id"]=> string(2) "58" ["manufacturer"]=> string(11) "Beatrice .b" ["manufacturer_size_table"]=> string(2531) "<table class="men"> <tbody> <tr> <td>Міжнародний&nbsp; (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>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>нотатки</td> </tr> <tr> <td>Верхній одяг</td> <td>&nbsp;</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> <td>46</td> <td>48</td> <td>50</td> <td>52</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>відповідають</td> </tr> <tr> <td>Жіночі брюки</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> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>Взуття</td> <td>34</td> <td>34,5</td> <td>35</td> <td>35,5</td> <td>36</td> <td>36,5</td> <td>37</td> <td>37,5</td> <td>38</td> <td>38,5</td> <td>39</td> <td>39,5</td> <td>40</td> <td>40,5</td> <td>41</td> <td>42</td> <td>&nbsp;</td> </tr> </tbody> </table> " ["price"]=> string(10) "13900.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2018-08-28" ["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(1) "2" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-12-20 16:59:20" ["date_modified"]=> string(19) "2021-10-29 12:31:48" ["viewed"]=> string(4) "1134" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "220" [3]=> string(3) "224" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '224' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [10579]=> array(49) { ["product_id"]=> string(5) "10579" ["name"]=> string(48) "Шкіряна жіноча куртка Oakwood" ["description"]=> string(716) "<p>Шкіряна жіноча куртка Oakwood трендового бежевого кольору. Класичного приталеного крою. Застібка на блискавку. Колір фурнітури срібло. Рукав повний внизу блискавка. Комір відкладний англійський. З боків врізні кишені на блискавці.</p> <p>Якщо вам сподобалася модель, замовити шкіряну жіночу куртку Oakwood ви зможете в нашому магазині, оформивши заявку по телефону або через сайт.</p> " ["characteristics"]=> string(472) "<ul> <li>Модель: куртка;</li> <li>Фасон: приталений;</li> <li>Колір: бежевий;</li> <li>Візерунок: немає;</li> <li>Склад: шкіра 100%;</li> <li>Сезон: осінь-весна;</li> <li>Бренд: Oakwood (Оквуд);</li> <li>Країна бренду: Франція.</li> </ul> " ["color"]=> string(0) "" ["video"]=> string(0) "" ["meta_title"]=> string(0) "" ["meta_h1"]=> string(0) "" ["meta_productNameInCard"]=> string(12) "Куртка" ["meta_description"]=> string(0) "" ["meta_keyword"]=> string(0) "" ["tag"]=> string(178) "Куртка, жіноча, шкіряна, сіра, Oakwood, коса блискавка, шкіра, натуральна, осіння, весняна, демісезонна" ["model"]=> string(5) "10579" ["sku"]=> string(5) "62005" ["upc"]=> string(0) "" ["ean"]=> string(0) "" ["jan"]=> string(0) "" ["isbn"]=> string(0) "" ["mpn"]=> string(0) "" ["location"]=> string(0) "" ["quantity"]=> string(1) "3" ["stock_status"]=> string(17) "В наличии" ["image"]=> string(58) "catalog/dn8/fotosessija/2020/zhenskaya_1_etag/img_0001.jpg" ["manufacturer_id"]=> string(2) "22" ["manufacturer"]=> string(7) "Oakwood" ["manufacturer_size_table"]=> string(644) "<p>Увага! Розміри маломірять</p> <table class="men"> <tbody> <tr> <td>Міжнародний&nbsp; (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> </tr> <tr> <td>Oakwood</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> </tr> </tbody> </table> " ["price"]=> string(10) "11600.0000" ["special"]=> string(9) "5800.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2020-08-28" ["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(1) "1" ["status"]=> string(1) "1" ["date_added"]=> string(19) "2020-08-28 14:44:37" ["date_modified"]=> string(19) "2021-08-17 10:29:44" ["viewed"]=> string(4) "1168" ["categories"]=> array(4) { [0]=> string(2) "18" [1]=> string(2) "73" [2]=> string(3) "220" [3]=> string(3) "224" } [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 = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '224' GROUP BY p.product_id ORDER BY p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }