SELECT iam0.g_itemId, COUNT( iam1.g_itemId )
FROM g2_ItemAttributesMap AS iam0, g2_ItemAttributesMap AS iam1, g2_AccessSubscriberMap, g2_AccessMap
WHERE iam0.g_itemId
IN ( 183476, 182853, 838, 488, 181658, 181233 )
AND iam1.g_parentSequence LIKE CONCAT( iam0.g_parentSequence, iam0.g_itemId, '/%' )
AND iam1.g_itemId = g2_AccessSubscriberMap.g_itemId
AND g2_AccessSubscriberMap.g_accessListId = g2_AccessMap.g_accessListId
AND (
g2_AccessMap.g_userId =4
OR g2_AccessMap.g_groupId
IN ( 5 )
)
GROUP BY iam0.g_itemId
HAVING BIT_OR( g2_AccessMap.g_permission ) &1 =1
LIMIT 0 , 30