Médiathèque

Trionfu di a Puesia 1986

En pause...
« »
  •  
    00:00:00 - Ballu di l'animali morti
  •  
    00:03:26 - Chjama e Rispondi
  •  
    00:07:15 - Ballu (seguita)
  •  
    00:09:23 - Chjama e Rispondi / Mimofunia
  •  
    00:13:16 - Cantu di l'Anime Sveglie
  •  
    00:20:12 - Chjama e rispondi
  •  
    00:27:40 - Ballu di l'equilibru
Durée totale du document :
Trionfu di a Puesia
Interprète(s) :
Marìa- Laura Emmanuelli, Ghjilormu Casalonga, Ghjuvan Petru Lanfranchi, Nicole Casalonga, Dumenica Bianconi, Gilberta Casabianca, Orlando Forioso, Roccu Mambrini, Matteu Salviani, Lisandrina Grimaldi.
Document N° :
CCV000008
Enregistrement
Lieu de l'enquête :
Pigna
Année :
1986
Date :
1986-06-15
Fiche N° :
39
Enquêteur(s) :
France 3 Corse/Mixage Studio Ricordu LMC49 RI 200
Informateur(s) :
A CUMPAGNIA, Roccu MANBRINI, Matteu SALVIANI, Michele RAFFAELLI, Orlando FORIOSO
Auteur :
Orlando FORIOSO, Lisandrina GRIMALDI, Santu MASSIANI, Ghjacumu THIERS
Personne morale :
Voce Cumune
Langue(s) :
Corse en majorité, quelques phrases en français et du gromelot italianisant
Commentaire sur la langue :

La plupart des participants pratique la variante balanine de langue corse.
Deux exceptions :
- l'acteur napolitain Orlando FORIOSO, qui a utilisé pour l'occasion un gromelot métissé de diverses influences.
- le poète Matteu SALVIANI, originaire du Boziu.


Résumé :

Entre 1975 et 1985, l'association VOCE CUMUNE a réalisé toute une série d'actions destinées à redynamiser la pratique du Chjama è Rispondi, la poésie improvisée chantée traditionnelle corse.
Des soirées, des rencontres, des ateliers ont été organisés, au cours desquels des enregistrements ont été réalisés, puis analysés. A l'issue de ces 10 ans de campagne, un ouvrage a été édité qui faisait le point sur ces recherches.
Mais il nous a semblé alors qu'une édition ne pouvait rendre compte de ce que nous avions découvert d'essentiel : que la liberté (d'improviser) est une longue préparation, et que l'improvisation nécessite autant de méthode que d'imagination. Et, enfin, que le hasard et les circonstances sont des atouts qu'il faut savoir jouer, et non pas déjouer.
C'est pour cela que pour rendre aux poètes ce qu'ils nous avaient donné, nous avons résolu d'utiliser leur enseignement pour en faire un spectacle en leur honneur, le « TRIONFU di a PUESIA », en tentant de mettre en œuvre dans tous les domaines (texte, scénographie, costumes, lumières, etc...) leur méthode de conduite des hasards.

NOTA sur l'extrapolation des pratiques de l'improvisation poétique dans le cadre de ce spectacle :

1) Canevas
Les acteurs disposaient de 4 canevas, créés par 4 auteurs différents. A chaque répétition, à chaque représentation, au moment d'entrer en scène, l'un d'entre eux était tiré au sort.

2) Personnages
- Chacun des acteurs avait son type défini : le jeune homme, la jeune fille (la muse), le vieux, la vieille, l'homme et la femme, et l' « étrange ».
- Un grand sac d'accessoires était posé dans les coulisses, et les acteurs en prenaient au moins trois à l'aveugle. Ils devaient avec cela préciser le caractère du personnage. Ainsi, le soir de l'enregistrement, l'« homme » avait tiré un casque et des lunettes de pilote, et une chambre à air. Comme toute la Corse parlait de l'amerrissage forcé d'un canadair qui avait coulé et dont le pilote s'était échappé sur un canot gonflable, Dumenica BIANCONI qui jouait ce rôle a décidé qu'elle serait le pilote du canadair. Les autres ont du s'y faire !

