Мужские бейсболки

array(4) { [14816]=> array(49) { ["product_id"]=> string(5) "14816" ["name"]=> string(48) "Кепка мужская синяя North Sails" ["description"]=> string(603) "<p>Кепка мужская синяя с логотипом бренда North Sails из 6 клиньев с передним швом посередине. Изогнутый козырек с прострочкой из 6 строчек. Застегивается на пряжку из металла.&nbsp;</p> <ul> </ul> <p>Если вас заинтересовала модель, купить кепку мужскую синюю с логотипом бренда North Sails вы сможете в нашем магазине.&nbsp;</p> " ["characteristics"]=> string(644) "<ul style="list-style-type:disc"> <li>Модель: летний мужской головной убор;</li> <li>Фасон: мужская кепка в спортивном стиле ;</li> <li>Цвет: синий, белый;</li> <li>Узор: логотип бренда North Sails;</li> <li>Состав: хлопок 100%;</li> <li>Сезонность: весна-лето;</li> <li>Бренд:&nbsp;North Sails (Норт Сейлз);</li> <li>Страна бренда: США.</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(111) "Кепка, мужская, синяя, North Sails, с козырьком, летняя, с логотипом" ["model"]=> string(5) "14816" ["sku"]=> string(10) "622965 760" ["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(47) "catalog/predmetka_ijun_2019/ao6b5656-kopija.jpg" ["manufacturer_id"]=> string(3) "131" ["manufacturer"]=> string(11) "North Sails" ["manufacturer_size_table"]=> string(2058) "<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>North Sails</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>&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>3XL</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>3XL</td> <td>&nbsp;</td> <td>&nbsp;</td> </tr> <tr> <td>брюки/джинсы/шорты</td> <td>&nbsp;</td> <td>&nbsp;</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> </tr> </tbody> </table> " ["price"]=> string(9) "1050.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-07-08" ["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-05-04 13:18:36" ["date_modified"]=> string(19) "2021-01-19 12:40:17" ["viewed"]=> string(3) "649" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "320" [3]=> string(3) "506" } [0]=> string(2135) "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 = '506' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15221]=> array(49) { ["product_id"]=> string(5) "15221" ["name"]=> string(57) "Кепка мужская с вышивкой Blauer. USA" ["description"]=> string(808) "<p>Кепка мужская белого цвета с бордовой вышивкой USA и Blauer с металлической застежкой. Модель из 6 клиньев. Люверсы обметаны прочными нитками в цвет изделия. Искусственные потертости усиливают кэжуальность образа. Прострочка клиньев в тон основой ткани.</p> <ul> </ul> <p>Если вас заинтересовал аксессуар, приобрести&nbsp;кепку мужскую белого цвета с бордовой вышивкой USA и Blauer можно в нашем магазине. Желаем удачных покупок!</p> " ["characteristics"]=> string(569) "<ul style="list-style-type:disc"> <li>Модель: летняя мужская кепка;</li> <li>Фасон: бейсболка, кепка-сендвич;</li> <li>Цвет: синий, белый;</li> <li>Узор: контрастная вышивка-принт USA и Blauer;</li> <li>Сезонность: вена-лето;</li> <li>Производитель:&nbsp;Blauer (Блауэр);</li> <li>Страна: США.</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(0) "" ["model"]=> string(5) "15221" ["sku"]=> string(16) "19SBLUA04389 119" ["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(40) "catalog/predmetka_ijun_2019/ao6b5609.jpg" ["manufacturer_id"]=> string(2) "61" ["manufacturer"]=> string(10) "Blauer USA" ["manufacturer_size_table"]=> string(2575) "<p>Одежда</p> <table class="size-table"> <tbody> <tr> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>3XL</td> <td>примечание</td> </tr> <tr> <td>Женские&nbsp;&nbsp;Blauer.USA</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XXL</td> <td>3XL</td> <td>&nbsp;</td> <td>маломерят</td> </tr> <tr> <td>Мужская верхняя&nbsp;одежда, костюм, пиджак, трикотаж, брюки&nbsp;Blauer.USA</td> <td>&nbsp;</td> <td>S</td> <td>M</td> <td>L</td> <td>XXL</td> <td>3XL</td> <td>&nbsp;</td> <td>маломерят</td> </tr> </tbody> </table> <p>Обувь</p> <table class="men"> <tbody> <tr> <td>Международный (INT)</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> </tr> <tr> <td>Женская обувь Blauer. USA</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>35</td> <td>&nbsp;</td> <td>36</td> <td>&nbsp;</td> <td>37</td> <td>&nbsp;</td> <td>38</td> <td>&nbsp;</td> <td>39</td> <td>&nbsp;</td> <td>40</td> <td>&nbsp;</td> <td>41</td> <td>&nbsp;</td> </tr> </tbody> </table> <p>&nbsp; &nbsp;</p> " ["price"]=> string(9) "1700.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-07-08" ["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-05-04 13:18:36" ["date_modified"]=> string(19) "2021-01-19 12:41:31" ["viewed"]=> string(3) "500" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "320" [3]=> string(3) "506" } [0]=> string(2135) "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 = '506' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [15260]=> array(49) { ["product_id"]=> string(5) "15260" ["name"]=> string(46) "Кепка мужская Harmont & Blaine" ["description"]=> string(867) "<p>Кепка мужская серого цвета в крупную клетку Harmont &amp; Blaine воплощает спортивную элегантность. Кнопка серого цвета. Прострочка клиньев в цвет ткани. Козырек приподнят, прострочка 2 строчки. Без люверсов. Сзади ремешок с металлической пряжкой&nbsp; для регулирования размера.&nbsp;</p> <ul style="list-style-type:disc"> </ul> <p>Если вас заинтересовал аксессуар, приобрести&nbsp;кепку мужскую серого цвета в крупную клетку Harmont &amp; Blaine вы можете в нашем магазине.</p> " ["characteristics"]=> string(643) "<ul style="list-style-type:disc"> <li>Модель: мужской головной убор;</li> <li>Фасон: спортивная кепка (бейсболка);</li> <li>Цвет: серый, оранжевый, синий;</li> <li>Узор: клетка;</li> <li>Состав: хлопок 100%;</li> <li>Сезонность: весна-лето;</li> <li>Бренд:&nbsp;Harmont &amp; Blaine (Хармонт и Блэйн);</li> <li>Страна бренда: Италия.</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(0) "" ["model"]=> string(5) "15260" ["sku"]=> string(16) "N0B006052887 812" ["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(40) "catalog/predmetka_ijun_2019/ao6b5642.jpg" ["manufacturer_id"]=> string(2) "55" ["manufacturer"]=> string(18) "Harmont&Blaine" ["manufacturer_size_table"]=> string(1718) "<table class="men"> <tbody> <tr> <td>Верхняя одежда, костюм, пиджак, трикотаж, рубашки, брюки</td> <td>Международный (INT)</td> <td>XS</td> <td>S</td> <td>M</td> <td>L</td> <td>XL</td> <td>XXL</td> <td>XXXL</td> </tr> </tbody> <tbody> <tr> </tr> <tr> <td>Рубашки</td> <td>Европа (EU)</td> <td>38</td> <td>39</td> <td>40</td> <td>41</td> <td>42</td> <td>43</td> <td>44</td> <td>45</td> <td>46</td> <td>47</td> <td>48</td> <td>49</td> <td>50</td> </tr> </tbody> <tbody> <tr> <td>Джинсы</td> <td>Европа (EU)</td> <td>28</td> <td>29</td> <td>30</td> <td>31</td> <td>32</td> <td>33</td> <td>34</td> <td>35</td> <td>36</td> <td>37</td> <td>38</td> <td>40</td> <td>42</td> <td>44</td> </tr> <tr> <td>Головные уборы</td> <td>one size</td> </tr> </tbody> <tbody> </tbody> </table> " ["price"]=> string(9) "2500.0000" ["special"]=> NULL ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-07-08" ["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-05-04 13:18:36" ["date_modified"]=> string(19) "2021-01-19 12:42:59" ["viewed"]=> string(3) "652" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "320" [3]=> string(3) "506" } [0]=> string(2135) "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 = '506' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } [14009]=> array(49) { ["product_id"]=> string(5) "14009" ["name"]=> string(49) "Кепка мужская с принтом Blend" ["description"]=> string(711) "<p>Кепка мужская темно-синяя Blend из гладкой однотонной ткани в спортивном стиле. козырек изогнут. Охват регулируется. Акцент - контрастная нашивка-принт. Подходит для создания стильного кэжуального образа.&nbsp;</p> <p>Если вам понравилась модель, вы сможете купить кепку мужскую темно-синюю с белым принтом Blend в нашем магазине, оформив заказ через сайт или по телефону.&nbsp;</p> " ["characteristics"]=> string(547) "<ul> <li>Модель: мужской головной убор;</li> <li>Фасон: кепка-бейсболка;</li> <li>Цвет: темно-синий;</li> <li>Узор: белый принт-нашивка;</li> <li>Состав: хлопок 100%;</li> <li>Сезон: весна-лето;</li> <li>Бренд:&nbsp;Blend (Бленд, Дания);</li> <li>Страна бренда: Дания.</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(0) "" ["model"]=> string(5) "14009" ["sku"]=> string(14) "20706725 75111" ["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) "catalog/novinki/1etazh/predmetka/ao6b1732.jpg" ["manufacturer_id"]=> string(3) "121" ["manufacturer"]=> string(5) "Blend" ["manufacturer_size_table"]=> string(2429) "<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>Blend&nbsp;he,&nbsp;Blend she</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> </tr> </tbody> </table> <p>Штаны, шорты</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> <td>36</td> <td>38</td> </tr> <tr> <td>Blend he</td> <td>&nbsp;</td> <td>&nbsp;</td> <td>&nbsp;</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>36</td> <td>38</td> </tr> <tr> <td>Blend she</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> </tr> </tbody> </table> " ["price"]=> string(8) "990.0000" ["special"]=> string(8) "594.0000" ["reward"]=> NULL ["points"]=> string(1) "0" ["tax_class_id"]=> string(1) "0" ["date_available"]=> string(10) "2019-03-13" ["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) "2019-03-13 12:31:30" ["date_modified"]=> string(19) "2021-01-20 15:59:24" ["viewed"]=> string(3) "389" ["categories"]=> array(4) { [0]=> string(2) "20" [1]=> string(2) "69" [2]=> string(3) "320" [3]=> string(3) "506" } [0]=> string(2135) "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 = '506' GROUP BY p.product_id ORDER BY p.old_product DESC, sort_1_lvl_cat DESC, sort_2_lvl_cat DESC, sort_main_cat DESC, p.sort_order DESC, p.date_added DESC, LCASE(pd.name) DESC LIMIT 0,12" } }