SELECT categories_id FROM categories_description_en WHERE url = 'red-flowers-flower' LIMIT 1