gistfile1.sql

SELECT 
	`media`.`id`  
FROM 
	`media` 
WHERE 
	( 
		`published` = '1' AND 
		`waitingForModeration` = '0'
	) AND (
			`media`.`id` IN (
				SELECT 
					`itemId` 
				FROM 
					`cmcCMS`.`tagItems` 
				WHERE 
					`tagId` IN (118,4) 
				GROUP BY itemId 
					HAVING (COUNT(tagId) = 2)
			)
	) AND (
		`media`.`id` NOT IN (
			SELECT 
				`itemId` 
			FROM 
				`cmcCMS`.`tagItems` 
			WHERE 
				`tagId` IN (122,452,612)
		)
	)
ORDER BY 
	`media`.`postedOn` DESC