- $result = $DB->query("SELECT count(*) as total from (SELECT p.id FROM photo_tags pt, photos p, tags t".
- " WHERE pt.tag_id = t.id".
- " AND (t.name COLLATE NOCASE IN ($tags))".
- " AND p.id = pt.photo_id ".
- " GROUP BY p.id HAVING COUNT( p.id )=$nrtags)");
+ $DB->query("CREATE TEMP TABLE TEMPPICS AS SELECT p.id as id FROM photo_tags pt, photos p, tags t".
+ " WHERE pt.tag_id = t.id".
+ " AND (t.name COLLATE NOCASE IN ($tags))".
+ " AND p.id = pt.photo_id ".
+ " GROUP BY p.id HAVING COUNT( p.id )=$nrtags");
+
+ if (isset($_REQUEST["ID"]))
+ {
+ $ID = $_REQUEST["ID"];
+ $result = $DB->query("SELECT count(*) as total, (SELECT rowid from TEMPPICS WHERE id = $ID) as row from TEMPPICS");
+ }
+ else
+ $result = $DB->query("SELECT count(*) as total, -1 as row from TEMPPICS");