Skip to content

Instantly share code, notes, and snippets.

@aj-justo

aj-justo/ZenCart_SQL_Get_cats_with_products

Created May 27, 2011 10:23
Show Gist options
  • Save aj-justo/995001 to your computer and use it in GitHub Desktop.
Save aj-justo/995001 to your computer and use it in GitHub Desktop.
Download ZIP
Zen Cart SQL: Get all categories with products on them
Raw
ZenCart_SQL_Get_cats_with_products
select * from categories_description where language_id=1 and ( categories_id in (select categories_id from products_to_categories) or categories_id in (select parent_id from categories) )
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment