SELECT categories_description.categories_id AS id, categories_description.categories_name AS name, categories_description.categories_desc AS description, categories_description.categories_url AS slug, categories.categories_image FROM categories_description LEFT JOIN categories ON categories.categories_id = categories_description.categories_id WHERE categories_description.categories_url IN ("floral","birthday-flowers") ORDER BY FIELD(categories_description.categories_url, "floral","birthday-flowers")