Utilisateur:L.strappazon/test
(suite)
- 224
A
- Agriculture and farming practices (COUNT( pageName): 17)
- Art of living - Gastronomy (COUNT( pageName): 7)
- Athletics (COUNT( pageName): 4)
B
- Basket (COUNT( pageName): 6)
- Body and Health (COUNT( pageName): 37)
- Borders (COUNT( pageName): 23)
C
- Carnival (COUNT( pageName): 28)
- Christmas (COUNT( pageName): 15)
- Conscripts (COUNT( pageName): 8)
- Cross-border tourism (COUNT( pageName): 32)
- Cycling (COUNT( pageName): 4)
E
- Easter (COUNT( pageName): 5)
- Eating and feasting (COUNT( pageName): 6)
- Ecology (COUNT( pageName): 13)
- Environment (COUNT( pageName): 30)
- European construction (COUNT( pageName): 5)
F
- First Wolrd War (COUNT( pageName): 20)
G
- Gymnastic (COUNT( pageName): 8)
H
- Health (COUNT( pageName): 2)
- Heritage and tourism sites (COUNT( pageName): 73)
- Hunting and Fishing (COUNT( pageName): 8)
- Hygiene and nutrition (COUNT( pageName): 2)
I
- Identity (COUNT( pageName): 65)
- Industrial and cultural heritage (COUNT( pageName): 13)
- Industry (COUNT( pageName): 36)
- Institutions and personnalities (COUNT( pageName): 3)
L
- Local festivals (COUNT( pageName): 52)
M
- Medicine (COUNT( pageName): 1)
N
- National day (COUNT( pageName): 4)
- Natural and transformed landscape (COUNT( pageName): 42)
- Nudism (COUNT( pageName): 3)
O
- Other wars : First Indochina war – Algerian war (COUNT( pageName): 8)
- Outdoor activities (COUNT( pageName): 62)
P
- Places (COUNT( pageName): 19)
R
- Religious feasts and events (COUNT( pageName): 23)
- Rural life (COUNT( pageName): 34)
S
- Second World War : ceremonies – commemorations - remembrance places (COUNT( pageName): 10)
S (suite)
- Second World War : German occupation - Annexation of Alsace (COUNT( pageName): 28)
- Second World War : Liberation (COUNT( pageName): 4)
- Second World War : post-war period (COUNT( pageName): 15)
- Second World War : prewar (COUNT( pageName): 38)
- Soccer (COUNT( pageName): 9)
- Sport (COUNT( pageName): 48)
- Strasbourg, european capital (COUNT( pageName): 6)
- Swimming (COUNT( pageName): 22)
T
- Tennis (COUNT( pageName): 1)
- The Rhine, cross-border symbol (COUNT( pageName): 16)
- Thermalism (COUNT( pageName): 4)
- Traditionnal dress (COUNT( pageName): 21)
- Traditions (COUNT( pageName): 85)
- Transit (COUNT( pageName): 5)
V
- Volleyball (COUNT( pageName): 1)
W
- War (COUNT( pageName): 29)
- Wedding (COUNT( pageName): 11)
- Winter sport (COUNT( pageName): 15)
Y
- Youth movements - Education - Scouting (COUNT( pageName): 18)
2
- 20e anniversaire de la libération de Strasbourg (0141FH0002) (COUNT( pageName): 3)
A
- Algérie 57 (0035FH0012) (COUNT( pageName): 3)
- Allemagne 1945 (0116FN0008) (COUNT( pageName): 1)
- Alsaciens évacués (0005FH0011) (COUNT( pageName): 1)
- Aménagement fluvial (0036FN0013) (COUNT( pageName): 1)
- Aufmarsch SA Besuch Göring Freiburg (COUNT( pageName): 1)
- Ausflug Braunau Angeln (COUNT( pageName): 1)
- Ausflug Elsass (COUNT( pageName): 1)
B
- Bas:3jours en Forêt Noire (0083FI0002) (COUNT( pageName): 1)
- Bas:Crime et châtiment (0116FN0005) (COUNT( pageName): 1)
- Bas:Défilé à Saverne (0052FN0014) (COUNT( pageName): 1)
- Bas:Défilé du 14 juillet 1928 à Strasbourg (0116FN0001 1) (COUNT( pageName): 3)
- Bas:Défilé du 14 juillet 1947 (0141FH0001) (COUNT( pageName): 1)
- Bas:Destructions à Ostheim et à Waldbach (0011FS0001 1) (COUNT( pageName): 1)
- Bas:Les asperges de Hoerdt (0119FH0002) (COUNT( pageName): 1)
- Bas:Mistrals à Telergma (0003FH0009) (COUNT( pageName): 1)
- Bas:Neubau Hauptstraße (LFS03572) (COUNT( pageName): 1)
- Bas:Par une belle journée en Forêt Noire (0033FN0004) (COUNT( pageName): 1)
- Bas:Pont de l'Europe, Kehl, Baden Baden (0021FN0005) (COUNT( pageName): 1)
- Bas:Rencontre franco-allemande Pentecôte 1975(0083FI0011) (COUNT( pageName): 1)
- Bas:Rhin Lauterbourg (0011FS0010) (COUNT( pageName): 3)
- Bas:Scènes de liesse à Alger (0130FH0004) (COUNT( pageName): 1)
- Bas:Voyage dans un autre univers : Saverne - Arzviller (0110FI0018) (COUNT( pageName): 1)
- Boykott jüdischer Geschäfte (LFS00472 3) (COUNT( pageName): 1)
- Bruchsal Abtransport JudenTITEL (LFS 00462 1) (COUNT( pageName): 1)
- Bruchsal Bombenschaeden (COUNT( pageName): 1)
- Bruchsal Feuerwehruebung (COUNT( pageName): 1)
- Bruchsal NS-Ansprache (COUNT( pageName): 3)
- Bruchsal NS-Aufmarsch (COUNT( pageName): 1)
- Bruchsal NS-Kreistag (COUNT( pageName): 1)
C
- Centre de ravitaillement en Lorraine (0021FN0002) (COUNT( pageName): 1)
- Conseil de l'Europe (0005FI0015) (COUNT( pageName): 1)
- Conseil de l'Europe -2 (0005FI0066) (COUNT( pageName): 1)
- Cordiers pendant la guerre (0005FH0023 8) (COUNT( pageName): 1)
C (suite)
- Croisière dans le Port du Rhin avec Batorama (0113FH0034) (COUNT( pageName): 1)
D
- D'une ville à l'autre (0068FN0012) (COUNT( pageName): 1)
- Dans l'armée (0003FH0010) (COUNT( pageName): 1)
- Défilé militaire à Griesheim (0093FH0003) (COUNT( pageName): 1)
- Défilé nazi place Kléber et boulevard Wilson Strasbourg (0021FN0002) (COUNT( pageName): 1)
- De Gaulle en Algérie (0003FH0009) (COUNT( pageName): 1)
- Deutsche Heimkehrer LFS000236 1) (COUNT( pageName): 1)
- Drôle de guerre à Bénestroff (0021FN0002) (COUNT( pageName): 1)
- Du Vieil-Armand au Grand Ballon (0020FH0003) (COUNT( pageName): 1)
E
- Entraînement de soldats (0035FH0002) (COUNT( pageName): 1)
- Europa unsere Zukunft (LFS02288) (COUNT( pageName): 1)
- Europa-park (0132FI0034) (COUNT( pageName): 1)
F
- Fahnenstafette (LFS 01421 7) (COUNT( pageName): 1)
- Familie Fasnet Umzug Freiburg (COUNT( pageName): 1)
- Familie Kriegsweihnacht (COUNT( pageName): 1)
- Familienaufnahmen (COUNT( pageName): 1)
- Fasnachstumzug (LFS00246) (COUNT( pageName): 1)
- Fête hitlérienne à Gengenbach (0026FN0013) (COUNT( pageName): 3)
- Foire exposition au Wacken (0021FN0001) (COUNT( pageName): 1)
- Foire exposition au Wacken E (0021FN0002) (COUNT( pageName): 3)
- Frankreichfeldzug (LFS07498) (COUNT( pageName): 1)
G
- Großer Umzug (LFS 02297 3) (COUNT( pageName): 1)
H
- Hartmannsweilerkopf Dornier (COUNT( pageName): 1)
- Hatten - Rittershoffen - Soldats allemands (0011FS0003) (COUNT( pageName): 1)
I
- Inauguration du mémorial du Struthof par De Gaulle (0005FH0006) (COUNT( pageName): 1)
- Inauguration du monument aux morts à Strasbourg (0005FS0011—7) (COUNT( pageName): 1)
- Informationsfahrt Gemeinderat (LFS04008) (COUNT( pageName): 1)
J
- Jeunesses hitlériennes (0021FN0003) (COUNT( pageName): 3)
K
- Kati's Schulfim (COUNT( pageName): 1)
- Kurzlebige Wirtschaftsgüter (LFS01007) (COUNT( pageName): 1)
L
- La Légion étrangère à Touggourt (0003FH0009) (COUNT( pageName): 1)
- La nécropole du Vieil Armand (0026FN0007) (COUNT( pageName): 3)
- La revue du 14 juillet 1935 (0126FN0002) (COUNT( pageName): 1)
- Lager Reichsarbeitsdienst Fällen Blutbuche (LFS00248 1) (COUNT( pageName): 1)
L (suite)
- Le 11 Novembre 1932 à Strasbourg (0052FN0014) (COUNT( pageName): 1)
- Le Linge en 1948 (0033FN0003) (COUNT( pageName): 1)
- Le Président Lebrun à Colmar (0034FS0021) (COUNT( pageName): 3)
- Le Rhin(0019FH0046) (COUNT( pageName): 1)
- Leclerc à Strasbourg (0005FH0006) (COUNT( pageName): 1)
- Leichtathletik-Länderkampf Baden-Elsass (LFS00244) (COUNT( pageName): 1)
- Les 10 ans de la Libération de Colmar (0047FN0001) (COUNT( pageName): 1)
- Libération de Marlenheim (0019FH0008) (COUNT( pageName): 1)
- Libération et Fin de l'occupation à Colmar (0024FS0002) (COUNT( pageName): 1)
M
- Manöverball 75er Jäger (LFS00248 2) (COUNT( pageName): 3)
- Maxau (LFS03225) (COUNT( pageName): 1)
O
- Ostern, Silberhochzeit (COUNT( pageName): 1)
P
- Panzer Freiburger Wierebahnhof (LFS06317) (COUNT( pageName): 1)
- Passage du Rhin à Vogelgrun (0075FH0018) (COUNT( pageName): 1)
- Pontonbrücke und neue Rheinbrücke bei Maxau (LFS03225) (COUNT( pageName): 3)
- Procès des dirigeants autonomistes à Colmar (0026FN0001) (COUNT( pageName): 1)
- Procès du Gauleiter Wagner (0011FS0018) (COUNT( pageName): 1)
Q
- Querschnitt durch Basel (Lichtspiel 386176) (COUNT( pageName): 1)
R
- Régiment dragon à Erstroff (0021FN0002) (COUNT( pageName): 1)
- Reise Bodensee und Schweiz (COUNT( pageName): 1)
- Reise in Berge (COUNT( pageName): 1)
- Reise Lago Maggiore (COUNT( pageName): 3)
- Reise Schweiz Mosel Rhein (COUNT( pageName): 1)
- Reiterfest in Kürzell (LFS00248 3) (COUNT( pageName): 3)
S
- S.A. Fahnenhiss (0035FH0007) (COUNT( pageName): 1)
- Saint Dié 1945 (0116FN0008) (COUNT( pageName): 1)
- Segelflug Dinglingen (LFS00221) (COUNT( pageName): 1)
- Serment des NSKK au Korpsführer Hühnlein à Strasbourg (0024FS0002) (COUNT( pageName): 3)
- Strasbourg (0021FN0002) (COUNT( pageName): 1)
- Strasbourg évacuée (0005FH0011) (COUNT( pageName): 3)
T
- Tagung BDA, Fahrt Frankreich (COUNT( pageName): 1)
- Tirailleurs marocains (0047FN0001) (COUNT( pageName): 1)
Query: SELECT `_pageName` AS `_pageName`,sum(count(*)) FROM `A_cargo__Sequences` WHERE `A_cargo__Sequences`.`_ID` IN ( SELECT DISTINCT( _rowID ) FROM `A_cargo__Sequences__thematique` WHERE _value IN ( SELECT _value FROM `A_cargo__Sequences__thematique__hierarchy` WHERE _left >= ( SELECT _left FROM `A_cargo__Sequences__thematique__hierarchy` WHERE _value = 'Identity' ) AND _right <= ( SELECT _right FROM `A_cargo__Sequences__thematique__hierarchy` WHERE _value = 'Identity' ) ) ) GROUP BY `_pageName` ORDER BY count(*) desc LIMIT 10 Function: CargoSQLQuery::run Error: 1111 Invalid use of group function (bdd10.u-strasbg.fr)
Identité
Seconde Guerre mondiale : après-guerre Seconde Guerre mondiale : cérémonies - commémorations - lieux de mémoire