Mysql Error ~ Executing query failed!!
Description: 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 '©=NL' at line 1
Errornumber: 1064
Errorquery: SELECT ac.parent, acl.categoryname FROM article_category as ac INNER JOIN article_category_lang as acl ON ac.categoryno = acl.categoryno WHERE acl.languagecode = 'FR' AND ac.categoryno=172〈=NL
Errortrace: #0 SSQL->query() called at [/home/httpd/vhosts/alphaprice.com/php/lib_website.php:50] #1 GetParentProductCategoryno(172〈=NL) called at [/home/httpd/vhosts/alphaprice.com/httpdocs/category.php:149]
Mysql Error ~ Executing query failed!!
Description: 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 '©=NL,172〈=NL)) AND languagecode = 'FR' AND ap.price_FR > 0' at line 15
Errornumber: 1064
Errorquery: SELECT count(distinct(a.articleno)) as amount FROM article_category ac INNER JOIN article_categorymember acm ON ac.categoryno = acm.categoryno INNER JOIN article a ON acm.articleno = a.articleno INNER JOIN article_stock as ast ON a.articleno = ast.articleno AND ast.quantity>0 INNER JOIN article_price AS ap ON a.articleno = ap.articleno INNER JOIN article_lang al ON a.articleno = al.articleno WHERE a.active = 'Y' AND (ac.categoryno IN (172〈=NL,172〈=NL)) AND languagecode = 'FR' AND ap.price_FR > 0
Errortrace: #0 SSQL->query() called at [/home/httpd/vhosts/alphaprice.com/httpdocs/category.php:195]
Plaque induction
 |
|
Mysql Error ~ Executing query failed!! Description: 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 '©=NL,172〈=NL)) AND ap.priceno = (SELECT priceno ' at line 56 Errornumber: 1064 Errorquery: SELECT distinct(a.articleno), spotlight_from_FR as spotlight_from, spotlight_till_FR as spotlight_till, a.spotlight, ap.price_FR as price, ap.priceno, ap.vat, ( if ( specialoffer_FR ='Y', ( if ( spotlight_from_FR <=CURDATE(), ( if ( spotlight_till_FR >=CURDATE(), specialprice_FR , ap.price_FR ) ) , ap.price_FR ) ) , ap.price_FR ) + ( if ( specialoffer_FR ='Y', ( if ( spotlight_from_FR <=CURDATE(), ( if ( spotlight_till_FR >=CURDATE(), specialprice_FR , ap.price_FR ) ) , ap.price_FR ) ) , ap.price_FR ) *ap.vat/100)) as prijs, ap.recupel, specialoffer_FR as specialoffer, specialprice_FR as specialprice, al.articlename, al.shortdesc, al.spotlighttext, ast.quantity, (SELECT SUM(quantity) FROM article_stock as ast WHERE ast.articleno = a.articleno) as items FROM article_category ac INNER JOIN article_categorymember acm ON ac.categoryno = acm.categoryno INNER JOIN article a ON acm.articleno = a.articleno LEFT JOIN article_stock as ast ON a.articleno = ast.articleno INNER JOIN article_price AS ap ON a.articleno = ap.articleno INNER JOIN article_lang al ON a.articleno = al.articleno WHERE a.active = 'Y' AND (ac.categoryno IN(172〈=NL,172〈=NL)) AND ap.priceno = (SELECT priceno FROM article_price WHERE articleno = a.articleno ORDER BY if( specialoffer_FR ='Y',(if( spotlight_from_FR <=CURDATE(),(if( spotlight_till_FR >=CURDATE(), specialprice_FR , ap.price_FR )), ap.price_FR )), ap.price_FR ) ASC LIMIT 0,1) AND languagecode = 'FR' AND (SELECT SUM(quantity) FROM article_stock as ast WHERE ast.articleno = a.articleno) > 0 AND ap.price_FR > 0 GROUP BY a.articleno ORDER BY prijs LIMIT 0 ,9 Errortrace: #0 SSQL->query() called at [/home/httpd/vhosts/alphaprice.com/httpdocs/category.php:477] Aucun résultat trouvé... |
