Untitled query #21198

SQL

USE bswiki_p;
SELECT DISTINCT i.img_width*i.img_height as size, CONCAT("Datoteka:",i.img_name) as name FROM image i
INNER JOIN page p ON p.page_title = i.img_name AND p.page_namespace = 6
INNER JOIN categorylinks c1 ON c1.cl_from = p.page_id AND c1.cl_to = 'Slike' 
LEFT JOIN categorylinks c2 ON c2.cl_from = p.page_id AND c2.cl_to LIKE ('Sportski_logoi')
LEFT JOIN categorylinks c3 ON c3.cl_from = p.page_id AND c3.cl_to IN ('Screenshot_filma',
                                                                      'Screenshot_softvera')
WHERE i.img_width * i.img_height > 1e+6
AND c2.cl_to is NULL
AND c3.cl_to is NULL
SQL

Checking query status...
