|
All Categories and Products |
 |
|
 |
Categories and Sub-Subcategories |
Products |
Error reported on page /all_prodcats.php
MySQL error: 0 -
SELECT
p.products_id,
pd.products_name,
pc.categories_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,
products_to_categories pc
WHERE
p.products_id = pd.products_id AND
p.products_id = pc.products_id AND
p.products_status = 1
AND (SELECT COUNT(*) FROM products_display_limit_country
where products_id= p.products_id AND countries_id='' AND limited_status='1') ='0'
AND
p.products_group_access like '%G%' AND
pd.language_id = '9'
ORDER BY pc.categories_id, pd.products_name
[TEP STOP] | | | | | | |