Inscriptions au Vide-dressing ouvertes
A2MS met en place un vide dressing à partir de cette année. Pour cette première édition, l'événement se déroulera le samedi 6 et dimanche 7 octobre 2018 de 8h à 18h au Le Hangar de Lugny.
Les articles acceptés sont les vêtements - propre, non démodés et non déchirés - pour adolescent, femme et homme, les chaussures (neuves ou proches du neuf), les sacs à main, et accessoires (ceintures, chapeau, bijoux, foulards…).
Les inscriptions sont terminées. Toutefois, il reste quelques places. Pour une inscription, veuillez appeler directement au 06 65 09 89 82 vendredi entre 15h à 18h uniquement.
Vous avez 3 choix de mode de paiement : par chèque, par espèces par Paypal.
Les inscriptions au vide greniers de Jatteau de Moissy Cramayel sont clos. Toutefois, il reste quelques emplacements. Pour en réserver un, il faut appeler le 06 65 09 89 82 ou venir directement au vide grenier dimanche 3 juin avant 6h30.
Les justificatifs d’inscription sont envoyés cette semaine et au plus tard samedi matin. Pour ceux qui n’ont pas d’adresse mail, la présentation d’une pièce d’identité à l’entrée du vide greniers suffira.
a2ms a apporté sa participation pour équiper la salle d'étude et de bibliothèque de l'ONG Akany Famonjena Ambohidratrimo/Madagascar. Cette ONG héberge des orphelins et concentre ses efforts sur l'éducation et l'alimentation des enfants.
Leur page Facebook ici
session.counter ⇒ 1
session.timer.start ⇒ 1550802091
session.timer.last ⇒ 1550802091
session.timer.now ⇒ 1550802091
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
registry ⇒ {}
id ⇒ 0
name ⇒
username ⇒
email ⇒
password ⇒
password_clear ⇒
usertype ⇒
block ⇒
sendEmail ⇒ 0
registerDate ⇒
lastvisitDate ⇒
activation ⇒
params ⇒
groups ⇒ Array
guest ⇒ 1
aid ⇒ 0
Application 0.000 seconds (+0.000); 0.60 MB (+0.603) - afterLoad
Application 0.095 seconds (+0.095); 4.88 MB (+4.280) - afterInitialise
Application 0.137 seconds (+0.042); 5.89 MB (+1.010) - afterRoute
Application 0.197 seconds (+0.060); 8.87 MB (+2.974) - afterDispatch
Application 0.201 seconds (+0.004); 9.05 MB (+0.182) - beforeRenderModule mod_menu (Menu principal)
Application 0.204 seconds (+0.004); 9.16 MB (+0.115) - afterRenderModule mod_menu (Menu principal)
Application 0.204 seconds (+0.000); 9.16 MB (-0.006) - beforeRenderModule mod_breadcrumbs (Fil de navigation)
Application 0.206 seconds (+0.001); 9.22 MB (+0.063) - afterRenderModule mod_breadcrumbs (Fil de navigation)
Application 0.206 seconds (+0.000); 9.22 MB (-0.003) - beforeRenderModule mod_search (Rechercher)
Application 0.207 seconds (+0.001); 9.24 MB (+0.024) - afterRenderModule mod_search (Rechercher)
Application 0.207 seconds (+0.000); 9.24 MB (+0.001) - beforeRenderModule mod_ariimageslider (ARI Image Slider)
Application 0.215 seconds (+0.008); 9.89 MB (+0.648) - afterRenderModule mod_ariimageslider (ARI Image Slider)
Application 0.215 seconds (+0.000); 9.84 MB (-0.051) - beforeRenderModule mod_maximenuck (Maximenu CK)
Application 0.227 seconds (+0.012); 10.20 MB (+0.357) - afterRenderModule mod_maximenuck (Maximenu CK)
Application 0.231 seconds (+0.004); 10.26 MB (+0.066) - afterRender
10.3 MB (10,799,520 Bytes)
SELECT `data`
FROM `jk0sx_session`
WHERE `session_id` = 'cfh63i2m1lmt6bvdldepeg98k2'
DELETE
FROM `jk0sx_session`
WHERE `time` < '1550800291'
SELECT `session_id`
FROM `jk0sx_session`
WHERE `session_id` = 'cfh63i2m1lmt6bvdldepeg98k2'
LIMIT 0, 1
INSERT INTO `jk0sx_session`
(`session_id`, `client_id`, `time`)
VALUES
('cfh63i2m1lmt6bvdldepeg98k2', 0, '1550802091')
SELECT extension_id AS id, element AS "option", params, enabled
FROM jk0sx_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT id, rules
FROM `jk0sx_viewlevels`
SELECT folder AS type, element AS name, params
FROM jk0sx_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM jk0sx_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
Update
jk0sx_contentbuilder_articles As articles,
jk0sx_content As content,
jk0sx_contentbuilder_forms As forms,
jk0sx_contentbuilder_registered_users As cbusers,
jk0sx_users As users
Set
content.state = 0
Where
articles.article_id = content.id
And
content.state = 1
And
articles.form_id = forms.id
And
forms.act_as_registration = 1
And
forms.id = cbusers.form_id
And
content.created_by = cbusers.user_id
And
(
(
users.id = cbusers.user_id
And
users.block = 1
)
)
Update
jk0sx_contentbuilder_articles As articles,
jk0sx_content As content,
jk0sx_contentbuilder_forms As forms,
jk0sx_contentbuilder_records As records,
jk0sx_contentbuilder_registered_users As cbusers,
jk0sx_users As users
Set
content.state = forms.auto_publish
Where
articles.article_id = content.id
And
content.state = 0
And
articles.form_id = forms.id
And
forms.act_as_registration = 1
And
forms.id = cbusers.form_id
And
content.created_by = cbusers.user_id
And
users.id = cbusers.user_id
And
records.record_id = cbusers.record_id
And
records.`type` = forms.`type`
And
users.block = 0
Select
form.id As form_id,
form.act_as_registration,
form.default_category,
form.registration_name_field,
form.registration_username_field,
form.registration_email_field,
form.registration_email_repeat_field,
form.`last_update`,
article.`article_id`,
form.`title_field`,
form.`create_articles`,
form.`name`,
form.`use_view_name_as_title`,
form.`protect_upload_directory`,
form.`reference_id`,
records.`record_id`,
form.`type`,
form.`published_only`,
form.`own_only`,
form.`own_only_fe`,
records.`last_update` As record_last_update,
article.`last_update` As article_last_update
From
jk0sx_contentbuilder_records As records
Left Join jk0sx_contentbuilder_forms As form
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id )
Left Join jk0sx_contentbuilder_articles As article
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id
And article.form_id = form.id
And article.record_id = records.record_id )
Left Join jk0sx_content As content
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id
And article.article_id = content.id
And article.form_id = form.id
And article.record_id = records.record_id )
Where
form.`published` = 1
And
form.create_articles = 1
And
form.`type` = records.`type`
And
form.reference_id = records.reference_id
And
(
(
article.form_id = form.id
And
article.record_id = records.record_id
And
article.article_id = content.id
And
( content.state = 1 Or content.state = 0 )
And
(
form.`last_update` > article.`last_update`
Or
records.`last_update` > article.`last_update`
)
)
Or
(
form.id Is Not Null
And records.id Is Not Null
And content.id Is Null
And article.id Is Null
)
)
Limit 50
SET SESSION group_concat_max_len = 9999999
Select *
From jk0sx_contentbuilder_storages
Where id = 7
And published = 1
Order By `ordering`
Select *
From jk0sx_contentbuilder_storage_fields
Where storage_id = 7
And published = 1
Order By `ordering`
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '1'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '1'
Select *
From jk0sx_emplacementvd
Where id = 1
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '2'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '2'
Select *
From jk0sx_emplacementvd
Where id = 2
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '3'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '3'
Select *
From jk0sx_emplacementvd
Where id = 3
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '4'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '4'
Select *
From jk0sx_emplacementvd
Where id = 4
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '5'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '5'
Select *
From jk0sx_emplacementvd
Where id = 5
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '6'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '6'
Select *
From jk0sx_emplacementvd
Where id = 6
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '7'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '7'
Select *
From jk0sx_emplacementvd
Where id = 7
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '8'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '8'
Select *
From jk0sx_emplacementvd
Where id = 8
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '9'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '9'
Select *
From jk0sx_emplacementvd
Where id = 9
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '10'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '10'
Select *
From jk0sx_emplacementvd
Where id = 10
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '11'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '11'
Select *
From jk0sx_emplacementvd
Where id = 11
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '12'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '12'
Select *
From jk0sx_emplacementvd
Where id = 12
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '13'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '13'
Select *
From jk0sx_emplacementvd
Where id = 13
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '14'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '14'
Select *
From jk0sx_emplacementvd
Where id = 14
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '15'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '15'
Select *
From jk0sx_emplacementvd
Where id = 15
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '16'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '16'
Select *
From jk0sx_emplacementvd
Where id = 16
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '17'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '17'
Select *
From jk0sx_emplacementvd
Where id = 17
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '18'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '18'
Select *
From jk0sx_emplacementvd
Where id = 18
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '19'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '19'
Select *
From jk0sx_emplacementvd
Where id = 19
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '20'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '20'
Select *
From jk0sx_emplacementvd
Where id = 20
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '21'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '21'
Select *
From jk0sx_emplacementvd
Where id = 21
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '22'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '22'
Select *
From jk0sx_emplacementvd
Where id = 22
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '23'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '23'
Select *
From jk0sx_emplacementvd
Where id = 23
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '24'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '24'
Select *
From jk0sx_emplacementvd
Where id = 24
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '25'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '25'
Select *
From jk0sx_emplacementvd
Where id = 25
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '26'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '26'
Select *
From jk0sx_emplacementvd
Where id = 26
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '27'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '27'
Select *
From jk0sx_emplacementvd
Where id = 27
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '28'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '28'
Select *
From jk0sx_emplacementvd
Where id = 28
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '29'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '29'
Select *
From jk0sx_emplacementvd
Where id = 29
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '30'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '30'
Select *
From jk0sx_emplacementvd
Where id = 30
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '31'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '31'
Select *
From jk0sx_emplacementvd
Where id = 31
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 9
And reference_id In ('65','66','67','68','69','70','71','72','73','74')
And published = 1
Order By ordering
Select
r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '32'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 7
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '7'
And record_id = '32'
Select *
From jk0sx_emplacementvd
Where id = 32
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 9
SET SESSION group_concat_max_len = 9999999
Select *
From jk0sx_contentbuilder_storages
Where id = 6
And published = 1
Order By `ordering`
Select *
From jk0sx_contentbuilder_storage_fields
Where storage_id = 6
And published = 1
Order By `ordering`
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '104'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '104'
Select *
From jk0sx_emplacementvg
Where id = 104
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '103'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '103'
Select *
From jk0sx_emplacementvg
Where id = 103
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '102'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '102'
Select *
From jk0sx_emplacementvg
Where id = 102
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '101'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '101'
Select *
From jk0sx_emplacementvg
Where id = 101
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '100'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '100'
Select *
From jk0sx_emplacementvg
Where id = 100
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '99'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '99'
Select *
From jk0sx_emplacementvg
Where id = 99
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '98'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '98'
Select *
From jk0sx_emplacementvg
Where id = 98
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '97'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '97'
Select *
From jk0sx_emplacementvg
Where id = 97
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '96'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '96'
Select *
From jk0sx_emplacementvg
Where id = 96
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '95'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '95'
Select *
From jk0sx_emplacementvg
Where id = 95
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '94'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '94'
Select *
From jk0sx_emplacementvg
Where id = 94
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '93'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '93'
Select *
From jk0sx_emplacementvg
Where id = 93
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '92'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '92'
Select *
From jk0sx_emplacementvg
Where id = 92
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '91'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '91'
Select *
From jk0sx_emplacementvg
Where id = 91
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '90'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '90'
Select *
From jk0sx_emplacementvg
Where id = 90
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '89'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '89'
Select *
From jk0sx_emplacementvg
Where id = 89
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '88'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '88'
Select *
From jk0sx_emplacementvg
Where id = 88
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
Where form_id = 8
And reference_id In ('56','57','58','59','60','61','62','63','64')
And published = 1
Order By ordering
Select
r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`,
joined_records.rating_sum / joined_records.rating_count As colRating,
joined_records.rating_count As colRatingCount,
joined_records.rating_sum As colRatingSum
From
jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
Where
r.id = '86'
And
joined_records.`type` = 'com_contentbuilder'
And ( joined_records.id is Null Or joined_records.id Is Not Null )
And
r.storage_id = 6
Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
Where `type` = 'com_contentbuilder'
And reference_id = '6'
And record_id = '86'
Select *
From jk0sx_emplacementvg
Where id = 86
Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
Where id = 8
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jk0sx_menu AS m
LEFT JOIN jk0sx_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
Select `type`, `reference_id`
From jk0sx_contentbuilder_forms
Where published = 1
SET SESSION group_concat_max_len = 9999999
Select *
From jk0sx_contentbuilder_storages
Where id = 4
And published = 1
Order By `ordering`
Select *
From jk0sx_contentbuilder_storage_fields
Where storage_id = 4
And published = 1
Order By `ordering`
Select r.id
From
vw_ReservationVD As r
Where r.id Not In (
Select record_id
From jk0sx_contentbuilder_records As cr
Where cr.`type` = 'com_contentbuilder'
And cr.reference_id = '4'
And cr.record_id = r.id
)
SET SESSION group_concat_max_len = 9999999
Select *
From jk0sx_contentbuilder_storages
Where id = 3
And published = 1
Order By `ordering`
Select *
From jk0sx_contentbuilder_storage_fields
Where storage_id = 3
And published = 1
Order By `ordering`
Select r.id
From
vw_Reservation As r
Where r.id Not In (
Select record_id
From jk0sx_contentbuilder_records As cr
Where cr.`type` = 'com_contentbuilder'
And cr.reference_id = '3'
And cr.record_id = r.id
)
SET SESSION group_concat_max_len = 9999999
Select *
From jk0sx_contentbuilder_storages
Where id = 7
And published = 1
Order By `ordering`
Select *
From jk0sx_contentbuilder_storage_fields
Where storage_id = 7
And published = 1
Order By `ordering`
Select r.id
From
jk0sx_emplacementvd As r
Where r.id Not In (
Select record_id
From jk0sx_contentbuilder_records As cr
Where cr.`type` = 'com_contentbuilder'
And cr.reference_id = '7'
And cr.record_id = r.id
)
SET SESSION group_concat_max_len = 9999999
Select *
From jk0sx_contentbuilder_storages
Where id = 6
And published = 1
Order By `ordering`
Select *
From jk0sx_contentbuilder_storage_fields
Where storage_id = 6
And published = 1
Order By `ordering`
Select r.id
From
jk0sx_emplacementvg As r
Where r.id Not In (
Select record_id
From jk0sx_contentbuilder_records As cr
Where cr.`type` = 'com_contentbuilder'
And cr.reference_id = '6'
And cr.record_id = r.id
)
Update jk0sx_contentbuilder_records
Set published = 1
Where is_future = 1
And publish_up <> '0000-00-00 00:00:00'
And publish_up <= '2019-02-22 02:21:31'
Update jk0sx_contentbuilder_records
Set published = 0
Where publish_down <> '0000-00-00 00:00:00'
And publish_down <= '2019-02-22 02:21:31'
SELECT extension_id AS id, element AS "option", params, enabled
FROM jk0sx_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT *
FROM jk0sx_languages
WHERE published=1
ORDER BY ordering ASC
SELECT id, home, template, s.params
FROM jk0sx_template_styles as s
LEFT JOIN jk0sx_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT a.rules
FROM jk0sx_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM jk0sx_assets AS a
LEFT JOIN jk0sx_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content' OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jk0sx_content AS a
LEFT JOIN jk0sx_categories AS c
ON c.id = a.catid
LEFT JOIN jk0sx_users AS ua
ON ua.id = a.created_by
LEFT JOIN jk0sx_users AS uam
ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jk0sx_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN jk0sx_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jk0sx_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jk0sx_categories AS cat JOIN jk0sx_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
INNER JOIN jk0sx_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-22 02:21:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-22 02:21:31')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY c.lft, fp.ordering, a.created DESC
LIMIT 0, 4
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jk0sx_content AS a
LEFT JOIN jk0sx_categories AS c
ON c.id = a.catid
LEFT JOIN jk0sx_users AS ua
ON ua.id = a.created_by
LEFT JOIN jk0sx_users AS uam
ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jk0sx_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN jk0sx_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jk0sx_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jk0sx_categories AS cat JOIN jk0sx_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
INNER JOIN jk0sx_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-22 02:21:31')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-22 02:21:31')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY c.lft, fp.ordering, a.created DESC
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jk0sx_categories as c
LEFT JOIN jk0sx_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jk0sx_categories AS cat JOIN jk0sx_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=10
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jk0sx_categories as c
LEFT JOIN jk0sx_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jk0sx_categories AS cat JOIN jk0sx_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=17
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jk0sx_categories as c
LEFT JOIN jk0sx_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jk0sx_categories AS cat JOIN jk0sx_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=12
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jk0sx_modules AS m
LEFT JOIN jk0sx_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jk0sx_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-02-22 02:21:31')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-22 02:21:31')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT *
FROM jk0sx_modules
WHERE published=1
ORDER BY id
;
UPDATE `jk0sx_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1550802091;s:18:\"session.timer.last\";i:1550802091;s:17:\"session.timer.now\";i:1550802091;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;s:1:\"1\";}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'
, `time` = '1550802091'
WHERE `session_id` = 'cfh63i2m1lmt6bvdldepeg98k2'
50 × Select metakey, metadesc, author, robots, rights, xreference
From jk0sx_contentbuilder_records
50 × Select Distinct `label`, reference_id
From jk0sx_contentbuilder_elements
50 × Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field
From jk0sx_contentbuilder_forms
32 × Select *
From jk0sx_emplacementvd
32 × Select r.`Code` As `col65Value`,r.`Libelle` As `col66Value`,r.`Date_Creation` As `col67Value`,r.`Date_Modification` As `col68Value`,r.`User_Creation` As `col69Value`,r.`User_Modification` As `col70Value`,r.`Code_Attenant` As `col71Value`,r.`Statut` As `col72Value`,r.`Statut_Dimanche` As `col73Value`,r.`Caution` As `col74Value`, joined_records.rating_sum / joined_records.rating_count As colRating, joined_records.rating_count As colRatingCount, joined_records.rating_sum As colRatingSum
From jk0sx_emplacementvd As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
18 × Select r.`Code` As `col56Value`,r.`Libelle` As `col57Value`,r.`Date_Creation` As `col58Value`,r.`Date_Modification` As `col59Value`,r.`User_Creation` As `col60Value`,r.`User_Modification` As `col61Value`,r.`Code_Attenant` As `col62Value`,r.`Statut` As `col63Value`,r.`Caution` As `col64Value`, joined_records.rating_sum / joined_records.rating_count As colRating, joined_records.rating_count As colRatingCount, joined_records.rating_sum As colRatingSum
From jk0sx_emplacementvg As r
Left Join jk0sx_contentbuilder_records As joined_records
On ( joined_records.`type` = 'com_contentbuilder'
And joined_records.record_id = r.id
And joined_records.reference_id = r.storage_id )
18 × Select *
From jk0sx_emplacementvg
6 × Select *
From jk0sx_contentbuilder_storage_fields
6 × Select *
From jk0sx_contentbuilder_storages
3 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jk0sx_categories as c
LEFT JOIN jk0sx_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jk0sx_categories AS cat JOIN jk0sx_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
3 × SELECT extension_id AS id, element AS "option", params, enabled
FROM jk0sx_extensions
2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jk0sx_content AS a
LEFT JOIN jk0sx_categories AS c
ON c.id = a.catid
LEFT JOIN jk0sx_users AS ua
ON ua.id = a.created_by
LEFT JOIN jk0sx_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jk0sx_contact_details AS contact
1 × SELECT *
FROM jk0sx_modules
1 × SELECT *
FROM jk0sx_languages
1 × SELECT id, home, template, s.params
FROM jk0sx_template_styles as s
LEFT JOIN jk0sx_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT b.rules
FROM jk0sx_assets AS a
LEFT JOIN jk0sx_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × Select r.id
From jk0sx_emplacementvg As r
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jk0sx_modules AS m
LEFT JOIN jk0sx_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jk0sx_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT a.rules
FROM jk0sx_assets AS a
1 × Select r.id
From vw_ReservationVD As r
1 × SELECT id, rules
FROM `jk0sx_viewlevels
1 × SELECT folder AS type, element AS name, params
FROM jk0sx_extensions
1 × Select form.id As form_id, form.act_as_registration, form.default_category, form.registration_name_field, form.registration_username_field, form.registration_email_field, form.registration_email_repeat_field, form.`last_update`, article.`article_id`, form.`title_field`, form.`create_articles`, form.`name`, form.`use_view_name_as_title`, form.`protect_upload_directory`, form.`reference_id`, records.`record_id`, form.`type`, form.`published_only`, form.`own_only`, form.`own_only_fe`, records.`last_update` As record_last_update, article.`last_update` As article_last_update
From jk0sx_contentbuilder_records As records
Left Join jk0sx_contentbuilder_forms As form
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id )
Left Join jk0sx_contentbuilder_articles As article
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id
And article.form_id = form.id
And article.record_id = records.record_id )
Left Join jk0sx_content As content
On ( form.`type` = records.`type`
And form.reference_id = records.reference_id
And article.article_id = content.id
And article.form_id = form.id
And article.record_id = records.record_id )
1 × SELECT `session_id`
FROM `jk0sx_session`
1 × SELECT `data`
FROM `jk0sx_session`
1 × Select r.id
From vw_Reservation As r
1 × Select `type`, `reference_id`
From jk0sx_contentbuilder_forms
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jk0sx_menu AS m
LEFT JOIN jk0sx_extensions AS e
ON m.component_id = e.extension_id
1 × Select r.id
From jk0sx_emplacementvd As r
6 ×
SET SESSION group_concat_max_len = 999999
1 × Update jk0sx_contentbuilder_records
Set published = 1
1 × UPDATE `jk0sx_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1550802091;s:18:\"session.timer.last\";i:1550802091;s:17:\"session.timer.now\";i:1550802091;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;s:1:\"1\";}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1550802091'
1 × Update jk0sx_contentbuilder_records
Set published = 0
1 × Update jk0sx_contentbuilder_articles As articles, jk0sx_content As content, jk0sx_contentbuilder_forms As forms, jk0sx_contentbuilder_records As records, jk0sx_contentbuilder_registered_users As cbusers, jk0sx_users As users
Set content.state = forms.auto_publish
1 × INSERT INTO `jk0sx_session` (`session_id`, `client_id`, `time`)
VALUES ('cfh63i2m1lmt6bvdldepeg98k2', 0, '1550802091'
1 × Update jk0sx_contentbuilder_articles As articles, jk0sx_content As content, jk0sx_contentbuilder_forms As forms, jk0sx_contentbuilder_registered_users As cbusers, jk0sx_users As users
Set content.state = 0
1 × DELETE
FROM `jk0sx_session`