Kako napisat SQL query?

id|base_url_id|order_int|
--+-----------+---------+

 0|          0|        2|
 1|          0|        0|
 2|          0|        1|
 3|          0|        0|

 4|          1|        1|
 5|          1|        1|
 6|          1|        0|
 7|          1|        2|

 8|          2|        1|
 9|          2|        2|

SELECT a.`id`, a.`base_url_id`, a.`order_int`
FROM (
	SELECT `base_url_id`, MIN(`order_int`)
	FROM `page_url`
	GROUP BY `base_url_id`
) AS b INNER JOIN `page_url` AS a ON a.`base_url_id` = b.`base_url_id` AND a.`order_int` = b.`order_int`
GROUP BY `base_url_id`
ORDER BY `id` ASC;

SELECT id, base_url_id, MIN(order_int) AS min_order_int
FROM page_url
GROUP BY base_url_id

WITH page_ranked as
(
SELECT id, order_int, base_url_id, 
	ROW_NUMBER() OVER (PARTITION BY order_int ORDER BY base_url_id) as nth
FROM page_url
)

SELECT * 
FROM page_ranked
WHERE nth=1
ORDER BY id

WITH pr AS
(
SELECT id, group_id, datetime_updated, name, status, 
	ROW_NUMBER() OVER (PARTITION BY group_id ORDER BY status, datetime_updated) as nth 
FROM page
WHERE status IN (0, 1)
)
SELECT * 
FROM pr
WHERE nth=1

id|name            |
--+----------------+
 0|juha brokoli bio|
 1|brokoli bio juha|
 2|bio juha brokolo|

SELECT `id`, `name`, MATCH(`name`) AGAINST('bio' IN BOOLEAN MODE) AS 'relevance'
FROM `temp`
WHERE MATCH(`name`) AGAINST('bio' IN NATURAL LANGUAGE MODE)
ORDER BY MATCH(`name`) AGAINST('bio' IN NATURAL LANGUAGE MODE) DESC;

id|name            |relevance         |
--+----------------+------------------+
 0|juha brokoli bio|0.0000000018859283|
 1|brokoli bio juha|0.0000000018859283|
 2|bio juha brokolo|0.0000000018859283|

SELECT `id`, `name`, LOCATE('bio', `name`) AS 'locate'
FROM `temp`
WHERE `name` LIKE CONCAT('%', 'bio', '%')
ORDER BY LOCATE('bio', `name`) ASC;

id|name            |locate|
--+----------------+------+
 2|bio juha brokolo|     1|
 1|brokoli bio juha|     9|
 0|juha brokoli bio|    14|