Skip to content

Instantly share code, notes, and snippets.

@dontfreakout

dontfreakout/category_list.sql

Created August 5, 2013 10:31
Show Gist options
  • Save dontfreakout/6154952 to your computer and use it in GitHub Desktop.
Save dontfreakout/6154952 to your computer and use it in GitHub Desktop.
Download ZIP
Vybere názvy a ID všech tiskáren dané značky (použitelné pro generování URL kategorie: http://drukowanietanio.pl/?option=com_virtuemart&page=shop.browse&category_id=3021)
Raw
category_list.sql
SELECT x3.`category_child_id`, cat.category_name
FROM jos_pl_vm_category cat
LEFT JOIN `jos_pl_vm_category_xref` x3 ON x3.`category_child_id` = cat.category_id
LEFT JOIN `jos_pl_vm_category_xref` x2 ON x3.`category_parent_id` = x2.`category_child_id`
WHERE x2.`category_parent_id` = 3019 #HP
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment