View Listing
SELECT * FROM item, itemcategory WHERE itemcategory.category_recid= AND itemcategory.item_recid = item.recid AND display_name='BR1006'
SELECT * FROM item, itemcategory WHERE itemcategory.category_recid= AND itemcategory.item_recid = item.recid AND display_name='BR1006'