Médiathèque

Cloches de Pioggiola, 1987.

En pause...
« »
  •  
    00:00:00 - Iniziu
Durée totale du document :
00:37:06
Interprète(s) :
?
Document N° :
CCV000086 053
Enregistrement
Lieu de l'enquête :
Pioggiola
Année :
1987
Date :
1987-08-13
Enquêteur(s) :
Antoine Massoni
Informateur(s) :
Santu Massiani
Personne morale :
Centre culturel voce
Commentaire sur la langue :

Il s'agit ici d'un concours de sonneurs de cloches organisés à Pioggiola. Différentes équipes s'affrontent afin de faire reconnaître leur talent et leur hardiesse à créer un mailliage de variations rythmiques et mélodiques autour de la "ciccona".

Santu Massiani présente les équipes jusqu'à 02m20secondes.

1 ère équipe : François Carboni de Pioggiola "à e chjuche" : "mezana" et "chjuca", et Toussaint Massiani à la grande (" a cicona").

2ème équipe : Luiggi Jacques de Pioggiola " à e chjuche" et Argenti ? Paul à "a cicona".

3ème équipe : Giacomoni Nonce d'Olmi-Cappella et Luiggi Anton'Ghjuvanni.

4ème équipe: Benedetti de Costa et Massiani Toussaint.

5ème équipe: Massoni Antoine de Pigna et Acquaviva Nando de Lisula.

6ème équipe: Fabiani Antoine, maire de Mausoleu et Franceschi Antoine.

7ème équipe: ........ de Pioggiola et Massiani Toussaint.

8ème équipe: Luiggi Anton'Ghjuvanni de Pioggiola et Antonelli François.

 

Dans son ouvrage "Les musiques de Corse", édité au édition Piazziola, Antoine Massoni décrit à la page 99 de son ouvrage, le processus de la sonnerie. Il faut rappeler la formation de percussioniste d'Antoine Massoni, qui s'était fortement impliqué dans l'analyse de la tradition campanaire, notamment celle de Pioggiola, où il avait lui-même participé aux sonneries festives.

" U Campanile est le plus grand instrument de l'île et c'est pour cete raison qu'il est si souvent oublié. Son rôle est d'assurer la transmission des messages. Au sein des villages, sa fonction est double, à l'usage des offices du culte mais également de la vie sociale. Il émet deux types de messages: centrifuge pour l'appel au rassemblement, et centripète ( qui rapproche du centre), pour donner l'alarme d'un danger ( incendie, guerre, épidémie..)

À son sommet, le clocher abrite généralement trois cloches d'où son nom de trillon:

"A ciccona ou a maiò" ( le bourdon), donne la tonique et assure une battue régulière. Elle est mise à la volée par un sonneur qui tient un tempo lent afin de permettre les variations sur les deux autres cloches.

"A mezana" fait la seconde majeure et "a chjuca" la tierce majeure.

Les deux sont sonnées par la même personne "à pichju martellu". En actionnant les battants tenus soit directement à la main soit par l'intermédiaire d'une cordelette, le sonneur doit exécuter des variations en miroir, selon un code défini, afin que le message soit bien compris. "A ciccona" mise à la volée définit une battue ample pour laisser se développer les ornements de " A mezana" et de la "chjuca". Sur ce tempo, le sonneur commence toujours sur la "chjucca" et reprend la formule en inversant son attaque sur la "mezana". Des formules binaires, ternaires, quinaires ou composées en 3/2/2.... selon l'improvisation, l'espace laissé par la "ciccona" ne permettant pas d'exécuter plus de huit frappes."

Original
N° Inventaire :
AM012
Support :
Cassette
Transcription intégrale :
Oui
Durée (hh:mm:ss) :
00:37:06
Copie
Dossier archive :
Médiathèque
Original :
Médiathèque
Lieu de dépôt :
Médiathèque
Ajouté le: 2011-06-06 17:46:17    Vues: 961
RSS Feeds

Informations

Application afterLoad: 0.000 seconds, 0.73 MB
Application afterInitialise: 0.081 seconds, 1.76 MB
Application afterRoute: 0.135 seconds, 2.38 MB
Application afterDispatch: 0.422 seconds, 5.30 MB
Application afterRender: 0.477 seconds, 5.70 MB

Utilisation de la mémoire

6056120

122 requêtes achevées

  1. SELECT *
      FROM jos_session
      WHERE session_id = '34avnrf8sak1sepii79m09fpu0'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1685227693' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '34avnrf8sak1sepii79m09fpu0'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '34avnrf8sak1sepii79m09fpu0','1685231293','','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=27
  37. SELECT catid, name, introtext
      FROM `jos_sobi2_categories`
      WHERE (`catid`=27
      AND `published` = 1)
  38. SELECT *, params AS parameters  
      FROM jos_sobi2_item
      WHERE (`itemid` = 98
      AND `published` = 1
      AND (`publish_down` > '2023-05-28 02:48:13' OR `publish_down` = '0000-00-00 00:00:00' ) )
  39. SELECT svars, schecksum
      FROM `jos_sobi2_cobj`
                     
      WHERE  ( sid = 98
      AND cid = 0
      AND cl = 0
      AND slang = 'french'
      AND oid = 0 );
  40. SELECT catid, name, introtext, description
      FROM jos_sobi2_categories
      WHERE catid = 38
  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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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 = 98
      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` = 98
      AND `published` = 1
      AND (`publish_down` > '2023-05-28 02:48:13' OR `publish_down` = '0000-00-00 00:00:00' ) )
  114. SELECT svars, schecksum
      FROM `jos_sobi2_cobj`
                     
      WHERE  ( sid = 98
      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 = 74)
      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 = 98

      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 = 74 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