Warning: Expression #16 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'znqjhtsj_biovitum.c.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [SELECT
p.id,
p.url,
p.brand_id,
p.name,
p.annotation,
p.body,
p.position,
p.created as created,
p.visible,
p.featured,
p.meta_title,
p.meta_keywords,
p.meta_description,
b.name as brand,
b.url as brand_url,
c.name as category
FROM s_products p
LEFT JOIN s_brands b ON p.brand_id = b.id
LEFT JOIN s_products_categories pc ON pc.product_id = p.id
LEFT JOIN s_categories c ON c.id = pc.category_id
WHERE
1
AND (SELECT 1 FROM s_variants pv WHERE pv.product_id=p.id AND pv.compare_price>0 LIMIT 1) = 1
AND p.visible=1
GROUP BY p.id
ORDER BY p.position DESC
LIMIT 0, 24 ] in /home/znqjhtsj/public_html/api/Database.php on line 105
Warning: Expression #16 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'znqjhtsj_biovitum.c.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /home/znqjhtsj/public_html/api/Database.php on line 150
Warning: Invalid argument supplied for foreach() in /home/znqjhtsj/public_html/view/ProductsView.php on line 149
