select b.brand_id, b.brand_name, b.brand_logo, b.created_dt, (select count(*) from event_menu_map where event_id=101 and brand_id=b.brand_id) as item_count from brand b left join event_vendor_map ev on ev.brand_id=b.brand_id where ev.event_id=101