Accueil

Identification






Perdu votre mot de passe?
Forgot your username?

VirtueMart
Votre panier est actuellement vide.

Agenda

Le mois dernier Mars 2015 Le mois prochain
L Ma Me J V S D
week 9 1
week 10 2 3 4 5 6 7 8
week 11 9 10 11 12 13 14 15
week 12 16 17 18 19 20 21 22
week 13 23 24 25 26 27 28 29
week 14 30 31
Prochain débat : 19 juin 2014, Paris, 19h00 PDF Imprimer Envoyer

Elections municipales et européennes 2014 : analyse croisée

avec :

  • David Revault d'Allonnes, Le Monde
  • Michel Urvoy, Ouest France
  • Pascal Perrineau, CEVIPOF

télécharger l'affiche en HD


Débat le 19 juin 2014 19h00-21h00
Salle Montparnasse Rencontre,
92 bis bd du Montparnasse 75014 PARIS

A l'occasion de son Assemblée générale annuelle,
Chrétiens en Forum organise un débat entre un politologue et deux journalistes de renom.

Leur analyse croisée des résultats des élections municipales et européennes de 2014 répondra à plusieurs questions :

  • Quelles convergences établir entre les résultats des deux scrutins ?
  • A travers ce vote, qu'ont voulu dire les Français ?
  • Les partis politiques sont-ils en mesure de l'entendre et d'y faire droit ?

Entrée libre sur inscriptions jusqu'au 16 juin, par courriel ( Cette adresse email est protégée contre les robots des spammeurs, vous devez activer Javascript pour la voir. ) ou téléphone : 01 43 31 74 74

 
Forum ce samedi ! PDF Imprimer Envoyer

 

"EUROPE 2014 : VOTER POUR QUOI ?"
12 avril 2014, 10h00 – 17h00
Forum à La Baule (44), salle des Floralies, Place des Salines

plan googlemap

Avec, notamment :

  • Catherine LALUMIERE, ancien Ministre, Présidente de la Fédération Française des Maisons de l’Europe,
  • Pascal LAMY, ex Directeur de l’OMC, Président d’honneur de Notre Europe – Institut Jacques Delors.
  • P. Henri MADELIN, sj, Conseil de l’Europe.

Entée libre, libre participation aux frais.

Les élections européennes auront lieu le 25 mai prochain. Notre monde  globalisé et instable voit l’émergence de nouvelles puissances.
Dans ce contexte, nous avons à faire un choix :  peser ensemble ou disparaître individuellement. Voter ou s’abstenir.
Pour nous, l’heure est à la mobilisation.
Les faiblesses réelles de l’Europe ne sauraient cacher ce qu’elle nous garantit  au quotidien :  la paix,  la justice, la solidarité, la mobilité, les échanges culturels, la compétitivité économique...
Ces réalités sont désirables, comme vient de nous le rappeler la lutte à mort de nombreux Ukrainiens.
Le forum de La Baule veut permettre à chacun d’exprimer ce qu’il en pense, en attend, en espère.

 


 
Communiqué de Presse PDF Imprimer Envoyer

Chrétiens en Forum au service des chrétiens élus locaux.

Chrétiens en Forum entend servir élus et candidats de toutes tendances politiques en leur permettant de réfléchir ensemble aux convictions qui sous-tendent leur engagement.

Cet engagement s’avère indispensable à la vie du pays aujourd’hui : les élus locaux – 550 000 en France- sont des élus de proximité. Ils vivifient le lien social tout en garantissant les droits et les services qui irriguent la collectivité. Pour une majorité de citoyens, ces élus représentent le premier secours  et le dernier recours. Ils sont ainsi constamment mis à contribution.

Depuis 1993, l’association Chrétiens en Forum a constaté le besoin de réflexion et de dialogue de ces élus locaux. Pour y répondre, elle  organise partout en France des forums à leur intention.

Lire la suite...
 
Les relations intergénérationnelles

Nous vivons une situation sans précédent dans l’Histoire où quatre voire cinq générations cohabitent. Lié au progrès médical notamment, l’allongement de la durée de la vie nous prend au dépourvu : âge biologique (corps), âge chronologique (temps de vie) et âge social (attitude, apparence, pratiques) ne coïncident plus. Le rôle et la place de chaque génération s’en trouvent radicalement modifiés.

Lire la suite...
 
L'emploi, l'enjeu des élections 2012?

Revivez l'intervention de Guillaume Duval, rédacteur en chef d'Alternatives économiques le 10 décembre 2011 au Centre Sèvres à l'occasion de la rencontre organisée par Chrétiens en Forum, le CCSC et la JOC.


DUVAL 10122011 par Chretiensenforum

 

Réagissez à cette intervention sur le forum en ligne

 
« DébutPrécédent12SuivantFin »

Page 1 sur 2
 

Questions en débat :

Aucun événement

Informations

