Médiathèque

Chjama è Rispondi di natale, Pigna, 2000.

En pause...
« »
  •  
    00:00:00 - debut du chjam'é rispondi
  •  
    00:06:07 - Paghjella
  •  
    00:07:45 - Chjama é rispondi
  •  
    00:08:53 - Paghjella
  •  
    00:10:28 - Conversations
  •  
    00:11:07 - Chjama e Rispondi entre u Russignolu et Francescu Simenoni mais on denote une domination des conversations
  •  
    00:18:50 - les Conversations s`amenuisent
Durée totale du document :
00:30:26
Interprète(s) :
Roccu Mambrini, Olivier Ancey, Carlinu Orsucci, Ghjacumu Ferrari, Matteu Salviani+, Francescu Simeoni, Luiggi Savignoni
Document N° :
CCV000003
Enregistrement
Lieu de l'enquête :
Pigna, Casa Musicale
Année :
2000
Date :
2000-12-30
Fiche N° :
3
Enquêteur(s) :
Nando Acquaviva
Informateur(s) :
Les interprètes
Auteur :
Nando Acquaviva
Personne morale :
Voce Cumune
Langue(s) :
Corse
Commentaire sur la langue :

Si risentenu assai l’accenti è i maneri di parlà è di cantà di i sfarenti rughjoni di i canterini.

Il s’agit d’un langage poétique qui exprime la personnalité de chacun des poètes et où l’on ressent les différentes façons de chanter et de parler en fonction des villages d’où viennent les chanteurs.

Résumé :

Il s'agit d'une conversation pour l'essentiel entre 3 poètes, Roccu Mambrini, qui est lui-même le sujet, Olivier Ancey et Carlinu Orsucci.
Sujet : comment et pourquoi manger le «Rossignol» (Roccu dont c'est le surnom).

A 00'6'07, le chjama è rispondi s'interrompt le temps d'une paghjella :
Seconda : Carlinu,
Terza : Olivier,
Bassu : Matteu ( ?) +

Texte : Vurria chì la miò voce trapanessi le muntagne (je voudrais que ma voix transperce les montagnes) la suite est difficilement audible, mêlée de conversation. Puis les Chjama è Rispondi reprennent à 10-35 avec G. Ferrari qui change de sujet : Maddalena, la soeur de Ambrosgiu Vesperini (+); Carlinu lui répond à 00'13'30; le sujet initial reprend jusqu'à la fin et l'on entend plus loin, un autre Chjama è Rispondi. Belle vitalité !

Description et Commentaires
Tags :

Chjama e Rispondi - Casa Musicale - Pigna - Russignolu - Natale  - 1960.

Original
N° Inventaire :
NA040
Magneto :
NA
Support :
Cassette
Micro :
NA
Stéréo :
non
Dolby :
non
Transcription intégrale :
Oui
Durée (hh:mm:ss) :
00:30:26
Vitesse :
NA
Restauration :
NR/CIEq
Ajouté le: 2009-07-08 18:08:27    Vues: 2252

Commentaires  

 
+2 #1 Olivier Ancey 16-01-2011 21:05
dui picculi affari
annant'à a prima paghjella a terza sò eiu chì a facciu, ma annant'à quill'altra micca.
Maddalena s'e m'arricordu bè saria a surella d'Ambrosgiu Vesperini, micca a moglia di Matteu Salviani (chì si chjama anch'ella cusì).
Citer
 
RSS Feeds

Informations

Application afterLoad: 0.000 seconds, 0.73 MB
Application afterInitialise: 0.124 seconds, 1.76 MB
Application afterRoute: 0.260 seconds, 2.38 MB
Application afterDispatch: 0.592 seconds, 5.34 MB
Application afterRender: 0.657 seconds, 5.74 MB

Utilisation de la mémoire

6093832

123 requêtes achevées

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'r7pe4oi8j40hkvlj16eq35qju2'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1675110654' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'r7pe4oi8j40hkvlj16eq35qju2'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'r7pe4oi8j40hkvlj16eq35qju2','1675114254','','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=2
  37. SELECT catid, name, introtext
      FROM `jos_sobi2_categories`
      WHERE (`catid`=2
      AND `published` = 1)
  38. SELECT *, params AS parameters  
      FROM jos_sobi2_item
      WHERE (`itemid` = 13
      AND `published` = 1
      AND (`publish_down` > '2023-01-30 23:30:54' OR `publish_down` = '0000-00-00 00:00:00' ) )
  39. SELECT svars, schecksum
      FROM `jos_sobi2_cobj`
                     
      WHERE  ( sid = 13
      AND cid = 0
      AND cl = 0
      AND slang = 'french'
      AND oid = 0 );
  40. SELECT catid, name, introtext, description
      FROM jos_sobi2_categories
      WHERE catid = 33
  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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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 = 13
      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` = 13
      AND `published` = 1
      AND (`publish_down` > '2023-01-30 23:30:54' OR `publish_down` = '0000-00-00 00:00:00' ) )
  114. SELECT svars, schecksum
      FROM `jos_sobi2_cobj`
                     
      WHERE  ( sid = 13
      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 = 66)
      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 = 13

      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 = 13
      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 = 66 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