Checking metabib.record_attr_flat

SELECT mraf2.attr, count(*)
FROM metabib.record_attr_flat mraf1,
     metabib.record_attr_flat mraf2
WHERE mraf2.id = mraf1.id
AND mraf1.attr = 'item_type'
AND mraf1.value = 'g'
AND mraf1.attr <> mraf2.attr
AND mraf2.attr <> 'search_format';