CREATE TEMPORARY TABLE _product_filters_products_1 (PRIMARY KEY product_id (product_id)) ENGINE = MEMORY IGNORE SELECT products.product_id FROM cscart_products AS products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'de'  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  WHERE 1=1  AND pos_availabilty IN ('S', 'N')  AND cscart_categories.category_id IN (59, 110, 111, 112, 113, 114, 115, 116, 117, 118, 158, 222, 225, 254, 274, 296, 297, 341, 368, 414, 456, 496, 498, 563, 610, 633, 643) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status = 'A' ORDER BY NULL