25% OFF - Use code: 25SAVE25% OFF EVERYTHING Use code: 25SAVE
SELECT `main_table`.* FROM `aw_zblocks` AS `main_table` WHERE (`block_position` = 'product-menu-top') 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('', `category_ids`)) OR (
`show_in_subcategories`=1
AND (find_in_set('2', `category_ids`) OR find_in_set('38', `category_ids`) OR find_in_set('194', `category_ids`) OR find_in_set('220', `category_ids`) OR find_in_set('298', `category_ids`) OR find_in_set('406', `category_ids`))))) ORDER BY block_sort_order ASC