SELECT `main_table`.* FROM `aw_zblocks` AS `main_table` WHERE (`block_position_custom` = 'header-global-zblock') AND (`block_is_active` = '1') AND (((FIND_IN_SET('0', `store_ids`)) OR (FIND_IN_SET('2', `store_ids`)))) AND (find_in_set(0, customer_group)) AND (((
`show_in_subcategories`=0
AND find_in_set('308', `category_ids`)) OR (
`show_in_subcategories`=1
AND (find_in_set('1', `category_ids`) OR find_in_set('2', `category_ids`) OR find_in_set('3', `category_ids`) OR find_in_set('308', `category_ids`)))) OR is_use_category_filter_custom = 0) ORDER BY block_sort_order ASC