SQLize Online / PHPize Online  /  SQLtest Online

SELECT f.film_id, f.title, c.category_name AS category FROM film f INNER JOIN film_category fc USING(film_id) INNER JOIN category c USING(category_id) WHERE c.category_name = 'Comedy' UNION SELECT f.film_id, f.title, c.category_name AS category FROM film f INNER JOIN film_category fc USING(film_id) INNER JOIN category c USING(category_id) WHERE c.category_name = 'Music' UNION SELECT f.film_id, f.title, c.category_name AS category FROM film f INNER JOIN film_category fc USING(film_id) INNER JOIN category c USING(category_id) WHERE c.category_name = 'Travel' ORDER BY film_id; ; show status like 'Last_query_cost';