Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-1' at line 27
Error No: 1064
SELECT pc.product_id, pc.category_id, pcp.category_id fromparent, p.model, p.image, p.weight, p.tax_class_id, pd.name, m.name manufacturer, m.manufacturer_id, wcd.unit, p.price, (SELECT price FROM aumi_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 aumi_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 RAND() * (SELECT MAX(product_id) FROM aumi_product) ) AS rand_id FROM aumi_product_to_category pc LEFT JOIN aumi_product_to_category pcp ON (pcp.product_id = pc.product_id AND pcp.category_id='680') LEFT JOIN aumi_product p ON (p.product_id = pc.product_id) LEFT JOIN aumi_product_description pd ON (pd.product_id = pc.product_id) LEFT JOIN aumi_manufacturer m ON (m.manufacturer_id = p.manufacturer_id) LEFT JOIN aumi_weight_class_description wcd ON (wcd.weight_class_id = p.weight_class_id AND wcd.language_id = '1') WHERE pc.category_id='560' AND pcp.category_id IS NULL AND p.hide_in_catalog <> '1' AND p.skip_in_catalog <> '1' AND p.quantity > 1 AND p.status > 0 ORDER BY rand_id ASC LIMIT -1 in /var/www/www-root/data/www/aumishop.ru/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/www-root/data/www/aumishop.ru/catalog/model/module/otherbrands.php on line 130Notice: Trying to get property of non-object in /var/www/www-root/data/www/aumishop.ru/catalog/model/module/otherbrands.php on line 136Warning: array_merge(): Argument #2 is not an array in /var/www/www-root/data/www/aumishop.ru/catalog/model/module/otherbrands.php on line 136Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-25' at line 26
Error No: 1064
SELECT pc.product_id, pc.category_id, pcp.category_id fromparent, p.model, p.image, p.weight, p.tax_class_id, pd.name, m.name manufacturer, m.manufacturer_id, wcd.unit, p.price, (SELECT price FROM aumi_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 aumi_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 RAND() * (SELECT MAX(product_id) FROM aumi_product) ) AS rand_id FROM aumi_product_to_category pc LEFT JOIN aumi_product_to_category pcp ON (pcp.product_id = pc.product_id AND pcp.category_id='680') LEFT JOIN aumi_product p ON (p.product_id = pc.product_id) LEFT JOIN aumi_product_description pd ON (pd.product_id = pc.product_id) LEFT JOIN aumi_manufacturer m ON (m.manufacturer_id = p.manufacturer_id) LEFT JOIN aumi_weight_class_description wcd ON (wcd.weight_class_id = p.weight_class_id AND wcd.language_id = '1') WHERE pc.product_id<>'0' AND pc.category_id<>'0' AND pcp.category_id IS NULL AND p.hide_in_catalog <> '1' AND p.skip_in_catalog <> '1' AND p.quantity > 1 AND p.status > 0 ORDER BY rand_id ASC LIMIT -25 in /var/www/www-root/data/www/aumishop.ru/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/www-root/data/www/aumishop.ru/catalog/model/module/otherbrands.php on line 173Warning: array_merge(): Argument #1 is not an array in /var/www/www-root/data/www/aumishop.ru/catalog/model/module/otherbrands.php on line 173Warning: Invalid argument supplied for foreach() in /var/www/www-root/data/www/aumishop.ru/catalog/controller/module/otherbrands.php on line 74 Крем для рук Dr.Phamor McCell Skin Science 365 Syn-Ake Gold Hand Cream 30ml купить в Москве, по цене 453 руб в интернет магазине корейской косметики Aumishop

Крем для рук Dr.Phamor McCell Skin Science 365 Syn-Ake Gold Hand Cream 30ml

453р.

- +
В избранное
  • Артикул: 492777

  • Вес: 30 г

  • Бренд: DR.PHAMOR

В наличии

Написать отзыв:

Другие товары бренда

Вам также может понравиться