La Lettre aux Agriculteurs du Parc n°28 est consacrée au développement de l'agriculture biologique avec notamment le bilan du premier programme d'actions et un retour sur quelques unes des opérations réalisées.
{ "__default": { "session": { "counter": 1, "timer": { "start": 1590674494, "last": 1590674494, "now": 1590674494 }, "client": { "forwarded": "18.204.227.117" } }, "registry": { "com_attachments": { "current_url": "&return=aHR0cHM6Ly93d3cucGFyYy1vcGFsZS5mci9kb2N1bWVudGhlcXVlLzQyNS92aWV3LzU0L2luZm9ybWF0aW9uLzQ5L2xhLWxldHRyZS1hdXgtYWdyaWN1bHRldXJzLW4tMjg%2F" } }, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 }, "plg_system_languagefilter": { "language": "fr-FR" }, "array": 1, "com_mailto": { "links": { "d3aad810cd3b59fbf938af5c15ff5b1e51e7f67d": { "link": "https:\/\/www.parc-opale.fr\/documentheque\/425\/view\/54\/information\/49\/la-lettre-aux-agriculteurs-n-28", "expiry": 1590674494 } } }, "ssmid": "0000ebd16d6f44d0dbcb1bed09105127", "38": "38" } }
SELECT `data` FROM `j3x_session` WHERE `session_id` = X'3030303065626431366436663434643064626362316265643039313035313237'
SELECT `session_id` FROM `j3x_session` WHERE `session_id` = X'3030303065626431366436663434643064626362316265643039313035313237' LIMIT 1
INSERT INTO `j3x_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3030303065626431366436663434643064626362316265643039313035313237', 1, 1590674494, 0, '', 0)
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `j3x_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
SELECT id, rules FROM `j3x_viewlevels`
SELECT b.id FROM j3x_usergroups AS a LEFT JOIN j3x_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM j3x_extensions WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering
SELECT `manifest_cache` FROM `j3x_extensions` WHERE `type` = 'component' AND `name` = 'com_admintools'
SELECT `value` FROM `j3x_admintools_storage` WHERE `key` = 'cparams'
SELECT * FROM j3x_languages WHERE published=1 ORDER BY ordering ASC
SELECT * FROM `j3x_admintools_wafexceptions` WHERE NOT(`option` LIKE 'com_%')
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 j3x_menu AS m LEFT JOIN j3x_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 id, home, template, s.params FROM j3x_template_styles as s LEFT JOIN j3x_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 `element`,`name`,`client_id`,`extension_id` FROM `j3x_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1
SHOW VARIABLES LIKE "collation_database"
SELECT `source`,`keepurlparams` FROM `j3x_admintools_redirects` WHERE ((`dest` = 'documentheque/425/view/54/information/49/la-lettre-aux-agriculteurs-n-28') OR (`dest` = 'documentheque/425/view/54/information/49/la-lettre-aux-agriculteurs-n-28') OR ('documentheque/425/view/54/information/49/la-lettre-aux-agriculteurs-n-28' LIKE `dest`)) AND `published` = '1' ORDER BY `ordering` DESC LIMIT 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `j3x_extensions` WHERE `type` = 'library' AND `element` = 'joomla'
UPDATE `j3x_extensions` SET `params` = '{\"mediaversion\":\"63c6bf26d30c8cdde32c9b661eceb771\"}' WHERE `type` = 'library' AND `element` = 'joomla'
SELECT title, lang_code, sef FROM j3x_booklibrary_languages
SELECT c.const, cl.value_const FROM j3x_booklibrary_const_languages as cl LEFT JOIN j3x_booklibrary_languages AS l ON cl.fk_languagesid=l.id LEFT JOIN j3x_booklibrary_const AS c ON cl.fk_constid=c.id WHERE l.lang_code = 'fr_FR'
SELECT l.lang_code FROM j3x_languages as l
SELECT c.name, c.id AS catid, c.parent_id FROM j3x_booklibrary_main_categories AS c WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' ) AND c.id = 54
SELECT b.title, c.id AS catid FROM j3x_booklibrary AS b LEFT JOIN j3x_booklibrary_categories AS bc ON b.id=bc.bookid LEFT JOIN j3x_booklibrary_main_categories AS c ON c.id=bc.catid WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' ) AND b.id=49 GROUP BY b.id
SELECT * FROM j3x_booklibrary_main_categories WHERE id='54'
SELECT * FROM j3x_booklibrary_main_categories WHERE section = 'com_booklibrary' AND published = 1
SELECT blc.name FROM j3x_booklibrary_main_categories AS blc WHERE blc.id = 54
UPDATE j3x_booklibrary SET featured_clicks = featured_clicks - 1 WHERE featured_clicks > 0 and id = 49
UPDATE j3x_booklibrary SET hits = hits + 1 WHERE id = 49
UPDATE j3x_booklibrary SET featured_shows = featured_shows - 1 WHERE featured_shows > 0
SHOW FULL COLUMNS FROM `j3x_booklibrary`
SELECT * FROM j3x_booklibrary WHERE `id` = '49'
SELECT src,type,youtube FROM j3x_booklibrary_video_source AS v LEFT JOIN j3x_booklibrary AS b ON v.fk_book_id=b.id WHERE v.fk_book_id =49
SELECT src,type FROM j3x_booklibrary_audio_source AS a LEFT JOIN j3x_booklibrary AS b ON a.fk_book_id=b.id WHERE a.fk_book_id =49
SELECT src,kind,scrlang,label FROM j3x_booklibrary_track_source AS t LEFT JOIN j3x_booklibrary AS b ON t.fk_book_id = b.id WHERE t.fk_book_id = 49
SELECT catid FROM j3x_booklibrary_categories WHERE bookid='49'
SELECT params FROM j3x_booklibrary_main_categories WHERE id IN (54)
SHOW FULL COLUMNS FROM `j3x_menu`
SELECT * FROM j3x_menu WHERE `id` = '425'
SELECT fk_userid FROM `j3x_booklibrary_users_favorits` WHERE fk_bookid =49
SELECT vm_id_product FROM j3x_booklibrary WHERE id=49
SELECT ROUND(avg(rating) ) FROM j3x_booklibrary_review WHERE fk_bookid = 49 group by fk_bookid
SELECT username FROM j3x_users WHERE id='585'
SELECT GROUP_CONCAT(a.authors_name SEPARATOR ', ') FROM j3x_booklibrary_authors as a LEFT JOIN j3x_booklibrary_authors_connect as ac on ac.fk_authorid=a.id LEFT JOIN j3x_booklibrary as b on b.id=ac.fk_bookid WHERE b.title ='La Lettre aux Agriculteurs n°28'
SELECT * FROM j3x_booklibrary_categories AS bc LEFT JOIN j3x_booklibrary_main_categories AS mc ON bc.catid=mc.id AND ( mc.params LIKE '%,-2' or mc.params = '-2' or mc.params LIKE '-2,%' or mc.params LIKE '%,-2,%' ) WHERE bc.bookid=49
SELECT title FROM j3x_booklibrary WHERE authors ='Parc naturel régional'
SELECT a.id, a.published, a.authors_name FROM j3x_booklibrary_authors AS a LEFT JOIN j3x_booklibrary_authors_connect AS ac ON ac.fk_authorid = a.id LEFT JOIN j3x_booklibrary AS b ON b.id = ac.fk_bookid WHERE b.title ='La Lettre aux Agriculteurs n°28'
SELECT * FROM j3x_booklibrary_main_categories WHERE id=54
select * from j3x_booklibrary_files AS s where s.fk_book_id=49 ORDER BY s.id
SELECT `id`,`name`,`rules`,`parent_id` FROM `j3x_assets` WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_attachments','com_banners','com_booklibrary','com_cache','com_categories','com_checkin','com_chronoconnectivity5','com_chronoforms5','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_installer','com_j2xml','com_jce','com_joomlaupdate','com_joomonitor','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_phocagallery','com_phocamaps','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slider','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM j3x_modules AS m LEFT JOIN j3x_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN j3x_extensions AS e ON e.element = m.module AND
