|
|
|
SELECT dbo.cats.catname, dbo.subcats.subcatname, dbo.items.itemid, dbo.items.itemname
FROM dbo.subcats, dbo.items, dbo.itemassoc, dbo.cats
WHERE dbo.subcats.subcatid = dbo.itemassoc.subcatid AND
dbo.itemassoc.itemid = dbo.items.itemid and
dbo.cats.catid = dbo.subcats.catid and
dbo.subcats.catid = #url.id#
order by dbo.subcats.subcatname, dbo.items.itemname
#getitems.catname# |
|
|
