|
 |
 |
|
|
 |
|
|
|
|
|
|
|
|
 |
|
 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Handley House is proud to present the most comprehensive 1" scale (also known as 1/12th scale where 1"=1') miniatures catalog available on the world wide web. To ease your viewing, our products have been organized by manufacturer and category.
|
|
|
|
|
|
Browse By Category:
|
SELECT DISTINCT Categories.Category_ID, Categories.OrderByString, Categories.CategoryTitle, Categories.CategoryPageOptions
FROM Companies INNER JOIN ((Categories INNER JOIN ObjectGroups ON Categories.Category_ID = ObjectGroups.Category_ID)
INNER JOIN Products ON ObjectGroups.ObjectGroup_ID = Products.ObjectGroup_ID) ON Companies.Company_ID = Categories.Company_ID
WHERE (((ObjectGroups.Active)=1) AND ((Products.Active)=1) AND ((Companies.Company_ID)=#CID#))
ORDER BY Categories.CategoryTitle
Select * from objectgroups where active = 1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SELECT DISTINCT Categories.Category_ID, Categories.OrderByString, Categories.CategoryTitle, Categories.CategoryPageOptions
FROM Companies INNER JOIN ((Categories INNER JOIN ObjectGroups ON Categories.Category_ID = ObjectGroups.Category_ID)
INNER JOIN Products ON ObjectGroups.ObjectGroup_ID = Products.ObjectGroup_ID) ON Companies.Company_ID = Categories.Company_ID
WHERE (((ObjectGroups.Active)=1) AND ((Products.Active)=1) AND ((Companies.Company_ID)=1))
ORDER BY Categories.CategoryTitle
SELECT C.CategoryTitle, C.CategoryDescription, C.CategoryIcon,
C.CategoryIconParams, C.OrderByString, O.Category_ID, O.ObjectGroup_ID, C.CategoryImgStub
FROM Categories C, ObjectGroups O
WHERE O.Active = 1 AND C.Category_ID = O.Category_ID AND C.Category_ID IN (#Valuelist(GetCategories.Category_ID)#)
GROUP BY O.Category_ID, C.OrderByString, C.CategoryTitle, C.CategoryDescription,
C.CategoryIcon, C.CategoryIconParams, O.ObjectGroup_ID, C.CategoryImgStub
ORDER BY C.CategoryTitle
|
|
|
|
|
|
|
|
|
What's New at HandleyHouse.com
|
|
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
|
|
|
 |
|
|
|
|
REQUEST A CATALOG
click here to receive a copy of our new 650 page color catalog
|
|
|
|
|
|
|
|
|
|
REQUEST A CATALOG
click here to find out how to receive our new 650 page catalog.
|
|
|
|
|
All prices listed are suggested retail
in US Dollars. If you would like to convert our prices into another
currency please use this link to the
Personal Currency Assistant™
|
|
|
|
|
|
|
|
|
