|
|
| dbProcess called from: | /Modules/pics/pic.asp |
| Executing: | pic.asp: Get Category/SubCategory. |
| SQL String: | SELECT *, (SELECT COUNT(*) FROM PIC_SUBCATEGORIES WHERE PIC_SUBCATEGORIES.CAT_ID=PIC_CATEGORIES.CAT_ID) AS SUB_COUNT, (SELECT COUNT(*) FROM PIC WHERE PIC.PARENT_ID=PIC_CATEGORIES.CAT_ID and PIC.SHOW=1) AS PIC_COUNT FROM PIC_CATEGORIES WHERE PIC_CATEGORIES.CAT_OWNER='0' ORDER BY CAT_ORDER DESC, CAT_NAME |
| # of @Parms passed | 0 |
| # of Records matched | 2 |
| dbProcess: END debug | |
