SELECT *
FROM table_categories 
JOIN table_files 
ON table_categories.file_id = table_files.file_id 

WHERE table_categories.unique_id IN ( 
	( SELECT i2t1.object_id 
		FROM table_tags t0 
		CROSS JOIN table_tags t1 
		CROSS JOIN table_tags t2 
		INNER JOIN table_tagged_objects i2t0 
		ON t0.id = i2t0.tag_id 
		INNER JOIN table_tagged_objects i2t1 
		ON i2t0.object_id = i2t1.object_id 
		AND i2t1.tag_id = t1.id 
		LEFT JOIN table_tagged_objects i2t2 
		ON i2t0.object_id = i2t2.object_id 
		AND i2t1.object_id = i2t2.object_id 
		AND i2t2.tag_id= t2.id WHERE t0.tag = 'fruit' 
		AND t1.tag = 'appl' 
		AND t2.tag = 'green' 
		AND i2t2.object_id IS NULL) 
	) 
		
AND table_categories.display_type='1' 
AND (table_categories.visible=1 OR table_categories.author_id='26') 
ORDER BY table_categories.title ASC 
LIMIT 0,24

SELECT table_tagged_objects.object_id 
  FROM table_tags 
INNER
  JOIN table_tagged_objects
    ON table_tagged_objects.tag_id = table_tags.id
 WHERE table_tags.tag IN ( 'fruit','apple','green' )
GROUP
    BY table_tagged_objects.object_id
HAVING COUNT(CASE WHEN table_tags.tag = 'fruit'
                  THEN 1 END ) > 0
   AND COUNT(CASE WHEN table_tags.tag = 'apple'
                  THEN 1 END ) > 0
   AND COUNT(CASE WHEN table_tags.tag = 'green'
                  THEN 1 END ) = 0