Application afterLoad: 0.000 seconds, 1.01 MB
Application afterInitialise: 0.037 seconds, 3.99 MB
Application afterRoute: 0.044 seconds, 4.81 MB
Application afterDispatch: 0.097 seconds, 8.90 MB
Application afterRender: 0.246 seconds, 18.32 MB

Utilisation de la mémoire

19322328

30 requêtes achevées

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'mov86spf4jvfj30orrrrea52u7'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1425266084' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'mov86spf4jvfj30orrrrea52u7'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'mov86spf4jvfj30orrrrea52u7','1425266984','','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 template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 1)
      ORDER BY menuid DESC
      LIMIT 0, 1
  9. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      ORDER BY  f.ordering
      LIMIT 0, 9
  10. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      ORDER BY  f.ordering
  11. 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 = 1 OR mm.menuid = 0 )
      ORDER BY position, ordering
  12. SELECT c.id
     
      FROM jos_categories AS c
      LEFT JOIN jos_categories AS p
      ON p.id=c.parent_id
      LEFT JOIN jos_categories AS gp
      ON gp.id=p.parent_id 
      LEFT JOIN jos_categories AS ggp
      ON ggp.id=gp.parent_id
     
      WHERE c.access <= 0
     
      AND c.published = 1
     
      AND c.section = 'com_jevents'
  13. SELECT rpt.*, ev.*, rr.*, det.*, ev.state AS published
     , YEAR(rpt.startrepeat) AS yup, MONTH(rpt.startrepeat ) AS mup, DAYOFMONTH(rpt.startrepeat ) AS dup
     , YEAR(rpt.endrepeat  ) AS ydn, MONTH(rpt.endrepeat   ) AS mdn, DAYOFMONTH(rpt.endrepeat   ) AS ddn
     , HOUR(rpt.startrepeat) AS hup, MINUTE(rpt.startrepeat ) AS minup, SECOND(rpt.startrepeat ) AS sup
     , HOUR(rpt.endrepeat  ) AS hdn, MINUTE(rpt.endrepeat   ) AS mindn, SECOND(rpt.endrepeat   ) AS sdn
     
      FROM jos_jevents_repetition AS rpt
     
      LEFT JOIN jos_jevents_vevent AS ev
      ON rpt.eventid = ev.ev_id
     
      LEFT JOIN jos_jevents_icsfile AS icsf
      ON icsf.ics_id=ev.icsid
     
      LEFT JOIN jos_jevents_vevdetail AS det
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN jos_jevents_rrule AS rr
      ON rr.eventid = rpt.eventid
     
      WHERE ev.catid IN(-1,35,43,44,48,49,50)
     
      AND rpt.endrepeat >= '2015-03-02'
      AND rpt.startrepeat <= '2015-03-15'
      AND ev.state=1
     
      AND ev.access <= 0 
      AND icsf.state=1
      AND icsf.access <= 0
  14. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      AND cc.id = 51
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 1
  15. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      AND cc.id = 36
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  16. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      AND cc.id = 46
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  17. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      AND cc.id = 42
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  18. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      AND cc.id = 42
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  19. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      AND cc.id = 42
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  20. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      AND cc.id = 42
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  21. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      AND cc.id = 47
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  22. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  23. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
               
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  24. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                            vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  25. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  26. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'
  27. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  28. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  29. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  30. SELECT rpt.*, ev.*, rr.*, det.*, ev.state AS published
     , YEAR(rpt.startrepeat) AS yup, MONTH(rpt.startrepeat ) AS mup, DAYOFMONTH(rpt.startrepeat ) AS dup
     , YEAR(rpt.endrepeat  ) AS ydn, MONTH(rpt.endrepeat   ) AS mdn, DAYOFMONTH(rpt.endrepeat   ) AS ddn
     , HOUR(rpt.startrepeat) AS hup, MINUTE(rpt.startrepeat ) AS minup, SECOND(rpt.startrepeat ) AS sup
     , HOUR(rpt.endrepeat  ) AS hdn, MINUTE(rpt.endrepeat   ) AS mindn, SECOND(rpt.endrepeat   ) AS sdn
     
      FROM jos_jevents_repetition AS rpt
     
      LEFT JOIN jos_jevents_vevent AS ev
      ON rpt.eventid = ev.ev_id
     
      LEFT JOIN jos_jevents_icsfile AS icsf
      ON icsf.ics_id=ev.icsid
     
      LEFT JOIN jos_jevents_vevdetail AS det
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN jos_jevents_rrule AS rr
      ON rr.eventid = rpt.eventid
     
      WHERE ev.catid IN(-1,35,43,44,48,49,50)
     
      AND rpt.endrepeat >= '2015-03-01 00:00:00'
      AND rpt.startrepeat <= '2015-03-31 23:59:59'
      AND ev.state=1
     
      AND ev.access <= 0 
      AND icsf.state=1
      AND icsf.access <= 0

