SHOW TABLES SELECT module,name,value FROM `allehoeren_settings` SELECT extension AS _key, extension as _value FROM allehoeren_extensions ORDER BY `_value` ASCSELECT id AS _key, content as _value FROM allehoeren_banned_hosts_ips_ranges ORDER BY `_value` ASC SELECT extension,modified FROM allehoeren_extensions WHERE extension LIKE "middleware.%" UNION SELECT extension,modified FROM allehoeren_extensions WHERE extension LIKE "system.%" UNION SELECT extension,modified FROM allehoeren_extensions WHERE extension = "classifieds" UNION SELECT extension,modified FROM allehoeren_extensionsDELETE FROM allehoeren_classifieds_classifieds_categories WHERE classifieds_id NOT IN ( SELECT id FROM allehoeren_classifieds ) OR classifieds_categories_id NOT IN ( SELECT id FROM allehoeren_classifieds_categories ) LIMIT 500SELECT type AS _key, type as _value FROM allehoeren_overview_content ORDER BY `_value` ASCSELECT * FROM allehoeren_settings WHERE `name` = "system.ecommerce/update/lastviewed" AND `module` = "" LIMIT 1SHOW COLUMNS FROM allehoeren_settings LIKE 'id' UPDATE allehoeren_settings SET `name` = 'system.ecommerce/update/lastviewed', `value` = '1', `module` = '' WHERE `name` = "system.ecommerce/update/lastviewed" AND `module` = "" ORDER BY `id` ASC SELECT province_name,code FROM allehoeren_countries_provinces p LEFT JOIN allehoeren_countries c ON p.countries_id = c.id; SELECT p.id AS id, province_name,code FROM allehoeren_countries_provinces p LEFT JOIN allehoeren_countries c ON p.countries_id = c.id; SELECT id,paid_options FROM `allehoeren_classifieds` WHERE top_ad_days <> 0 AND top_ad_timestamp IS NOT NULL AND top_ad_timestamp < CURRENT_DATE() - INTERVAL top_ad_days DAY ORDER BY `top_ad_timestamp` ASC LIMIT 0, 20SHOW COLUMNS FROM admin_websites LIKE 'websites_id'SELECT id AS _key, website as _value FROM admin_websites ORDER BY `_value` ASCSHOW COLUMNS FROM allehoeren_classifieds_categories LIKE 'sort_order'SELECT parent.id AS parent_id , child.id AS child_id,parent.name AS parent_name , child.name AS child_name,parent.url AS parent_url , child.url AS child_url,parent.sort_order AS parent_sort_order , child.sort_order AS child_sort_order FROM allehoeren_classifieds_categories AS parent LEFT JOIN allehoeren_classifieds_categories AS child ON parent.id = child.classifieds_categories_id ORDER BY parent.classifieds_categories_id, parent.sort_order, child.sort_orderSHOW COLUMNS FROM allehoeren_pages LIKE 'websites_id'SELECT id AS _key, url as _value FROM allehoeren_pages WHERE published = 1 ORDER BY `_value` ASCSELECT * FROM allehoeren_media WHERE shortcode = "favicon" LIMIT 1 UPDATE allehoeren_media SET `name` = 'Favicon', `shortcode` = 'favicon' WHERE shortcode = "favicon" ORDER BY `id` ASCSELECT * FROM allehoeren_media WHERE shortcode = "favicon" LIMIT 1SELECT * FROM allehoeren_pages WHERE url = "plaats/nieuwegein" AND published IN (1,2) LIMIT 1SHOW COLUMNS FROM allehoeren_overview_content LIKE 'websites_id' SELECT id,type,json FROM `allehoeren_overview_content` WHERE section = "overview" ORDER BY `sort_order` ASC SELECT * FROM allehoeren_cities WHERE url = "nieuwegein" LIMIT 1SHOW COLUMNS FROM allehoeren_classifieds LIKE 'websites_id' SELECT COUNT(*) AS count FROM `allehoeren_classifieds` WHERE active = 1 AND (`contact_city` = "Nieuwegein" OR `cities_id` = "2256") AND websites_id = 1 SELECT * FROM allehoeren_classifieds WHERE active = 1 AND (`contact_city` = "Nieuwegein" OR `cities_id` = "2256") ORDER BY top_ad_timestamp DESC, top_ad_days DESC, creation_timestamp DESC LIMIT 0, 68SELECT * FROM allehoeren_media WHERE shortcode = "logo" LIMIT 1SELECT * FROM allehoeren_content_blocks WHERE shortcode = "adultpage-footer-before" LIMIT 1
DELETE FROM allehoeren_logging WHERE timestamp < CURRENT_DATE() - INTERVAL 60 DAY ORDER BY timestamp LIMIT 1000TRUNCATE TABLE allehoeren_logging;SELECT * FROM allehoeren_settings WHERE `name` = "cms/cronjob/datetime" AND `module` = "" LIMIT 1 UPDATE allehoeren_settings SET `name` = 'cms/cronjob/datetime', `value` = '2025-11-10 08:24', `module` = '' WHERE `name` = "cms/cronjob/datetime" AND `module` = "" ORDER BY `id` ASCSHOW COLUMNS FROM allehoeren_jobs LIKE 'websites_id'SELECT title AS _key, interval_minutes as _value FROM allehoeren_jobs ORDER BY `_value` ASC