PageManagerPublic::__construct
PageBuilderPublic::__construct
Page::__construct
PageManagerPublic::displayPage
SELECT id_page FROM ga_page WHERE page_url="jcb"
SELECT COUNT(1) count FROM ga_page WHERE page_url="jcb" AND page_link="0"
SELECT id_page FROM ga_page WHERE page_link="71" AND page_url="liste-produits-occasion-jcb"
SELECT page_url FROM ga_page WHERE id_page="95"
Page::getPageStatic
SELECT * FROM ga_page WHERE page_url="liste-produits-occasion-jcb" AND page_type=""
Page::getCssPage
SELECT ga_file.file_name FROM ga_file, ga_file_page WHERE ga_file.id_file=ga_file_page.id_file AND ga_file_page.id_page="95" AND file_extension="css" ORDER BY ga_file_page.id_file_page
Page::getJsPage
SELECT ga_file.file_name FROM ga_file, ga_file_page WHERE ga_file.id_file=ga_file_page.id_file AND ga_file_page.id_page="95" AND file_extension="js" ORDER BY ga_file_page.id_file_page
Page::getRSSPage
SELECT rss_url,rss_description FROM ga_rss,ga_page_rss WHERE ga_page_rss.id_page='95' AND ga_page_rss.id_rss=ga_rss.id_rss ORDER BY ga_rss.id_rss
Récupération des requêtes supplémentaires.
SELECT ga_query.id_query, ga_query_asso.query_asso_order, ga_query.query_column, ga_query.query_table, ga_query.query_where, ga_query.query_group, ga_query.query_order, ga_query.query_left, ga_query.query_on, ga_query.query_list, ga_query.query_limit, ga_query.query_type, ga_query.query_log, ga_query.query_output_name, ga_fileprocess.fileprocess_name FROM ( ga_dataflow, ga_query, ga_query_asso) LEFT JOIN ga_fileprocess ON ga_dataflow.id_fileprocess=ga_fileprocess.id_fileprocess WHERE ga_dataflow.dataflow_name="liste-produits-occasion-jcb" AND ga_dataflow.id_dataflow=ga_query_asso.id_dataflow AND ga_query.id_query=ga_query_asso.id_query ORDER BY ga_query_asso.query_asso_order, ga_query.query_list
SELECT ma_categorie.page_url, ma_categorie.categorie_nom, ma_categorie.categorie_visuel, ma_categorie.id_marque, ma_categorie.categorie_catalogue, ma_categorie.id_categorie, ma_categorie.categorie_nom_marque FROM ma_categorie WHERE ma_categorie.id_marque="1" AND ma_categorie.categorie_catalogue="0" ORDER BY ma_categorie.page_name ASC
Appel d'un fichier de post-traitement : /action/process/dataflow/liste_produit_type_marque.php
SELECT DISTINCT(ma_modele.modele_intitule),id_modele
FROM ma_modele
LEFT JOIN ma_type ON ma_modele.id_type=ma_type.id_type
LEFT JOIN ma_categorie ON ma_modele.id_categorie=ma_modele.id_categorie
WHERE ma_categorie.page_url='agro-chargeuses' AND ma_modele.id_marque='1' ORDER BY modele_intitule
SELECT COUNT(id_produit), ma_marque.marque_url marque_url
FROM (ma_produit)
LEFT JOIN ma_modele ON ma_produit.id_modele=ma_modele.id_modele
LEFT JOIN ma_marque ON ma_modele.id_marque=ma_marque.id_marque
LEFT JOIN ma_type ON ma_modele.id_type=ma_type.id_type
LEFT JOIN ma_categorie ON ma_modele.id_categorie=ma_categorie.id_categorie
LEFT JOIN ma_agence ON ma_produit.id_agence=ma_agence.id_agence
WHERE ma_produit.produit_neuf='0' AND ma_categorie.page_url='agro-chargeuses' AND ma_marque.id_marque='1' ORDER BY ma_produit.id_produit DESC
SELECT ma_produit.page_url produit_url, ma_produit.page_title, ma_produit.id_produit, ma_produit.id_modele, ma_produit.produit_selection, ma_produit.produit_neuf, ma_produit.produit_etat, ma_produit.produit_prix_visible, ma_produit.produit_annee, ma_produit.produit_prix_vente, ma_produit.id_agence, ma_produit.produit_visuel1, ma_modele.id_modele, ma_modele.id_type, ma_modele.modele_intitule, ma_modele.modele_visuel1,ma_modele.modele_marque_autre, ma_type.id_type, ma_agence.agence_cp, ma_agence.agence_ville, ma_agence.id_agence, ma_modele.id_marque, ma_marque.id_marque, ma_marque.marque_name, ma_categorie.categorie_nom
FROM ( ma_produit)
LEFT JOIN ma_modele ON ma_produit.id_modele=ma_modele.id_modele
LEFT JOIN ma_marque ON ma_modele.id_marque=ma_marque.id_marque
LEFT JOIN ma_type ON ma_modele.id_type=ma_type.id_type
LEFT JOIN ma_categorie ON ma_modele.id_categorie=ma_categorie.id_categorie
LEFT JOIN ma_agence ON ma_produit.id_agence=ma_agence.id_agence
WHERE ma_produit.produit_neuf='0' AND ma_categorie.page_url='agro-chargeuses' AND ma_marque.id_marque='1' ORDER BY ma_produit.id_produit DESC LIMIT 6
PageBuilderPublic::headerHTML
PageBuilderPublic::headerTPL
PageBuilderPublic::footerTPL
PageBuilderPublic::footerHTML
SELECT config_value FROM ga_config WHERE config_label="project_debug"