Notice: Query: SELECT products.product_id FROM
products
WHERE products.product_id IN ()
ORDER BY products.revenue DESC
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY products.revenue DESC' at line 3 in /home/livingunlimitedc/public_html/shared/pages/filter/m.filter.php on line 160
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/livingunlimitedc/public_html/shared/pages/filter/m.filter.php on line 161
Notice: Query: SELECT
ranges.range_id
,ranges.range_name
,ranges.group_id
,parents.range_name AS parent_name
,parents.parent_id
FROM
product_range
LEFT JOIN
ranges
ON product_range.range_id=ranges.range_id
LEFT JOIN
ranges AS parents
ON ranges.parent_id=parents.range_id
WHERE product_range.product_id IN () && ranges.rgt-ranges.lft='1' && ranges.group_id IN (2)
GROUP BY product_range.range_id
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') && ranges.rgt-ranges.lft='1' && ranges.group_id IN (2)
GROUP BY product_rang' at line 17 in /home/livingunlimitedc/public_html/shared/pages/filter/m.filter.php on line 195
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/livingunlimitedc/public_html/shared/pages/filter/m.filter.php on line 196
Notice: Undefined variable: summary in /home/livingunlimitedc/public_html/shared/pages/filter/m.filter.php on line 223
Notice: Undefined variable: range_id in /home/livingunlimitedc/public_html/shared/pages/filter/m.filter.php on line 282
Query:
SELECT
products.product_id
,products.product_name
,products.base_sell_price
,products.base_list_price
,products.base_price_mode
,products.product_prefix
,products.product_root
,products.product_suffix
,assets.asset_name
,assets.asset_id
,products.product_message
,content.content_id
,content.flat_url
,products.stock_message_id
,products.default_variant_id
,products.colours_json
FROM
products
LEFT JOIN
content
ON products.product_id=content.product_id
LEFT JOIN
images
ON products.image_id=images.image_id
LEFT JOIN
assets
ON images.asset_id=assets.asset_id
WHERE products.product_id IN () && content.site_id='2' && content.visibility='1' && content.content_type='2'
GROUP BY products.product_id ORDER BY FIELD(products.product_id,)
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') && content.site_id='2' && content.visibility='1' && content.content_type='2'
' at line 31
