 |
Manufacturers |
 |
|
 |
Categories |
 |
|
 |
Articles |
 |
|
|
All Manufactures and Products |
 |
|
 |
Manufactures |
Products |
Error reported on page /all_prodmanf.php
MySQL error: 0 -
SELECT
p.products_id,
if (isnull(pg.customers_group_price), p.products_price, pg.customers_group_price) as final_price,
pd.products_name,
p.manufacturers_id
from (products p
left join products_groups pg on p.products_id = pg.products_id and pg.customers_group_id = 'G'),
products_description pd
WHERE
p.manufacturers_id = manufacturers_id AND
p.products_id = pd.products_id AND
p.products_status = 1 AND
pd.language_id = '1' AND
p.products_group_access like '%G%'
AND (SELECT COUNT(*) FROM products_display_limit_country
where products_id= p.products_id AND countries_id='' AND limited_status='1') ='0'
ORDER BY p.manufacturers_id, pd.products_name
[TEP STOP] | | | | | | |