tempMediaQuery

CREATE TEMPORARY TABLE mediaSelected ( 
	mediaId int,
	itemId int
);

CREATE TEMPORARY TABLE mediaRejected ( 
	mediaID int,
	itemID int
);


insert into mediaSelected
SELECT 
	`mediaId`,
	`itemId` 
FROM 
	`cmcCMS`.`tagItems` 
WHERE 
	`tagId` IN (118,4) 
GROUP BY itemId 
	HAVING (COUNT(tagId) = 2);
	
	
insert into mediaRejected
SELECT 
    `mediaId`,
    `itemId` 
FROM 
	`cmcCMS`.`tagItems` 
WHERE 
	`tagId` IN (122,452,612);
	
SELECT 
	`media`.`id`  
FROM 
	`media` 
left join mediaSelected
    on mediaSelected.mediaId = media.id
left outer join mediaRejected
    on mediaRejected.mediaId = media.id
ORDER BY 
	`media`.`postedOn` DESC