Menu
type | calls | time (ms) | time (%) |
---|---|---|---|
Database (Doctrine) | 108 | 0.04 | 0 |
SET NAMES 'utf8mb4'
SELECT d.id AS d__id, d.name AS d__name, d.type AS d__type, d.params AS d__params, d.group_name AS d__group_name, d.credentials AS d__credentials, d2.id AS d2__id, d2.description AS d2__description, d2.value AS d2__value, d2.default_value AS d2__default_value, d2.lang AS d2__lang FROM dm_setting d LEFT JOIN dm_setting_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.name = '_header')
SELECT d.id AS d__id, d.ip AS d__ip, d.name AS d__name, d.ts AS d__ts, d.page AS d__page, d.country AS d__country, d.country_code AS d__country_code, d.city AS d__city, d.browser AS d__browser, d.dm_user AS d__dm_user FROM dm_who_is_online d WHERE (d.ip = '3.233.242.216' AND d.name = 'Guest')
UPDATE dm_who_is_online SET ts = '1731135791', page = 'https://dev.telltrail.com/dev.php/classified-categories' WHERE id = '790951'
DELETE FROM dm_who_is_online WHERE (ts < '1731135491')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d INNER JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d2.slug = 'classified-categories')
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE (c.id = '0')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.dm_layout_id AS d__dm_layout_id, d2.id AS d2__id, d2.name AS d2__name, d2.template AS d2__template, d2.css_class AS d2__css_class FROM dm_page_view d LEFT JOIN dm_layout d2 ON d.dm_layout_id = d2.id WHERE (d.module = 'classifiedCategories' AND d.action = 'list')
SELECT d.id AS d__id, d.dm_layout_id AS d__dm_layout_id, d.type AS d__type, d2.id AS d2__id, d2.width AS d2__width, d2.css_class AS d2__css_class, d3.id AS d3__id, d3.module AS d3__module, d3.action AS d3__action, d3.css_class AS d3__css_class, d4.id AS d4__id, d4.lang AS d4__lang, d4.value AS d4__value FROM dm_area d LEFT JOIN dm_zone d2 ON d.id = d2.dm_area_id LEFT JOIN dm_widget d3 ON d2.id = d3.dm_zone_id LEFT JOIN dm_widget_translation d4 ON d3.id = d4.id AND ((d4.lang = 'en' OR d4.lang = 'en')) WHERE (d.dm_layout_id = '4' OR d.dm_page_view_id = '12') ORDER BY d2.position asc, d3.position asc
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'root')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'register')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'dmUser' AND d.action = 'list')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'classifiedCategories' AND d.action = 'list')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'directoryList')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'socialEvent' AND d.action = 'list')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'blog' AND d.action = 'list')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'news' AND d.action = 'list')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'job' AND d.action = 'list')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'poll' AND d.action = 'list')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'forumCategory' AND d.action = 'list')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'adviceList')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'lostFound')
SELECT d.id AS d__id, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.lft < '1248' AND d.rgt > '1551') ORDER BY d.lft asc
SELECT c.id AS c__id FROM classified_cat c WHERE (c.root_id IN ('83'))
SELECT COUNT(*) AS num_results FROM (SELECT c.id FROM classified c LEFT JOIN dm_user d ON c.created_by = d.id LEFT JOIN retailer_account r ON d.id = r.dm_user_id LEFT JOIN charity_account c2 ON d.id = c2.dm_user_id WHERE c.privacy = '40' AND (c.circulation = '0' OR c.circulation = '10') AND (c.lifecycle_state IN ('done', 'published') AND (c.expiration_date IS NULL OR c.expiration_date > NOW())) AND c.deleted_at IS NULL AND (c.date_sold IS NULL OR (c.lifecycle_state = 'done' AND c.date_sold >= '2024-11-02 07:03:11')) AND c.classified_cat NOT IN ('83', '84', '85', '86', '87', '88') GROUP BY c.id) dctrn_count_query
SELECT c.id AS c__id, c.title AS c__title, c.extract AS c__extract, c.body AS c__body, c.ebay_url AS c__ebay_url, c.local_currency AS c__local_currency, c.price AS c__price, c.base_price AS c__base_price, c.classified_cat AS c__classified_cat, c.views AS c__views, c.bestoffer AS c__bestoffer, c.external_url AS c__external_url, c.date_sold AS c__date_sold, c.ebay_response AS c__ebay_response, c.created_by AS c__created_by, c.updated_by AS c__updated_by, c.comments_count AS c__comments_count, c.dm_taggable_denormalized_tags_cache_field AS c__dm_taggable_denormalized_tags_cache_field, c.deleted_at AS c__deleted_at, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.location_address AS c__location_address, c.location_latitude AS c__location_latitude, c.location_longitude AS c__location_longitude, c.location_type AS c__location_type, c.location_street_number AS c__location_street_number, c.location_route AS c__location_route, c.location_locality AS c__location_locality, c.location_country AS c__location_country, c.location_postal_code AS c__location_postal_code, c.location_postal_code_prefix AS c__location_postal_code_prefix, c.location_administrative_area_level_1 AS c__location_administrative_area_level_1, c.location_administrative_area_level_2 AS c__location_administrative_area_level_2, c.gold_members AS c__gold_members, c.privacy AS c__privacy, c.content_class_id AS c__content_class_id, c.lifecycle_state AS c__lifecycle_state, c.expiration_date AS c__expiration_date, c.date_published AS c__date_published, c.slug AS c__slug, c.version AS c__version, c.locality_country AS c__locality_country, c.locality_region AS c__locality_region, c.locality_city AS c__locality_city, c.locality_street AS c__locality_street, c.circulation AS c__circulation, c.followers_count AS c__followers_count, d.id AS d__id, d.username AS d__username, d.email AS d__email, d.algorithm AS d__algorithm, d.salt AS d__salt, d.password AS d__password, d.is_active AS d__is_active, d.is_super_admin AS d__is_super_admin, d.last_login AS d__last_login, d.forgot_password_code AS d__forgot_password_code, d.sca_address AS d__sca_address, d.notifications_read AS d__notifications_read, d.notifications_emailed AS d__notifications_emailed, d.points AS d__points, d.referrer AS d__referrer, d.image_folder AS d__image_folder, d.firstname AS d__firstname, d.lastname AS d__lastname, d.dob AS d__dob, d.gender AS d__gender, d.headline AS d__headline, d.description AS d__description, d.about AS d__about, d.hobbies AS d__hobbies, d.education AS d__education, d.employment AS d__employment, d.ethnicity AS d__ethnicity, d.smoker AS d__smoker, d.alcohol AS d__alcohol, d.build AS d__build, d.religion AS d__religion, d.marital_status AS d__marital_status, d.dependent_children AS d__dependent_children, d.want_children AS d__want_children, d.looking_for_min AS d__looking_for_min, d.looking_for_max AS d__looking_for_max, d.privacy_profile AS d__privacy_profile, d.privacy_profile_share_online AS d__privacy_profile_share_online, d.privacy_profile_share_age AS d__privacy_profile_share_age, d.privacy_profile_share_cover AS d__privacy_profile_share_cover, d.privacy_search_realname AS d__privacy_search_realname, d.privacy_search_email AS d__privacy_search_email, d.privacy_search_hobbies AS d__privacy_search_hobbies, d.privacy_accept_messages AS d__privacy_accept_messages, d.preferences_timeformat AS d__preferences_timeformat, d.currency AS d__currency, d.country AS d__country, d.notifications AS d__notifications, d.telltrail_update AS d__telltrail_update, d.coins AS d__coins, d.expire_date AS d__expire_date, d.rating AS d__rating, d.warning AS d__warning, d.suspended AS d__suspended, d.suspended_reason AS d__suspended_reason, d.membership AS d__membership, d.language AS d__language, d.referral AS d__referral, d.email_backup AS d__email_backup, d.security_question AS d__security_question, d.security_response AS d__security_response, d.phone AS d__phone, d.mobile AS d__mobile, d.notification_interval AS d__notification_interval, d.region AS d__region, d.town_city AS d__town_city, d.postcode AS d__postcode, d.street AS d__street, d.registration_code AS d__registration_code, d.password_changed AS d__password_changed, d.security_question_changed AS d__security_question_changed, d.is_in_quarantine AS d__is_in_quarantine, d.quarantine_start AS d__quarantine_start, d.quarantine_end AS d__quarantine_end, d.quarantine_time AS d__quarantine_time, d.nb_views AS d__nb_views, d.is_completed_activation AS d__is_completed_activation, d.last_activation_reminder_date AS d__last_activation_reminder_date, d.invitation_link_welcome_text AS d__invitation_link_welcome_text, d.invitation_email_welcome_text AS d__invitation_email_welcome_text, d.location_address_valid AS d__location_address_valid, d.invitation_email_message_text AS d__invitation_email_message_text, d.invitation_email_shortlink_text AS d__invitation_email_shortlink_text, d.created_at AS d__created_at, d.updated_at AS d__updated_at, d.location_address AS d__location_address, d.location_latitude AS d__location_latitude, d.location_longitude AS d__location_longitude, d.location_type AS d__location_type, d.location_street_number AS d__location_street_number, d.location_route AS d__location_route, d.location_locality AS d__location_locality, d.location_country AS d__location_country, d.location_postal_code AS d__location_postal_code, d.location_postal_code_prefix AS d__location_postal_code_prefix, d.location_administrative_area_level_1 AS d__location_administrative_area_level_1, d.location_administrative_area_level_2 AS d__location_administrative_area_level_2, d.dm_taggable_denormalized_tags_cache_field AS d__dm_taggable_denormalized_tags_cache_field, d.comments_count AS d__comments_count, d.followers_count AS d__followers_count, d.slug AS d__slug, r.id AS r__id, r.is_active AS r__is_active, r.status AS r__status, r.business_trading_name AS r__business_trading_name, r.house_building_no AS r__house_building_no, r.postcode AS r__postcode, r.town_city AS r__town_city, r.country AS r__country, r.vat_check_status AS r__vat_check_status, r.vat_number AS r__vat_number, r.vat_vies_response AS r__vat_vies_response, r.contact_name AS r__contact_name, r.contact_email AS r__contact_email, r.sponsor_promotional_code AS r__sponsor_promotional_code, r.sponsor_id AS r__sponsor_id, r.sponsor_notified AS r__sponsor_notified, r.sponsor_commission_fee AS r__sponsor_commission_fee, r.dm_user_id AS r__dm_user_id, r.admin_notes AS r__admin_notes, r.registration_code AS r__registration_code, r.official_company_name AS r__official_company_name, r.sub_building AS r__sub_building, r.street_name AS r__street_name, r.state_region AS r__state_region, r.primary_category_id AS r__primary_category_id, r.primary_category_goods AS r__primary_category_goods, r.primary_category_services AS r__primary_category_services, r.second_category_id AS r__second_category_id, r.second_category_goods AS r__second_category_goods, r.second_category_services AS r__second_category_services, r.third_category_id AS r__third_category_id, r.third_category_goods AS r__third_category_goods, r.third_category_services AS r__third_category_services, r.sd_show_full_address AS r__sd_show_full_address, r.sd_range_from_business_address AS r__sd_range_from_business_address, r.sd_range_from_business_m_km AS r__sd_range_from_business_m_km, r.sd_by_mail_email AS r__sd_by_mail_email, r.sd_chain AS r__sd_chain, r.headline AS r__headline, r.main_description AS r__main_description, r.company_logo_id AS r__company_logo_id, r.feedback_incentives_id AS r__feedback_incentives_id, r.supplier_recommendation_id AS r__supplier_recommendation_id, r.website AS r__website, r.sales_telephone AS r__sales_telephone, r.directory_status AS r__directory_status, r.directory_date_published AS r__directory_date_published, r.created_at AS r__created_at, r.updated_at AS r__updated_at, r.dm_taggable_denormalized_tags_cache_field AS r__dm_taggable_denormalized_tags_cache_field, r.location_address AS r__location_address, r.location_latitude AS r__location_latitude, r.location_longitude AS r__location_longitude, r.location_type AS r__location_type, r.location_street_number AS r__location_street_number, r.location_route AS r__location_route, r.location_locality AS r__location_locality, r.location_country AS r__location_country, r.location_postal_code AS r__location_postal_code, r.location_postal_code_prefix AS r__location_postal_code_prefix, r.location_administrative_area_level_1 AS r__location_administrative_area_level_1, r.location_administrative_area_level_2 AS r__location_administrative_area_level_2, c2.id AS c2__id, c2.is_active AS c2__is_active, c2.status AS c2__status, c2.dm_user_id AS c2__dm_user_id, c2.charity_name AS c2__charity_name, c2.official_name AS c2__official_name, c2.charity_number AS c2__charity_number, c2.website AS c2__website, c2.charity_logo_id AS c2__charity_logo_id, c2.primary_category_id AS c2__primary_category_id, c2.second_category_id AS c2__second_category_id, c2.third_category_id AS c2__third_category_id, c2.sd_show_full_address AS c2__sd_show_full_address, c2.sd_range_from_charity_address AS c2__sd_range_from_charity_address, c2.sd_range_from_charity_m_km AS c2__sd_range_from_charity_m_km, c2.sd_by_mail_email AS c2__sd_by_mail_email, c2.sd_chain AS c2__sd_chain, c2.headline AS c2__headline, c2.main_description AS c2__main_description, c2.house_building_no AS c2__house_building_no, c2.postcode AS c2__postcode, c2.town_city AS c2__town_city, c2.country AS c2__country, c2.sub_building AS c2__sub_building, c2.street_name AS c2__street_name, c2.state_region AS c2__state_region, c2.contact_name AS c2__contact_name, c2.directory_status AS c2__directory_status, c2.directory_date_published AS c2__directory_date_published, c2.created_at AS c2__created_at, c2.updated_at AS c2__updated_at, c2.dm_taggable_denormalized_tags_cache_field AS c2__dm_taggable_denormalized_tags_cache_field FROM classified c LEFT JOIN dm_user d ON c.created_by = d.id LEFT JOIN retailer_account r ON d.id = r.dm_user_id LEFT JOIN charity_account c2 ON d.id = c2.dm_user_id WHERE (c.privacy = '40' AND (c.circulation = '0' OR c.circulation = '10') AND (c.lifecycle_state IN ('done', 'published') AND (c.expiration_date IS NULL OR c.expiration_date > NOW())) AND c.deleted_at IS NULL AND (c.date_sold IS NULL OR (c.lifecycle_state = 'done' AND c.date_sold >= '2024-11-02 07:03:11')) AND c.classified_cat NOT IN ('83', '84', '85', '86', '87', '88')) ORDER BY c.date_published desc
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'classifiedForm')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'manageContent')
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE (c.lft = '1')
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '1' AND c.rgt < '14') AND c.level <= '1' AND c.root_id = '1') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '4' AND c.rgt < '7') AND c.level <= '2' AND c.root_id = '1') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '1' AND c.rgt < '10') AND c.level <= '1' AND c.root_id = '2') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '1' AND c.rgt < '120') AND c.level <= '1' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '2' AND c.rgt < '11') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '12' AND c.rgt < '37') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '13' AND c.rgt < '30') AND c.level <= '3' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '14' AND c.rgt < '19') AND c.level <= '4' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '20' AND c.rgt < '27') AND c.level <= '4' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '38' AND c.rgt < '45') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '46' AND c.rgt < '61') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '47' AND c.rgt < '56') AND c.level <= '3' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '64' AND c.rgt < '79') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '80' AND c.rgt < '87') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '92' AND c.rgt < '103') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '95' AND c.rgt < '100') AND c.level <= '3' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '104' AND c.rgt < '117') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '1' AND c.rgt < '20') AND c.level <= '1' AND c.root_id = '4') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '2' AND c.rgt < '17') AND c.level <= '2' AND c.root_id = '4') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '3' AND c.rgt < '12') AND c.level <= '3' AND c.root_id = '4') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '1' AND c.rgt < '4') AND c.level <= '1' AND c.root_id = '5') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE (c.lft = '1')
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '1' AND c.rgt < '14') AND c.level <= '1' AND c.root_id = '1') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '4' AND c.rgt < '7') AND c.level <= '2' AND c.root_id = '1') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '1' AND c.rgt < '10') AND c.level <= '1' AND c.root_id = '2') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '1' AND c.rgt < '120') AND c.level <= '1' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '2' AND c.rgt < '11') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '12' AND c.rgt < '37') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '13' AND c.rgt < '30') AND c.level <= '3' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '14' AND c.rgt < '19') AND c.level <= '4' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '20' AND c.rgt < '27') AND c.level <= '4' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '38' AND c.rgt < '45') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '46' AND c.rgt < '61') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '47' AND c.rgt < '56') AND c.level <= '3' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '64' AND c.rgt < '79') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '80' AND c.rgt < '87') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '92' AND c.rgt < '103') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '95' AND c.rgt < '100') AND c.level <= '3' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '104' AND c.rgt < '117') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '1' AND c.rgt < '20') AND c.level <= '1' AND c.root_id = '4') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '2' AND c.rgt < '17') AND c.level <= '2' AND c.root_id = '4') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '3' AND c.rgt < '12') AND c.level <= '3' AND c.root_id = '4') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '1' AND c.rgt < '4') AND c.level <= '1' AND c.root_id = '5') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'classifieds' AND d.action = 'show')
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE (c.lft = '1')
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '1' AND c.rgt < '14') AND c.level <= '1' AND c.root_id = '1') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '4' AND c.rgt < '7') AND c.level <= '2' AND c.root_id = '1') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '1' AND c.rgt < '10') AND c.level <= '1' AND c.root_id = '2') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '1' AND c.rgt < '120') AND c.level <= '1' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '2' AND c.rgt < '11') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '12' AND c.rgt < '37') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '13' AND c.rgt < '30') AND c.level <= '3' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '14' AND c.rgt < '19') AND c.level <= '4' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '20' AND c.rgt < '27') AND c.level <= '4' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '38' AND c.rgt < '45') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '46' AND c.rgt < '61') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '47' AND c.rgt < '56') AND c.level <= '3' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '64' AND c.rgt < '79') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '80' AND c.rgt < '87') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '92' AND c.rgt < '103') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '95' AND c.rgt < '100') AND c.level <= '3' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '104' AND c.rgt < '117') AND c.level <= '2' AND c.root_id = '3') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '1' AND c.rgt < '20') AND c.level <= '1' AND c.root_id = '4') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '2' AND c.rgt < '17') AND c.level <= '2' AND c.root_id = '4') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '3' AND c.rgt < '12') AND c.level <= '3' AND c.root_id = '4') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c WHERE ((c.lft > '1' AND c.rgt < '4') AND c.level <= '1' AND c.root_id = '5') ORDER BY c.lft asc
SELECT c.id AS c__id, c.title AS c__title, c.description AS c__description, c.is_active AS c__is_active, c.expire_at_days AS c__expire_at_days, c.deleted_at AS c__deleted_at, c.position AS c__position, c.slug AS c__slug, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level FROM classified_cat c
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'welcomeConsumer')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'aboutTelltrail')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'contactUs')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'faqs')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'termsAndConditions')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'privacyAndCookies')
SELECT d.id AS d__id, d.module AS d__module, d.action AS d__action, d.record_id AS d__record_id, d.credentials AS d__credentials, d.lft AS d__lft, d.rgt AS d__rgt, d.level AS d__level, d2.id AS d2__id, d2.slug AS d2__slug, d2.name AS d2__name, d2.title AS d2__title, d2.h1 AS d2__h1, d2.description AS d2__description, d2.keywords AS d2__keywords, d2.auto_mod AS d2__auto_mod, d2.is_active AS d2__is_active, d2.is_secure AS d2__is_secure, d2.is_indexable AS d2__is_indexable, d2.lang AS d2__lang FROM dm_page d LEFT JOIN dm_page_translation d2 ON ((d.id = d2.id AND d2.lang = 'en')) WHERE (d.module = 'main' AND d.action = 'fairUsage')