• link 개수 20개 이상이 pik 아이디 추출

SELECT pik_id
FROM (
	SELECT piks_category.pik_id, linkhub_link.url, linkhub_link.id AS link_id
	FROM linkhub_link, piks_category
	WHERE linkhub_link.category_id = piks_category.id AND linkhub_link.is_deleted = False
) AS a
GROUP BY pik_id
HAVING COUNT(link_id) >= 20

• pik의 정보 모음

SELECT
	pik.id AS pik_id,
	pik.title AS pik_title,
	category_link.category_title,
	category_link.link_title,
	category_link.link_description,
	category_link.memo,
	category_link.platform,
		pik.language
FROM piks_pik AS pik INNER JOIN 
(
	SELECT 
		category.pik_id as pik_id, 
		category.id AS category_id, 
		category.title AS category_title, 
		link.title AS link_title, 
		link.description AS link_description,
		link.platform AS platform,
		link.memo AS memo
	FROM 
	(
		linkhub_link AS link INNER JOIN 
		piks_category AS category ON link.category_id = category.id
	)
	WHERE 
		link.is_deleted = FALSE AND 
		category.is_deleted = FALSE AND
		link.user_id <> 1337
) AS category_link ON pik.id = category_link.pik_id
WHERE pik.is_deleted = FALSE AND pik.is_onboard = FALSE