- my $main_sql_start=("SELECT DISTINCT tags.name FROM files\n" .
- "INNER JOIN files_x_tags ON files.id=files_x_tags.files_id\n" .
- "INNER JOIN tags ON tags.id=files_x_tags.tags_id\n" .
- "WHERE files.id in (" .
- ("\tSELECT DISTINCT files.id FROM files\n" .
- "\tINNER JOIN files_x_tags ON files.id=files_x_tags.files_id\n" .
- "\tINNER JOIN tags ON tags.id=files_x_tags.tags_id\n" .
- "\tWHERE tags.id in ("));
- my $main_sql_mid=")\n) AND tags.id NOT IN (";
- my $main_sql_end=")\n";
+ my $main_sql_start=("SELECT tags.name FROM files\n" .
+ " INNER JOIN files_x_tags fxt1 ON files.id=fxt1.files_id\n" .
+ " INNER JOIN files_x_tags fxt2 ON files.id=fxt2.files_id\n" .
+ " INNER JOIN tags ON tags.id=fxt2.tags_id\n" .
+ " WHERE fxt1.tags_id IN \n\t(");
+ my $main_sql_mid=")\n\tAND fxt2.tags_id NOT IN \n\t(";
+ my $main_sql_end=")\n GROUP BY fxt2.tags_id;";