Skip to content

Instantly share code, notes, and snippets.

View dontfreakout's full-sized avatar

Martin Vlcek dontfreakout

6 followers · 6 following
View GitHub Profile
@dontfreakout
dontfreakout / category_list.sql
Created August 5, 2013 10:31
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)
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