Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /customers/c/d/b/jvmv2.se/httpd.www/daniel/forum/includes/entry.inc.php on line 252 Warning: Cannot modify header information - headers already sent by (output started at /customers/c/d/b/jvmv2.se/httpd.www/daniel/forum/includes/entry.inc.php:252) in /customers/c/d/b/jvmv2.se/httpd.www/daniel/forum/index.php on line 217 Warning: Cannot modify header information - headers already sent by (output started at /customers/c/d/b/jvmv2.se/httpd.www/daniel/forum/includes/entry.inc.php:252) in /customers/c/d/b/jvmv2.se/httpd.www/daniel/forum/index.php on line 218 Lokomotivmästare - mängden expeditioner - 2008 - 2023 års Järnvägshistoriska forum

Lokomotivmästare - mängden expeditioner (Järnvägspersonal)

av Göran Kannerby, Thursday, August 03, 2023, 10:08 (674 dagar sedan) @ mormorsgruvan

2. Hur många lokomotivmästarexpeditioner har det funnits vid SJ ?

Vänligen förtydliga, vill du veta hur många expeditioner som någon gång funnits? Eller är du istället intresserad av hur många det som mest fanns samtidigt?

Bäst vore naturligtvis en utförlig lista över samtliga som funnits och under vilka tidsperioder, men det är ju inte säkert att det går att få fram en sådan.

Hela tråden:

 

Time: 235
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: 1066
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: 1221
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: 2536

[x]
[*]