|
|
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 'and sub.id=price.subcategoryid
and manu.id=price.manufacturerid
' at line 8select sub.id as subId,sub.name as subName,
manu.id as manuId,manu.name as manuName,
count(productid) as cnt
from merchant_price_current as price,
manufacturer as manu,
subcategory as sub
where price.merchantid=
and sub.id=price.subcategoryid
and manu.id=price.manufacturerid
group by sub.id,manu.id
order by sub.order_sort desc,sub.id,
manu.level desc,manu.id,
price.level,price.productid | | |
