Database error: 1064 : 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 's%' WHERE p.status=1 AND ( p.title_gr LIKE '%Nairn's%' OR b.brand LIKE '%Nairn' at line 6
Invalid query: SELECT DISTINCT(p.id), p.alias, p.title_gr title, CONCAT('/index.php?t=products&a=',pc.alias,'¶m1=',ps.alias,'¶m2=',ps2.alias,'¶m3=',p.alias) link , CONCAT('https://greenbay.gr/images/products/list/',list_image) image FROM products p LEFT JOIN product_subcategories_2 ps2 ON ps2.id = p.product_subcategory_2_id AND ps2.status = 1 LEFT JOIN product_subcategories ps ON ps.id = ps2.sub_category_id AND ps.status = 1 LEFT JOIN products_extra_categories pex ON pex.product_id = p.id INNER JOIN product_categories pc ON pc.id = ps.category_id AND pc.status = 1 LEFT JOIN product_tags pt ON p.tags LIKE CONCAT(pt.id,',%') OR p.tags LIKE CONCAT('%,',pt.id,',%') OR p.tags LIKE CONCAT('%,',pt.id) OR p.tags = pt.id LEFT JOIN brands b ON b.id = p.brand AND b.brand LIKE '%Nairn's%' WHERE p.status=1 AND ( p.title_gr LIKE '%Nairn's%' OR b.brand LIKE '%Nairn's%' OR pt.title_gr LIKE '%Nairn's%' ) GROUP BY p.id ORDER BY p.title_gr


Backtrace:
File:/home/greenbay/public_html/index.php
Line:5
Function:include
File:/home/greenbay/public_html/init.php
Line:246
Function:include
File:/home/greenbay/public_html/include/search.php
Line:86
Function:db_get_array
File:/home/greenbay/public_html/core/database.php
Line:14
Function:db_query
File:/home/greenbay/public_html/core/db_mysql.php
Line:63
Function:db_debug_error