Samlingsportalen: Söka efter bilder i en specifik samling och i nummerordning (JvmV informerar)

av Rolf Sten ⌂, Sunday, April 05, 2015, 22:32 (3683 dagar sedan) @ Thomas Tell

Hur söker man en bildserie? Nummerföljd.
/tell

Gå in på ’Avancerad sökning’
Fältet bildnummer: skriv in: jvm,bokstavskombination för önskad bildserie, avsluta med *. T ex jvm,KBDA*
Fortsätt till vänster om ’Sökknappen’ välj önskad sorteringsordning. I det här fallet ’Bildlista efter bildnummer’
Klicka därefter på ’Sök’

Hela tråden:

 

Time: 263
SELECT COUNT(*) FROM mlf2_entries LEFT JOIN mlf2_akismet_rating ON mlf2_akismet_rating.eid = mlf2_entries.id LEFT JOIN mlf2_b8_rating ON mlf2_b8_rating.eid = mlf2_entries.id WHERE pid = 0 AND (mlf2_akismet_rating.spam = 0 AND mlf2_b8_rating.spam = 0) AND category IN (0, 4, 5, 6, 7, 8, 9, 25, 14, 23, 19, 22, 24, 10, 21, 11, 12, 13, 15, 16, 26, 18, 20, 27)

Time: 1149
SELECT COUNT(*) FROM mlf2_entries LEFT JOIN mlf2_akismet_rating ON mlf2_akismet_rating.eid = mlf2_entries.id LEFT JOIN mlf2_b8_rating ON mlf2_b8_rating.eid = mlf2_entries.id WHERE (mlf2_akismet_rating.spam = 1 OR mlf2_b8_rating.spam = 1)
Time: 1309
SELECT COUNT(*) FROM mlf2_entries LEFT JOIN mlf2_akismet_rating ON mlf2_akismet_rating.eid = mlf2_entries.id LEFT JOIN mlf2_b8_rating ON mlf2_b8_rating.eid = mlf2_entries.id WHERE category IN (0, 4, 5, 6, 7, 8, 9, 25, 14, 23, 19, 22, 24, 10, 21, 11, 12, 13, 15, 16, 26, 18, 20, 27) AND (mlf2_akismet_rating.spam = 0 AND mlf2_b8_rating.spam = 0)

Total time: 2734

[x]
[*]