| dbProcess called from: | /modules/pics/pic_members.asp | | Executing: | pic_members.asp: Get count | | 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 | 0 | | dbProcess: END debug |
|