Médiathèque

Rosa et Filippu Fondacci 1993

En pause...
« »
  •  
    00:00:00 - Lamentu di Spada : parole
  •  
    00:01:15 - Lamentu di Spada (suite)
  •  
    00:03:15 - Lamentu di Spade (suite bis)
  •  
    00:04:40 - Scusat'o madamicella..! Serenatu
  •  
    00:05:34 - Canzone pè ballà
  •  
    00:06:32 - Alé! si stata à le legne o Namarì...
  •  
    00:07:31 - Ùn mi vogliu più fà barba...
  •  
    00:11:43 - Tribbiera
  •  
    00:13:47 - Tribbiera (suite)
Durée totale du document :
00:15:00
Interprète(s) :
non renseigné
Document N° :
CCV000002
Enregistrement
Lieu de l'enquête :
Torre, hameau d'Aregno
Année :
1993
Date :
1993-04-05
Fiche N° :
45
Enquêteur(s) :
Nicole CASALONGA
Informateur(s) :
Rosa et Filippu FONDACCI
Auteur :
Traditionnel
Personne morale :
Voce Cumune
Langue(s) :
Corse
Commentaire sur la langue :

Variété dialectale de Balagne.

Filippu Fondacci et sa femme Rosa, recherchent dans leur mémoire l'air et les paroles du lamentu di U Banditu Spada : " Eiu sò banditu, banditu rinumatu per francà la morta à ellu mi pigliò la colpa eiu.." La forme strophique est la forme habituelle des "lamenti" et de quelques berceuses. La mélodie est une variante du "lamentu di Ghjuvan Camellu", "un' aria pietosa", comme le qualifie Filippu.

Ils entonnent l'un et l'autre un début de « serenatu » chanté sur l'air du "Chjama è rispondi" : « Scusat'o madamicella, se v'aghju rottu lu sonnu, Durmarete dumaitina finalmente à meziornu È si meziornu ùn basta, durmerete sin'à a mane di Pasqua.. ». Rosa et Filippu essaient ensuite de retrouver l'air et les paroles d'une autre chanson nommée «Namaria» : "Alé si stata le legne o Santa (chji) o Namarì". La mélodie, rythmée et entrainante suggère un air à danser, peut-être un "puntu è taccu". 

Viennent ensuite des fragments de chansons qu'ils ravivent l'un et l'autre dans leur mémoire: "N'ùn mi vogliu più fà barba, alliscià ne più capelli, Mi ne vogliu andà 'nu boscu, n'ùn ci canta manc'accelli.." À la suite, le début d'une autre chanson :" Fallendu per fiumicellu, l'acqua ne falla chjara, c'era una cardellina, nant'à l'arburu cantava".

Enfin, pour terminer, ils se remémorent les paroles d'une "tribbiera" :" O tribbiera o tribbiera, Da la mattina à la sera, Pienghje à mammata ch'hè morta, S'ella hè morta è sutterata, Perdemu questa ghjurnata..." Puis ils en retrouvent l'air. Filippu chante la strophe en la ponctuant de l'interjection "Oh" qui rythme les "tribbiere". Cette interjection faite pour aiguilloner les boeufs à l'ouvrage.
Cet entretien reste un souvenir joyeux de Rosa et Filippu Fondacci que je remercie pour leur gaîeté et leur générosité.

Nicole Casalonga assistée de Geronimi Ghjiseppa le 05 février 2014.

Description et Commentaires
Tags :

Lamentu - Spada - Bandit - Banditu - Aregno - Aregnu - Balagna - Puntu è taccu - Tribbiera - Serenatu.

Original
N° Inventaire :
NC027
Magneto :
NA
Support :
Cassette
Micro :
NA
Stéréo :
oui
Dolby :
non
Transcription intégrale :
Oui
Copie
Dossier archive :
Médiathèque / NC
Backup :
Studio 2
Original :
Mégiathèque
Lieu de dépôt :
Pigna
Ajouté le: 2009-07-02 14:09:11    Vues: 908
RSS Feeds

Informations

Application afterLoad: 0.000 seconds, 0.73 MB
Application afterInitialise: 0.080 seconds, 1.76 MB
Application afterRoute: 0.135 seconds, 2.38 MB
Application afterDispatch: 0.314 seconds, 5.30 MB
Application afterRender: 0.364 seconds, 5.71 MB

Utilisation de la mémoire

6065664

122 requêtes achevées

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'h27ooo9f0ekkp7qbfl4b4haf62'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1675110123' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'h27ooo9f0ekkp7qbfl4b4haf62'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'h27ooo9f0ekkp7qbfl4b4haf62','1675113723','','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` = 12
      AND `published` = 1
      AND (`publish_down` > '2023-01-30 23:22:03' OR `publish_down` = '0000-00-00 00:00:00' ) )
  39. SELECT svars, schecksum
      FROM `jos_sobi2_cobj`
                     
      WHERE  ( sid = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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 = 12
      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` = 12
      AND `published` = 1
      AND (`publish_down` > '2023-01-30 23:22:03' OR `publish_down` = '0000-00-00 00:00:00' ) )
  114. SELECT svars, schecksum
      FROM `jos_sobi2_cobj`
                     
      WHERE  ( sid = 12
      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 = 12

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