30 requêtes legacy achevées

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'mov86spf4jvfj30orrrrea52u7'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1425266084' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'mov86spf4jvfj30orrrrea52u7'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'mov86spf4jvfj30orrrrea52u7','1425266984','','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 template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 1)
      ORDER BY menuid DESC
      LIMIT 0, 1
  9. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      ORDER BY  f.ordering
      LIMIT 0, 9
  10. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      ORDER BY  f.ordering
  11. 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 = 1 OR mm.menuid = 0 )
      ORDER BY position, ordering
  12. SELECT c.id
     
      FROM jos_categories AS c
      LEFT JOIN jos_categories AS p
      ON p.id=c.parent_id
      LEFT JOIN jos_categories AS gp
      ON gp.id=p.parent_id 
      LEFT JOIN jos_categories AS ggp
      ON ggp.id=gp.parent_id
     
      WHERE c.access <= 0
     
      AND c.published = 1
     
      AND c.section = 'com_jevents'
  13. SELECT rpt.*, ev.*, rr.*, det.*, ev.state AS published
     , YEAR(rpt.startrepeat) AS yup, MONTH(rpt.startrepeat ) AS mup, DAYOFMONTH(rpt.startrepeat ) AS dup
     , YEAR(rpt.endrepeat  ) AS ydn, MONTH(rpt.endrepeat   ) AS mdn, DAYOFMONTH(rpt.endrepeat   ) AS ddn
     , HOUR(rpt.startrepeat) AS hup, MINUTE(rpt.startrepeat ) AS minup, SECOND(rpt.startrepeat ) AS sup
     , HOUR(rpt.endrepeat  ) AS hdn, MINUTE(rpt.endrepeat   ) AS mindn, SECOND(rpt.endrepeat   ) AS sdn
     
      FROM jos_jevents_repetition AS rpt
     
      LEFT JOIN jos_jevents_vevent AS ev
      ON rpt.eventid = ev.ev_id
     
      LEFT JOIN jos_jevents_icsfile AS icsf
      ON icsf.ics_id=ev.icsid
     
      LEFT JOIN jos_jevents_vevdetail AS det
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN jos_jevents_rrule AS rr
      ON rr.eventid = rpt.eventid
     
      WHERE ev.catid IN(-1,35,43,44,48,49,50)
     
      AND rpt.endrepeat >= '2015-03-02'
      AND rpt.startrepeat <= '2015-03-15'
      AND ev.state=1
     
      AND ev.access <= 0 
      AND icsf.state=1
      AND icsf.access <= 0
  14. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      AND cc.id = 51
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
      LIMIT 0, 1
  15. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      AND cc.id = 36
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  16. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      AND cc.id = 46
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  17. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      AND cc.id = 42
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  18. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      AND cc.id = 42
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  19. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      AND cc.id = 42
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  20. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      AND cc.id = 42
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  21. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-03-02 03:29:44' ) 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-03-02 03:29:44' )
      AND cc.id = 47
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
  22. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  23. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
               
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
  24. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                            vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  25. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  26. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'
  27. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  28. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  29. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND params LIKE '%page=shop.cart%'
      AND published=1
  30. SELECT rpt.*, ev.*, rr.*, det.*, ev.state AS published
     , YEAR(rpt.startrepeat) AS yup, MONTH(rpt.startrepeat ) AS mup, DAYOFMONTH(rpt.startrepeat ) AS dup
     , YEAR(rpt.endrepeat  ) AS ydn, MONTH(rpt.endrepeat   ) AS mdn, DAYOFMONTH(rpt.endrepeat   ) AS ddn
     , HOUR(rpt.startrepeat) AS hup, MINUTE(rpt.startrepeat ) AS minup, SECOND(rpt.startrepeat ) AS sup
     , HOUR(rpt.endrepeat  ) AS hdn, MINUTE(rpt.endrepeat   ) AS mindn, SECOND(rpt.endrepeat   ) AS sdn
     
      FROM jos_jevents_repetition AS rpt
     
      LEFT JOIN jos_jevents_vevent AS ev
      ON rpt.eventid = ev.ev_id
     
      LEFT JOIN jos_jevents_icsfile AS icsf
      ON icsf.ics_id=ev.icsid
     
      LEFT JOIN jos_jevents_vevdetail AS det
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN jos_jevents_rrule AS rr
      ON rr.eventid = rpt.eventid
     
      WHERE ev.catid IN(-1,35,43,44,48,49,50)
     
      AND rpt.endrepeat >= '2015-03-01 00:00:00'
      AND rpt.startrepeat <= '2015-03-31 23:59:59'
      AND ev.state=1
     
      AND ev.access <= 0 
      AND icsf.state=1
      AND icsf.access <= 0

Fichiers de langue chargés

Diagnostique des textes non traduits

Aucun

Textes non traduits

Aucun