Spirit

select * from products where active=1 and ( (FIND_IN_SET('21', parent_cat_id)) or FIND_IN_SET('21', cat_id) or (FIND_IN_SET('113', parent_cat_id)) or FIND_IN_SET('113', cat_id) or (FIND_IN_SET('114', parent_cat_id)) or FIND_IN_SET('114', cat_id) or (FIND_IN_SET('115', parent_cat_id)) or FIND_IN_SET('115', cat_id) or (FIND_IN_SET('116', parent_cat_id)) or FIND_IN_SET('116', cat_id) or (FIND_IN_SET('47', parent_cat_id)) or FIND_IN_SET('47', cat_id) or (FIND_IN_SET('23', parent_cat_id)) or FIND_IN_SET('23', cat_id) or (FIND_IN_SET('112', parent_cat_id)) or FIND_IN_SET('112', cat_id) or (FIND_IN_SET('61', parent_cat_id)) or FIND_IN_SET('61', cat_id) or (FIND_IN_SET('110', parent_cat_id)) or FIND_IN_SET('110', cat_id) or (FIND_IN_SET('89', parent_cat_id)) or FIND_IN_SET('89', cat_id) or (FIND_IN_SET('88', parent_cat_id)) or FIND_IN_SET('88', cat_id) or (FIND_IN_SET('109', parent_cat_id)) or FIND_IN_SET('109', cat_id) or (FIND_IN_SET('90', parent_cat_id)) or FIND_IN_SET('90', cat_id) or (FIND_IN_SET('91', parent_cat_id)) or FIND_IN_SET('91', cat_id) or (FIND_IN_SET('92', parent_cat_id)) or FIND_IN_SET('92', cat_id) or (FIND_IN_SET('93', parent_cat_id)) or FIND_IN_SET('93', cat_id) or (FIND_IN_SET('94', parent_cat_id)) or FIND_IN_SET('94', cat_id) or (FIND_IN_SET('95', parent_cat_id)) or FIND_IN_SET('95', cat_id) or (FIND_IN_SET('96', parent_cat_id)) or FIND_IN_SET('96', cat_id) or (FIND_IN_SET('97', parent_cat_id)) or FIND_IN_SET('97', cat_id) or (FIND_IN_SET('98', parent_cat_id)) or FIND_IN_SET('98', cat_id) or (FIND_IN_SET('99', parent_cat_id)) or FIND_IN_SET('99', cat_id) or (FIND_IN_SET('100', parent_cat_id)) or FIND_IN_SET('100', cat_id) or (FIND_IN_SET('105', parent_cat_id)) or FIND_IN_SET('105', cat_id) or (FIND_IN_SET('106', parent_cat_id)) or FIND_IN_SET('106', cat_id) or (FIND_IN_SET('107', parent_cat_id)) or FIND_IN_SET('107', cat_id) or (FIND_IN_SET('108', parent_cat_id)) or FIND_IN_SET('108', cat_id) or (FIND_IN_SET('119', parent_cat_id)) or FIND_IN_SET('119', cat_id) or (FIND_IN_SET('122', parent_cat_id)) or FIND_IN_SET('122', cat_id) or (FIND_IN_SET('144', parent_cat_id)) or FIND_IN_SET('144', cat_id) or (FIND_IN_SET('145', parent_cat_id)) or FIND_IN_SET('145', cat_id) or (FIND_IN_SET('151', parent_cat_id)) or FIND_IN_SET('151', cat_id) ) order by product_id desc limit 0, 25