3) Textes
- Les poètes, bien sur, assis à une table avec une carafe de vin, inspirés par Lisandrina qui leur soufflait des informations sur la situation, assistaient au spectacle en silence. Mais quand la lumière posée sur leur table s'allumait, selon le bon vouloir de l'éclairagiste, ils se mettaient à improviser jusqu'à ce qu'elle s'éteigne.
- Les chanteurs tantôt reprenaient le dernier vers des poètes, tantôt une phrase que leur lançait le « jeune homme », qui provenait d'un texte en écriture automatique de Ghjacumu THIERS.

4) Polyphonie
Nando Acquaviva, par les signes de la mimophonie, indiquait aux chanteurs les harmonies à placer sur la voix qu'il improvisait.

5) Scène
- La vaccaghja, ancien enclos pour les bœufs de labour était nue, habitée seulement au centre par la copie d'un menhir phallique de Filitosa à demi écroulé.
- Le jeu des acteurs et des chanteurs, imprévu par nature, était en permanence repris, souligné, ou effacé par l'éclairagiste sur le jeu d'orgue manuel.
- Une loterie apparaissait à la fin : la table ronde des poètes se relevait, et puis elle se transformait au final en trône pour la muse.

6) Masques
-Dans la première scène, tous les participants prenaient au hasard un masque constitué par un véritable crane d'animal (bœuf, chèvre, bélier, etc...) fixé sur un support.

7) Musiques
Improvisées sur les grilles de la basse du Chjama è Rispondi.

TITRES ET DESCRIPTION DES OEUVRES
1/ BALLU DI L'ANIMALI MORTI (bal des animaux morts)
Instruments : Timbales en peau d'âne,
Orgue régale,
Violoncelle,
Cialamella (chalumeau à anche simple)
Tintenne (sonnailles de métal)
Sur le rythme de l'anapeste (deux brèves, une longue), décrit dans notre publication à la page 125 comme base rythmique du Chjama e Rispondi, les instruments jouent la ligne de basse qui sous-tend la mélodie traditionnelle la plus commune, jouée à la cialamella. (page 61 de la publication).

2/ CHJAMA E RISPONDI (joute poétique chantée improvisée)
-Accompagné sur la première strophe par un « currente » (contre-chant rapide), puis sans accompagnement.
-Les 2 poètes se lamentent sur la disparition du monde pastoral, des troupeaux, et sur les incendies pendant que les personnages aux masques d'animaux morts dansent en cercle.

3/ BALLU (seguita) (suite de la danse)
-Improvisation sur le thème de la mélodie traditionnelle du Chjama e Rispondi

4/ MIMOFUNIA (mimophonie)
-Le premier poète est accompagné par l'orgue régale et la timbale. Puis le chant se poursuit sans accompagnement. Les poètes regrettent la mort de la muse, disparue comme les bergers et les troupeaux.
-Les chanteurs reprennent le dernier vers des poètes et improvisent en mimophonie.
Le thème : la muse est-elle morte, ou est-elle seulement disparue ? Son amoureux la cherche, l'appelle, l'invoque, reprenant tous les adjectifs que les poètes lui donnent (et qui sont listés dans notre publication pages 85, 86 et 87).
-On entend alors des appels de bergers, qui cherchent eux aussi, la muse disparue.

5/ CANTU DI L'ANIME SVEGLIE (chant de l'éveil des âmes)
Sur la poésie de Ghjacumu THIERS, un dialogue s'établit entre l'acteur et les chanteurs qui tuilent les imperceptibles variations textuelles en improvisant des modulations mélodiques.

