SHUTDOWN is in progress.

SELECT (SELECT COUNT(menSub.k_id) from d_menuItem menSub WHERE menSub.l_parentID = d_menuItem.k_id) as subCnt, d_menuItem.k_id, d_menuItem.l_menuCategory, d_menuItem.l_levelID, d_menuItem.tx_menuItem, d_menuItem.tx_altText,d_menuItem.tx_imageName, d_menuItem.l_width, d_menuItem.l_height, d_menuItem.tx_url, d_menuItem.l_pageID, d_menuItem.yn_loggedOnOnly, d_menuItem.yn_loggedOffOnly, d_menuItem.yn_image, d_menuItem.yn_newWindow, d_menuItem.yn_getSubPages FROM d_menuItem WHERE (d_menuItem.yn_loggedOnOnly = 0) AND d_menuItem.yn_activated = 1 AND d_menuItem.l_parentID = 766 ORDER BY d_menuItem.b_order