 |
|
shop by categories
|
|
Manufacturers
|
|
|
|
| | |
1054 - Unknown column 'p.manufacturers_id' in 'on clause'
SELECT f.manufacturers_id,manufacturers_name,manufacturers_image,count(*) as aantal_artikelen FROM products p,products_to_categories c LEFT JOIN manufacturers f ON p.manufacturers_id=f.manufacturers_id WHERE p.products_id=c.products_id AND c.categories_id='52' AND products_status='1' GROUP BY p.manufacturers_id
[TEP STOP]
| |