6/ CHJAMA E RISPONDI (poésie chantée improvisée)
Elle n'est pas morte, cherche-la. Elle n'est pas loin, et attends les bras ouverts. Mais non, je l'ai vue porter au cimetière. C'est trop triste, elle est autre part. Si il la cherche, il la trouvera. Qu'il demande aux bergers. Ne serait-elle pas dans nos verres ?

7/ CHJAMA E RISPONDI (poésie chantée improvisée)
On entend alors une suite d'accords sonnés par trois culombi (conques marines).
Thèmes : la confusion est à son comble : le pilote cherche son canadair à terre, la mère se prend pour la grand-mère, et l' « étrange » a envie de pisser !

8/ CANTU DI L'ARMUNIA (chant de l'harmonie)
Polyphonie improvisée en mimophonie à partir d'une roue de loterie qui comporte sur un rang des modes, sur un second des accords, et sur le troisième des phrases. C'est l' « étrange » qui la fait tourner et la bloque, donnant ainsi des indications à Nando qui se doit de faire avec.

9/ BALLU DI L'EQUILIBRIU (bal de l'équilibre)
-Sur le rythme de l'anapeste, mais plus rapide qu'au début, les instruments : cetera (cistre) pivana (flûte à bec en corne de chèvre) violon et nacchere (nacaires) effectuent des variations sur le thème mélodique qu'utilisait le poète « U Furcatu ».
-Thème : nous avons retrouvé la muse, à force de la chercher, que le théâtre corse fasse le tour du monde. Tout est remis en place, l'harmonie est revenue. C'est le triomphe de la poésie. On n'entend plus que musique et harmonie.

Description et Commentaires
Tags :

Poésie - Improvisation - Berger - Polyphonie - Mimophonie - Théâtre - Corse - Danse circulaire - Musique - Instruments traditionnels - Paysage sonore - chant.

Original
N° Inventaire :
TP001
Magneto :
NA
Support :
Cassette
Micro :
NA
Stéréo :
oui
Dolby :
non
Transcription intégrale :
Oui
Durée (hh:mm:ss) :
00:45:00
Vitesse :
NA
Restauration :
NR/Eq
Copie
Dossier archive :
NUM
Lieu de dépôt :
Pigna
Ajouté le: 2008-12-09 16:04:29    Vues: 1131
RSS Feeds

Informations

Application afterLoad: 0.000 seconds, 0.73 MB
Application afterInitialise: 0.010 seconds, 1.75 MB
Application afterRoute: 0.014 seconds, 2.37 MB
Application afterDispatch: 0.203 seconds, 5.35 MB
Application afterRender: 0.220 seconds, 5.75 MB

Utilisation de la mémoire

6111472

