Médiathèque

Zia Grazia Santoni: Nanna e Brindisi 1988

En pause...
« »
  •  
    00:00:00 - Nanna di u bambinu
  •  
    00:02:45 - So statu a l'ortu
  •  
    00:05:49 - Altri canzone e puesie
  •  
    00:07:19 - Canzone di a merulla
  •  
    00:08:09 - Festa di san Antone
  •  
    00:11:40 - Brindisi
  •  
    00:16:29 - Lamentu
  •  
    00:21:35 - Bucciaru
Durée totale du document :
NA
Interprète(s) :
Zia Grazia Santoni
Document N° :
CCV000019
Enregistrement
Lieu de l'enquête :
Stillicioni (Serra di Ferro)
Année :
1988
Date :
1988-10-19
Fiche N° :
38
Enquêteur(s) :
Nicole Casalonga
Informateur(s) :
Zia Grazia Santoni
Personne morale :
Voce Cumune
Langue(s) :
Corse et français
Commentaire sur la langue :

Variété dialectale du Taravo.

Zia Grazia Santoni âgée de 92 ans à l'époque, chante une berceuse : A Nanna di u bambinu que chantait sa mère. Il semble que cette berceuse était chantée dans le Taravo. C'est ainsi qu'elle a été enregistrée par Annie Goffre au près d'Isabelle Lucchini à Sampolo en 1994.

Elle chante ensuite U « Brinchs ». Il s'agit d'un vœu à la jeune épousée que l'on prononce sur le parvis de l'église en offrant un rameau d'olivier. Ce « Brinchs » avait été transmis à la mère de madame Santoni par Ziu Ghjanbattista de Currà.
Elle décrit son lieu de naissance tout près de Stillicioni où elle vit.
Elle décrit également le déroulement de la fête de Saint Antoine au col de Saint Antoine à Palneca où elle allait en estive. Ce lieu, croisement des voies, rassemblait des fidèles venus de Ghisoni, du Fiumorbu, du Valinco et du Taravo.
Une bribe de souvenir sur son père qui jouait du violon.

Elle savait aussi improviser, notamment des voceri. Elle chante à la fin de l'entretien des fragments de voceri (bucciari dans le sud) parmi lesquels un bucciaru sur la mort d'un jeune parent tombé aux Dardanelles ainsi qu'un chant satirique qu'adressait une pleureuse aux gens d'Aziloni qui ne savaient pas improviser de bucciari. Cette pleureuse était rémunérée avec un quintal de grains (seigle, orge...)

Durant cet entretien, on entend les commentaires de sa fille parmi d'autres.

« O li ghjenti d'Aziloni
Cumu setti pogh'e boni
Morinu li vosci aghjenti
Un setti boni a bucciarà
Dettim'u baccinu di la sela (sèbula)
Ch'e notte mi n'aghju andà »

Description et Commentaires
Tags :

Brinchs, Nanna di u bambinu, Bucciaru, Sant’Antone, Stillicioni

Original
N° Inventaire :
NC020_1
Magneto :
NA
Support :
Cassette
Micro :
NA
Stéréo :
oui
Dolby :
non
Transcription intégrale :
Oui
Durée (hh:mm:ss) :
00:23:05
Vitesse :
NA
Restauration :
NR/Eq
Copie
Dossier archive :
Num
Ajouté le: 2010-05-19 18:57:17    Vues: 1259

Commentaires  

 
+1 #2 santoni 04-10-2011 17:47
Su statu a l'ortu fait partie de A nanna di u Bambinu écrite par Monsiognor di la Foata.
Citer
 
 
0 #1 santoni 04-10-2011 17:44
A festa di Sant'Atonu di Palleca he quilla di Sant'Antonu di u Porcu (Sant'Antonu Abbate Saint Antoine du désert) qui est célébrée normalement au mois de janvier. E,n raison des conditions météo très rigoureuses en cette saison, la célébration a été reportée au mois de juin. Ne pas confondre avec St Antoine de Padoue célébrée le 13 juin.
Citer
 
RSS Feeds

Informations

Application afterLoad: 0.000 seconds, 0.73 MB
Application afterInitialise: 0.011 seconds, 1.76 MB
Application afterRoute: 0.016 seconds, 2.37 MB
Application afterDispatch: 0.117 seconds, 5.34 MB
Application afterRender: 0.137 seconds, 5.73 MB

Utilisation de la mémoire

6084264

123 requêtes achevées

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'g98b5971j0pl6voq2lkqpspbu1'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1675113552' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'g98b5971j0pl6voq2lkqpspbu1'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'g98b5971j0pl6voq2lkqpspbu1','1675117152','','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=22
  37. SELECT catid, name, introtext
      FROM `jos_sobi2_categories`
      WHERE (`catid`=22
      AND `published` = 1)
  38. SELECT *, params AS parameters  
      FROM jos_sobi2_item
      WHERE (`itemid` = 24
      AND `published` = 1
      AND (`publish_down` > '2023-01-31 00:19:12' OR `publish_down` = '0000-00-00 00:00:00' ) )
  39. SELECT svars, schecksum
      FROM `jos_sobi2_cobj`
                     
      WHERE  ( sid = 24
      AND cid = 0
      AND cl = 0
      AND slang = 'french'
      AND oid = 0 );
  40. SELECT catid, name, introtext, description
      FROM jos_sobi2_categories
      WHERE catid = 22
  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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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 = 24
      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` = 24
      AND `published` = 1
      AND (`publish_down` > '2023-01-31 00:19:12' OR `publish_down` = '0000-00-00 00:00:00' ) )
  114. SELECT svars, schecksum
      FROM `jos_sobi2_cobj`
                     
      WHERE  ( sid = 24
      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 = 72)
      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 = 24

      AND object_group = 'com_sobi2'

      AND published = 1
  119. SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment
    , c.email, c.homepage, c.DATE AS datetime, c.ip, c.published, c.checked_out, c.checked_out_time
    , c.isgood, c.ispoor
    , v.VALUE AS voted
    , CASE WHEN c.userid = 0 THEN 'guest' ELSE REPLACE(LOWER(u.usertype), ' ', '-') END AS usertype

      FROM jos_jcomments AS c

      LEFT JOIN jos_jcomments_votes AS v
      ON c.id = v.commentid  
      AND v.userid = 0
      AND v.ip = '44.192.38.49'

      LEFT JOIN jos_users AS u
      ON c.userid = u.id

      WHERE c.object_id = 24
      AND c.object_group = 'com_sobi2'
      AND c.published = 1

      ORDER BY c.DATE DESC

      LIMIT 0, 10
  120. 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 = 72 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  121. SELECT CONCAT( 'search=', `search`, '
    replace='
    , `replace`, '
    area='
    , `area`, '
    '
    , `params` )
      FROM jos_rereplacer
      WHERE published = 1
      AND area = 'component'
      ORDER BY ordering, id
  122. SELECT CONCAT( 'search=', `search`, '
    replace='
    , `replace`, '
    area='
    , `area`, '
    '
    , `params` )
      FROM jos_rereplacer
      WHERE published = 1
      AND area = 'body'
      ORDER BY ordering, id
  123. 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