122 requêtes achevées

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'vptolqpvh5ai609c5js0va85e2'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1675111825' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'vptolqpvh5ai609c5js0va85e2'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'vptolqpvh5ai609c5js0va85e2','1675115425','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  8. SELECT id, link, name
      FROM jos_menu
      WHERE link LIKE "%index.php?option=com_sobi2%"
      AND TYPE = "component"
      AND published = 1
  9. SELECT `id`
      FROM `jos_menu`
      WHERE `link` LIKE '%index.php?option=com_sobi2'
      AND `type` = 'component'
      AND `published` = '1'
      LIMIT 1
  10. SELECT `configValue`, `configKey`
      FROM `jos_sobi2_config`
  11. SELECT `id`
      FROM `jos_menu`
      WHERE `link` LIKE '%index.php?option=com_sobi2'
      AND `type` = 'component'
      AND `published` = '1'
      LIMIT 1
  12. SELECT *
      FROM `jos_sobi2_language`
      ORDER BY `sobi2Lang`
  13. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_on_approve_text'
      AND `sobi2Lang` = 'french')
  14. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_on_approve_text'
      AND `sobi2Lang` = 'english')
  15. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_on_approve_title'
      AND `sobi2Lang` = 'french')
  16. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_on_approve_title'
      AND `sobi2Lang` = 'english')
  17. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_on_submit_text'
      AND `sobi2Lang` = 'french')
  18. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_on_submit_text'
      AND `sobi2Lang` = 'english')
  19. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_on_submit_title'
      AND `sobi2Lang` = 'french')
  20. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_on_submit_title'
      AND `sobi2Lang` = 'english')
  21. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_on_update_text'
      AND `sobi2Lang` = 'french')
  22. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_on_update_text'
      AND `sobi2Lang` = 'english')
  23. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_on_update_title'
      AND `sobi2Lang` = 'french')
  24. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_on_update_title'
      AND `sobi2Lang` = 'english')
  25. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_payments_text'
      AND `sobi2Lang` = 'french')
  26. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_payments_text'
      AND `sobi2Lang` = 'english')
  27. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_payments_title'
      AND `sobi2Lang` = 'french')
  28. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_payments_title'
      AND `sobi2Lang` = 'english')
  29. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_on_renew_text'
      AND `sobi2Lang` = 'french')
  30. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_on_renew_text'
      AND `sobi2Lang` = 'english')
  31. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_on_renew_title'
      AND `sobi2Lang` = 'french')
  32. SELECT `description`
      FROM `jos_sobi2_language`
      WHERE (`langKey` = 'email_on_renew_title'
      AND `sobi2Lang` = 'english')
  33. SELECT `configValue`
      FROM `jos_sobi2_config`
      WHERE (`configKey` = 'checkReferer'
      AND `sobi2Section` = 'editForm')
  34. SELECT `configValue`
      FROM `jos_sobi2_config`
      WHERE (`configKey` = 'needToConfirmNew'
      AND `sobi2Section` = 'editForm')
  35. SELECT `init_file`, `name_id`
      FROM `jos_sobi2_plugins`
      WHERE `enabled` = 1
      ORDER BY `position` ASC
  36. SELECT parentid
      FROM jos_sobi2_cats_relations
      WHERE catid=16
  37. SELECT catid, name, introtext
      FROM `jos_sobi2_categories`
      WHERE (`catid`=16
      AND `published` = 1)
  38. SELECT *, params AS parameters  
      FROM jos_sobi2_item
      WHERE (`itemid` = 7
      AND `published` = 1
      AND (`publish_down` > '2023-01-30 23:50:25' OR `publish_down` = '0000-00-00 00:00:00' ) )
  39. SELECT svars, schecksum
      FROM `jos_sobi2_cobj`
                     
      WHERE  ( sid = 7
      AND cid = 0
      AND cl = 0
      AND slang = 'french'
      AND oid = 0 );
  40. SELECT catid, name, introtext, description
      FROM jos_sobi2_categories
      WHERE catid = 16
  41. SELECT `fieldid`
      FROM `jos_sobi2_fields`
      WHERE `in_details`= 1
      AND `enabled` = 1
      ORDER BY POSITION
  42. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '87')  
      AND labels.sobi2Section != 'field_opt'
  43. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '82')  
      AND labels.sobi2Section != 'field_opt'
  44. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '85')  
      AND labels.sobi2Section != 'field_opt'
  45. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '219')  
      AND labels.sobi2Section != 'field_opt'
  46. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '220')  
      AND labels.sobi2Section != 'field_opt'
  47. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '86')  
      AND labels.sobi2Section != 'field_opt'
  48. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '212')  
      AND labels.sobi2Section != 'field_opt'
  49. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '215')  
      AND labels.sobi2Section != 'field_opt'
  50. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '88')  
      AND labels.sobi2Section != 'field_opt'
  51. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '89')  
      AND labels.sobi2Section != 'field_opt'
  52. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '221')  
      AND labels.sobi2Section != 'field_opt'
  53. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '222')  
      AND labels.sobi2Section != 'field_opt'
  54. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '223')  
      AND labels.sobi2Section != 'field_opt'
  55. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '224')  
      AND labels.sobi2Section != 'field_opt'
  56. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '225')  
      AND labels.sobi2Section != 'field_opt'
  57. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '228')  
      AND labels.sobi2Section != 'field_opt'
  58. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '90')  
      AND labels.sobi2Section != 'field_opt'
  59. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '91')  
      AND labels.sobi2Section != 'field_opt'
  60. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '92')  
      AND labels.sobi2Section != 'field_opt'
  61. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '93')  
      AND labels.sobi2Section != 'field_opt'
  62. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 93
      AND sobi2Lang = 'french'
      ORDER BY ordering
  63. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 93  
      ORDER BY ordering
  64. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '94')  
      AND labels.sobi2Section != 'field_opt'
  65. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '95')  
      AND labels.sobi2Section != 'field_opt'
  66. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 95
      AND sobi2Lang = 'french'
      ORDER BY ordering
  67. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 95  
      ORDER BY ordering
  68. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '97')  
      AND labels.sobi2Section != 'field_opt'
  69. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 97
      AND sobi2Lang = 'french'
      ORDER BY ordering
  70. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 97  
      ORDER BY ordering
  71. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '96')  
      AND labels.sobi2Section != 'field_opt'
  72. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 96
      AND sobi2Lang = 'french'
      ORDER BY ordering
  73. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 96  
      ORDER BY ordering
  74. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '98')  
      AND labels.sobi2Section != 'field_opt'
  75. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '99')  
      AND labels.sobi2Section != 'field_opt'
  76. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '101')  
      AND labels.sobi2Section != 'field_opt'
  77. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '218')  
      AND labels.sobi2Section != 'field_opt'
  78. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 218
      AND sobi2Lang = 'french'
      ORDER BY ordering
  79. SELECT  langKey, langValue, description + 0 AS ordering
      FROM jos_sobi2_language
      WHERE sobi2Section = 'field_opt'
      AND fieldid = 218  
      ORDER BY ordering
  80. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '102')  
      AND labels.sobi2Section != 'field_opt'
  81. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '104')  
      AND labels.sobi2Section != 'field_opt'
  82. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '206')  
      AND labels.sobi2Section != 'field_opt'
  83. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '207')  
      AND labels.sobi2Section != 'field_opt'
  84. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '209')  
      AND labels.sobi2Section != 'field_opt'
  85. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '107')  
      AND labels.sobi2Section != 'field_opt'
  86. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '108')  
      AND labels.sobi2Section != 'field_opt'
  87. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '110')  
      AND labels.sobi2Section != 'field_opt'
  88. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '111')  
      AND labels.sobi2Section != 'field_opt'
  89. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '1')  
      AND labels.sobi2Section != 'field_opt'
  90. SELECT fdata.data_txt AS DATA,  fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '1')  
      AND labels.sobi2Section != 'field_opt'
  91. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '1'
      AND `sobi2Lang` = 'french'
      AND sobi2Section != 'field_opt'
  92. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '1'
      AND sobi2Section != 'field_opt'
  93. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '2')  
      AND labels.sobi2Section != 'field_opt'
  94. SELECT fdata.data_txt AS DATA,  fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '2')  
      AND labels.sobi2Section != 'field_opt'
  95. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '2'
      AND `sobi2Lang` = 'french'
      AND sobi2Section != 'field_opt'
  96. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '2'
      AND sobi2Section != 'field_opt'
  97. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '3')  
      AND labels.sobi2Section != 'field_opt'
  98. SELECT fdata.data_txt AS DATA,  fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '3')  
      AND labels.sobi2Section != 'field_opt'
  99. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '3'
      AND `sobi2Lang` = 'french'
      AND sobi2Section != 'field_opt'
  100. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '3'
      AND sobi2Section != 'field_opt'
  101. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '6')  
      AND labels.sobi2Section != 'field_opt'
  102. SELECT fdata.data_txt AS DATA,  fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '6')  
      AND labels.sobi2Section != 'field_opt'
  103. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '6'
      AND `sobi2Lang` = 'french'
      AND sobi2Section != 'field_opt'
  104. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '6'
      AND sobi2Section != 'field_opt'
  105. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '5')  
      AND labels.sobi2Section != 'field_opt'
  106. SELECT fdata.data_txt AS DATA,  fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '5')  
      AND labels.sobi2Section != 'field_opt'
  107. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '5'
      AND `sobi2Lang` = 'french'
      AND sobi2Section != 'field_opt'
  108. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '5'
      AND sobi2Section != 'field_opt'
  109. SELECT fdata.data_txt AS DATA, fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType, POSITION
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'french'
      AND sfield.fieldid = '4')  
      AND labels.sobi2Section != 'field_opt'
  110. SELECT fdata.data_txt AS DATA,  fdata.data_bool, fdata.data_int, fdata.data_float, fdata.data_char, labels.langValue AS label, labels.langKey AS name, fieldRows,  fieldColumns, isUrl, with_label, in_newline, fieldType
      FROM `jos_sobi2_fields_data` AS fdata
      LEFT JOIN `jos_sobi2_fields` AS sfield
      ON fdata.fieldid = sfield.fieldid
      LEFT JOIN `jos_sobi2_language` AS labels
      ON sfield.fieldid = labels.fieldid
      WHERE (fdata.itemid = 7
      AND `sobi2Lang` = 'english'
      AND sfield.fieldid = '4')  
      AND labels.sobi2Section != 'field_opt'
  111. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '4'
      AND `sobi2Lang` = 'french'
      AND sobi2Section != 'field_opt'
  112. SELECT langKey AS fieldname, langValue AS fieldlabel
      FROM `jos_sobi2_language`
      WHERE `fieldid` = '4'
      AND sobi2Section != 'field_opt'
  113. SELECT *, params AS parameters  
      FROM jos_sobi2_item
      WHERE (`itemid` = 7
      AND `published` = 1
      AND (`publish_down` > '2023-01-30 23:50:25' OR `publish_down` = '0000-00-00 00:00:00' ) )
  114. SELECT svars, schecksum
      FROM `jos_sobi2_cobj`
                     
      WHERE  ( sid = 7
      AND cid = 0
      AND cl = 0
      AND slang = 'french'
      AND oid = 0 );
  115. SELECT *
      FROM jos_jcomments_settings
  116. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 70)
      ORDER BY menuid DESC
      LIMIT 0, 1
  117. SELECT `configValue`

      FROM `jos_sobi2_config`

      WHERE `configKey` = 'forceMenuId'
     
      AND `sobi2Section` = 'general'
  118. SELECT COUNT(*)

      FROM jos_jcomments

      WHERE object_id = 7

      AND object_group = 'com_sobi2'

      AND published = 1
  119. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 70 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  120. SELECT CONCAT( 'search=', `search`, '
    replace='
    , `replace`, '
    area='
    , `area`, '
    '
    , `params` )
      FROM jos_rereplacer
      WHERE published = 1
      AND area = 'component'
      ORDER BY ordering, id
  121. SELECT CONCAT( 'search=', `search`, '
    replace='
    , `replace`, '
    area='
    , `area`, '
    '
    , `params` )
      FROM jos_rereplacer
      WHERE published = 1
      AND area = 'body'
      ORDER BY ordering, id
  122. SELECT CONCAT( 'search=', `search`, '
    replace='
    , `replace`, '
    area='
    , `area`, '
    '
    , `params` )
      FROM jos_rereplacer
      WHERE published = 1
      AND area = 'everywhere'
      ORDER BY ordering, id

Fichiers de langue chargés

Diagnostique des textes non traduits

Aucun

Textes non traduits

Aucun