Skip to main content
You need to log in or register for storing your searches
Login
Login

Properties listing

1366 of 1366 Properties
J! InfoRequestSessionProfileQueries46Log
91.676MBMemory Usage5.06sRequest Duration
Joomla! Version5.1.2
PHP Version8.3.20
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
10.11.11-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:1 [ "start" => "150" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:46 [ "PHP_INI_SCAN_DIR" => "/etc/opt/remi/php83/php.d:/home/tharrald/public_html" "PATH" =...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744520953 "last" => 1744520953...
registry
array:3 [ "data" => array:1 [ "com_fwrealestate" => array:2 [ "currency" => 1 "mes...
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (71.1KB) (15.44ms)
  • afterInitialise (2.37MB) (104ms)
  • afterRoute (1.82MB) (44.94ms)
  • beforeRenderComponent com_fwrealestate (7.92KB) (2.36ms)
  • Before Access::preloadComponents (all components) (42.61MB) (2.54s)
  • After Access::preloadComponents (all components) (119.18KB) (1.4ms)
  • Before Access::getAssetRules (id:1 name:root.1) (104B) (24μs)
  • After Access::getAssetRules (id:1 name:root.1) (7.2KB) (327μs)
  • afterRenderComponent com_fwrealestate (29.72MB) (2.09s)
  • afterDispatch (19KB) (4.3ms)
  • beforeRenderRawModule mod_yootheme_builder (Property Search Display) (179.84KB) (25.16ms)
  • beforeRenderRawModule mod_fwre_search (Property Search) (63.47KB) (2.38ms)
  • afterRenderRawModule mod_fwre_search (Property Search) (172.07KB) (88.59ms)
  • beforeRenderModule mod_fwre_search (Property Search) (720B) (18μs)
  • afterRenderModule mod_fwre_search (Property Search) (4.09KB) (1.29ms)
  • afterRenderRawModule mod_yootheme_builder (Property Search Display) (169.41KB) (7.57ms)
  • beforeRenderModule mod_yootheme_builder (Property Search Display) (736B) (13μs)
  • afterRenderModule mod_yootheme_builder (Property Search Display) (2.48KB) (185μs)
  • beforeRenderRawModule mod_nspro (Mailing List Subscribe (Footer)) (144.62KB) (5.48ms)
  • afterRenderRawModule mod_nspro (Mailing List Subscribe (Footer)) (124.58KB) (3.66ms)
  • beforeRenderModule mod_nspro (Mailing List Subscribe (Footer)) (736B) (12μs)
  • afterRenderModule mod_nspro (Mailing List Subscribe (Footer)) (6.73KB) (297μs)
  • beforeRenderRawModule mod_custom () (13.41KB) (18.3ms)
  • afterRenderRawModule mod_custom () (40.01KB) (2.99ms)
  • beforeRenderModule mod_custom () (704B) (11μs)
  • afterRenderModule mod_custom () (1.81KB) (210μs)
  • beforeRenderRawModule mod_menu () (1.41KB) (421μs)
  • afterRenderRawModule mod_menu () (45.84KB) (2.68ms)
  • beforeRenderModule mod_menu () (696B) (9μs)
  • afterRenderModule mod_menu () (3.41KB) (197μs)
  • beforeRenderRawModule mod_custom () (1.28KB) (318μs)
  • afterRenderRawModule mod_custom () (944B) (390μs)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (3.06KB) (159μs)
  • beforeRenderRawModule mod_custom () (1.11KB) (299μs)
  • afterRenderRawModule mod_custom () (896B) (949μs)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (1.81KB) (159μs)
  • beforeRenderRawModule mod_custom () (2.61KB) (423μs)
  • afterRenderRawModule mod_custom () (896B) (963μs)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (1.81KB) (178μs)
  • beforeRenderRawModule mod_custom () (184B) (38μs)
  • afterRenderRawModule mod_custom () (816B) (329μs)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (1.81KB) (152μs)
  • beforeRenderRawModule mod_menu () (376B) (26μs)
  • afterRenderRawModule mod_menu () (2.27KB) (1.87ms)
  • beforeRenderModule mod_menu () (696B) (9μs)
  • afterRenderModule mod_menu () (1.81KB) (184μs)
  • beforeRenderRawModule mod_custom () (5.98KB) (1.14ms)
  • afterRenderRawModule mod_custom () (896B) (474μs)
  • beforeRenderModule mod_custom () (704B) (10μs)
  • afterRenderModule mod_custom () (2.94KB) (191μs)
  • beforeRenderRawModule mod_custom () (880B) (313μs)
  • afterRenderRawModule mod_custom () (896B) (393μs)
  • beforeRenderModule mod_custom () (704B) (14μs)
  • afterRenderModule mod_custom () (3.78KB) (257μs)
  • afterRender (5.47MB) (93.21ms)
  • 1 x Before Access::preloadComponents (all components) (42.61MB) (50.1%)
    2.54s
    1 x afterRenderComponent com_fwrealestate (29.72MB) (41.22%)
    2.09s
    1 x afterInitialise (2.37MB) (2.05%)
    104ms
    1 x afterRender (5.47MB) (1.84%)
    93.21ms
    1 x afterRenderRawModule mod_fwre_search (Property Search) (172.07KB) (1.75%)
    88.59ms
    1 x afterRoute (1.82MB) (0.89%)
    44.94ms
    1 x beforeRenderRawModule mod_yootheme_builder (Property Search Display) (179.84KB) (0.5%)
    25.16ms
    1 x beforeRenderRawModule mod_custom () (13.41KB) (0.36%)
    18.30ms
    1 x afterLoad (71.1KB) (0.3%)
    15.44ms
    1 x afterRenderRawModule mod_yootheme_builder (Property Search Display) (169.41KB) (0.15%)
    7.57ms
    1 x beforeRenderRawModule mod_nspro (Mailing List Subscribe (Footer)) (144.62KB) (0.11%)
    5.48ms
    1 x afterDispatch (19KB) (0.08%)
    4.30ms
    1 x afterRenderRawModule mod_nspro (Mailing List Subscribe (Footer)) (124.58KB) (0.07%)
    3.66ms
    1 x afterRenderRawModule mod_custom () (40.01KB) (0.06%)
    2.99ms
    4 x afterRenderRawModule mod_custom () (896B) (0.05%)
    2.78ms
    1 x afterRenderRawModule mod_menu () (45.84KB) (0.05%)
    2.68ms
    1 x beforeRenderRawModule mod_fwre_search (Property Search) (63.47KB) (0.05%)
    2.38ms
    1 x beforeRenderComponent com_fwrealestate (7.92KB) (0.05%)
    2.36ms
    1 x afterRenderRawModule mod_menu () (2.27KB) (0.04%)
    1.87ms
    1 x After Access::preloadComponents (all components) (119.18KB) (0.03%)
    1.40ms
    1 x afterRenderModule mod_fwre_search (Property Search) (4.09KB) (0.03%)
    1.29ms
    1 x beforeRenderRawModule mod_custom () (5.98KB) (0.02%)
    1.14ms
    4 x afterRenderModule mod_custom () (1.81KB) (0.01%)
    699μs
    1 x beforeRenderRawModule mod_custom () (2.61KB) (0.01%)
    423μs
    1 x beforeRenderRawModule mod_menu () (1.41KB) (0.01%)
    421μs
    1 x afterRenderRawModule mod_custom () (944B) (0.01%)
    390μs
    1 x afterRenderRawModule mod_custom () (816B) (0.01%)
    329μs
    1 x After Access::getAssetRules (id:1 name:root.1) (7.2KB) (0.01%)
    327μs
    1 x beforeRenderRawModule mod_custom () (1.28KB) (0.01%)
    318μs
    1 x beforeRenderRawModule mod_custom () (880B) (0.01%)
    313μs
    1 x beforeRenderRawModule mod_custom () (1.11KB) (0.01%)
    299μs
    1 x afterRenderModule mod_nspro (Mailing List Subscribe (Footer)) (6.73KB) (0.01%)
    297μs
    1 x afterRenderModule mod_custom () (3.78KB) (0.01%)
    257μs
    1 x afterRenderModule mod_menu () (3.41KB) (0%)
    197μs
    1 x afterRenderModule mod_custom () (2.94KB) (0%)
    191μs
    1 x afterRenderModule mod_yootheme_builder (Property Search Display) (2.48KB) (0%)
    185μs
    1 x afterRenderModule mod_menu () (1.81KB) (0%)
    184μs
    1 x afterRenderModule mod_custom () (3.06KB) (0%)
    159μs
    7 x beforeRenderModule mod_custom () (704B) (0%)
    71μs
    1 x beforeRenderRawModule mod_custom () (184B) (0%)
    38μs
    1 x beforeRenderRawModule mod_menu () (376B) (0%)
    26μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (104B) (0%)
    24μs
    1 x beforeRenderModule mod_fwre_search (Property Search) (720B) (0%)
    18μs
    2 x beforeRenderModule mod_menu () (696B) (0%)
    18μs
    1 x beforeRenderModule mod_yootheme_builder (Property Search Display) (736B) (0%)
    13μs
    1 x beforeRenderModule mod_nspro (Mailing List Subscribe (Footer)) (736B) (0%)
    12μs
46 statements were executed2.33s7.46MB
  • SELECT @@SESSION.sql_mode;176μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `jos3l_session` WHERE `session_id` = ?225μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `jos3l_session` WHERE `session_id` = :session_id LIMIT 1217μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jos3l_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)3.83ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos3l_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1296μs81.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos3l_viewlevels`231μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jos3l_usergroups` AS `a` LEFT JOIN `jos3l_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest123μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `jos3l_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`358μs133.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT custom_data FROM jos3l_extensions WHERE element = 'yooessentials' AND folder = 'system'171μs1.15KB/plugins/system/yooessentials/helper.php:152Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`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`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `jos3l_menu` AS `m` LEFT JOIN `jos3l_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`262μs19.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `jos3l_languages` WHERE `published` = 1 ORDER BY `ordering` ASC185μs1.59KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `jos3l_template_styles` AS `s` LEFT JOIN `jos3l_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` = 1159μs16.83KB/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT custom_data FROM jos3l_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1122μs536B/plugins/system/yooessentials/modules/core-joomla/src/Database.php:53Copy
  • SELECT DISTINCT t.*, (SELECT ttr.name FROM jos3l_fwre_currency_translation AS ttr WHERE ttr.currency_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS name, (SELECT ttr.name FROM jos3l_fwre_currency_translation AS ttr WHERE ttr.currency_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS eng, (SELECT ttr.name FROM jos3l_fwre_currency_translation AS ttr WHERE ttr.currency_id = t.id AND (ttr.lang <> '' AND ttr.lang IS NOT NULL) LIMIT 1) AS any FROM jos3l_fwre_currency AS t ORDER BY name, eng, any123μs960B/components/com_fwrealestate/helpers/helper.php:1490Copy
  • SELECT p.*, (SELECT g.image FROM jos3l_fwre_property_gallery AS g WHERE g.property_id = p.id AND g.gallery_type_id = 1 ORDER BY g.ordering, g.id LIMIT 1) AS _image, (SELECT g.alt FROM jos3l_fwre_property_gallery AS g WHERE g.property_id = p.id AND g.gallery_type_id = 1 ORDER BY g.ordering, g.id LIMIT 1) AS _image_alt, (SELECT COUNT(*) FROM jos3l_fwre_property_gallery AS g WHERE g.property_id = p.id AND g.gallery_type_id = 1) AS _images_qty, pt.street_direction AS _street_direction, (SELECT rt.street_direction FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _street_direction_eng_translation, (SELECT rt.street_direction FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.street_direction <> '' LIMIT 1) AS _street_direction_any_translation, pt.street_suffix AS _street_suffix, (SELECT rt.street_suffix FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _street_suffix_eng_translation, (SELECT rt.street_suffix FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.street_suffix <> '' LIMIT 1) AS _street_suffix_any_translation, pt.property_title AS _property_title, (SELECT rt.property_title FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _property_title_eng_translation, (SELECT rt.property_title FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.property_title <> '' LIMIT 1) AS _property_title_any_translation, pt.property_desc AS _property_desc, (SELECT rt.property_desc FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _property_desc_eng_translation, (SELECT rt.property_desc FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.property_desc <> '' LIMIT 1) AS _property_desc_any_translation, pt.address AS _address, (SELECT rt.address FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _address_eng_translation, (SELECT rt.address FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.address <> '' LIMIT 1) AS _address_any_translation, pt.price AS _price, (SELECT rt.price FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _price_eng_translation, (SELECT rt.price FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.price <> '' LIMIT 1) AS _price_any_translation, pcot.name AS _country_name, pret.name AS _region_name, pct.name AS _city_name, (SELECT name FROM jos3l_fwre_exterior_translation AS et WHERE et.exterior_id = p.exterior_id AND lang = 'en-GB' LIMIT 1) AS _exterior_name, (SELECT name FROM jos3l_fwre_garage_type_translation AS tt WHERE tt.garage_type_id = p.garage_type_id AND lang = 'en-GB' LIMIT 1) AS _garage_type_name , (SELECT COUNT(*) FROM jos3l_fwre_property_agent AS pa WHERE pa.property_id = p.id) AS _agents_exist, '' AS _agents, '' AS _customfields, (SELECT COUNT(*) FROM `jos3l_fwre_property_customfield` AS pc WHERE pc.property_id = p.id AND pc.lang = 'en-GB') AS _customfields_exist, pt.builder AS _builder, (SELECT rt.builder FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _builder_eng_translation, (SELECT rt.builder FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.builder <> '' LIMIT 1) AS _builder_any_translation, pt.subdivision AS _subdivision, (SELECT rt.subdivision FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _subdivision_eng_translation, (SELECT rt.subdivision FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.subdivision <> '' LIMIT 1) AS _subdivision_any_translation, pt.school_district AS _school_district, (SELECT rt.school_district FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _school_district_eng_translation, (SELECT rt.school_district FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.school_district <> '' LIMIT 1) AS _school_district_any_translation, pt.neighborhood AS _neighborhood, (SELECT rt.neighborhood FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _neighborhood_eng_translation, (SELECT rt.neighborhood FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.neighborhood <> '' LIMIT 1) AS _neighborhood_any_translation, (SELECT name FROM jos3l_fwre_attic_translation AS at WHERE at.attic_id = p.attic_id AND lang = 'en-GB' LIMIT 1) AS _attic_name, (SELECT name FROM jos3l_fwre_basement_translation AS bt WHERE bt.basement_id = p.basement_id AND lang = 'en-GB' LIMIT 1) AS _basement_name, (SELECT name FROM jos3l_fwre_scope_of_work_translation AS st WHERE st.scope_of_work_id = p.scope_of_work_id AND lang = 'en-GB' LIMIT 1) AS _scope_of_work_name , (SELECT COUNT(*) FROM jos3l_fwre_favorites AS f WHERE f.property_id = p.id AND f.user_id = 0) AS _is_favorite , (SELECT COUNT(*) FROM jos3l_fwre_property_rooms AS pr WHERE pr.property_id = p.id) AS _rooms_exists , pt.open_house AS _open_house, (SELECT rt.open_house FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _open_house_eng_translation, (SELECT rt.open_house FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.open_house <> '' LIMIT 1) AS _open_house_any_translation , pt.meta_descr AS _meta_descr, (SELECT rt.meta_descr FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _meta_descr_eng_translation, (SELECT rt.meta_descr FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.meta_descr <> '' LIMIT 1) AS _meta_descr_any_translation, pt.meta_keys AS _meta_keys, (SELECT rt.meta_keys FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.lang = 'en-GB' LIMIT 1) AS _meta_keys_eng_translation, (SELECT rt.meta_keys FROM jos3l_fwre_property_translation AS rt WHERE rt.property_id = p.id AND rt.meta_keys <> '' LIMIT 1) AS _meta_keys_any_translation , (SELECT name FROM jos3l_fwre_status_translation AS st WHERE st.status_id = p.status_id AND lang = 'en-GB' LIMIT 1) AS _status_name, (SELECT color FROM jos3l_fwre_status AS st WHERE st.id = p.status_id LIMIT 1) AS _status_color, (SELECT text_color FROM jos3l_fwre_status AS st WHERE st.id = p.status_id LIMIT 1) AS _status_text_color FROM jos3l_fwre_property AS p LEFT JOIN jos3l_fwre_property_translation AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND p.latitude IS NOT NULL AND p.longitude IS NOT NULL AND p.latitude <> 0 AND p.longitude <> 0 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1)) ORDER BY p.featured DESC, p.ordering1.86s3.26MB/components/com_fwrealestate/models/search.php:292Copy
  • SELECT c.*, '' AS _type_name, '' AS _position_name, 0 AS _position_ordering, '' AS _values, 0 AS _tab_ordering, (SELECT rt.name FROM `jos3l_fwre_customfield_translation` AS rt WHERE rt.customfield_id = c.id AND rt.lang = 'en-GB' LIMIT 1) AS _name, (SELECT rt.name FROM `jos3l_fwre_customfield_translation` AS rt WHERE rt.customfield_id = c.id AND rt.lang = 'en-GB' LIMIT 1) AS _name_eng_translation, (SELECT rt.name FROM `jos3l_fwre_customfield_translation` AS rt WHERE rt.customfield_id = c.id AND rt.name <> '' LIMIT 1) AS _name_any_translation FROM `jos3l_fwre_customfield` AS c LEFT JOIN `jos3l_fwre_group` AS g ON g.id = c.group_id LEFT JOIN `jos3l_fwre_tab` AS t ON t.id = g.tab_id WHERE ( g.published = 1 AND t.published = 1 ) OR c.group_id IN (0, 1, 2) OR g.tab_id IN (0, 1, 2) OR c.group_id IS NULL OR g.tab_id IS NULL ORDER BY c.ordering286μs1.89KB/plugins/fwrealestate/customfields/customfields.php:1388Copy
  • SELECT DISTINCT t.*, (SELECT ttr.name FROM jos3l_fwre_tab_translation AS ttr WHERE ttr.tab_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS name, (SELECT ttr.name FROM jos3l_fwre_tab_translation AS ttr WHERE ttr.tab_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS eng, (SELECT ttr.name FROM jos3l_fwre_tab_translation AS ttr WHERE ttr.tab_id = t.id AND (ttr.lang <> '' AND ttr.lang IS NOT NULL) LIMIT 1) AS any FROM jos3l_fwre_tab AS t ORDER BY ordering186μs2.05KB/components/com_fwrealestate/helpers/helper.php:1490Copy
  • SELECT DISTINCT t.*, (SELECT ttr.name FROM jos3l_fwre_group_translation AS ttr WHERE ttr.group_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS name, (SELECT ttr.name FROM jos3l_fwre_group_translation AS ttr WHERE ttr.group_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS eng, (SELECT ttr.name FROM jos3l_fwre_group_translation AS ttr WHERE ttr.group_id = t.id AND (ttr.lang <> '' AND ttr.lang IS NOT NULL) LIMIT 1) AS any FROM jos3l_fwre_group AS t ORDER BY ordering103μs880B/components/com_fwrealestate/helpers/helper.php:1490Copy
  • SELECT c.*, (SELECT rt.`text` FROM `jos3l_fwre_customfield_values_translation` AS rt WHERE rt.customfield_values_id = c.id AND rt.lang = 'en-GB' LIMIT 1) AS _name, (SELECT rt.`text` FROM `jos3l_fwre_customfield_values_translation` AS rt WHERE rt.customfield_values_id = c.id AND rt.lang = 'en-GB' LIMIT 1) AS _name_eng_translation, (SELECT rt.`text` FROM `jos3l_fwre_customfield_values_translation` AS rt WHERE rt.customfield_values_id = c.id AND rt.`text` <> '' LIMIT 1) AS _name_any_translation FROM `jos3l_fwre_customfield_values` AS c WHERE c.customfield_id IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14)87μs752B/plugins/fwrealestate/customfields/customfields.php:1421Copy
  • SELECT * FROM `jos3l_fwre_fields_access` WHERE property_id = 081μs1008B/components/com_fwrealestate/helpers/fwrealestatefields.php:164Copy
  • SELECT property_id, `key`, `access` AS property_access FROM `jos3l_fwre_fields_access` WHERE property_id IN (29278,29208,29156,30270,30269,30268,30267,30266,30265,30264,30263,30262,30261,30260,30259,30258,30257,30256,30255,30254,30253,30252,30251,30250,30249,30248,30247,30246,30245,30244,30243,30242,30241,30240,30239,30238,30237,30236,30235,30234,30233,30232,30231,30230,30229,30228,30227,30226,30225,30224,30223,30222,30221,30220,30219,30218,30217,30216,30215,30214,30213,30212,30211,30210,30209,30208,30207,30206,30205,30204,30203,30202,30201,30200,30199,30198,30197,30196,30195,30194,30193,30192,30191,30190,30189,30188,30187,30186,30185,30184,30183,30182,30181,30180,30179,30178,30177,30176,30175,30174,30173,30172,30171,30170,30169,30168,30167,30166,30165,30164,30163,30162,30161,30160,30159,30158,30157,30156,30155,30154,30153,30152,30151,30150,30149,30148,30147,30146,30145,30144,30143,30142,30141,30140,30139,30138,30137,30136,30135,30134,30133,30132,30131,30130,30129,30128,30127,30126,30125,30124,30123,30122,30121,30120,30119,30118,30117,30116,30115,30114,30113,30112,30111,30110,30109,30108,30107,30106,30105,30104,30103,30102,30101,30100,30099,30098,30097,30096,30095,30094,30093,30092,30091,30090,30089,30088,30087,30086,30085,30084,30083,30082,30081,30080,30079,30078,30077,30076,30075,30074,30073,30072,30071,30070,30069,30068,30067,30066,30065,30064,30063,30062,30061,30060,30059,30058,30057,30056,30055,30054,30053,30052,30051,30050,30049,30048,30047,30046,30045,30044,30043,30042,30041,30040,30039,30038,30037,30036,30035,30034,30033,30032,30031,30030,30029,30028,30027,30026,30025,30024,30023,30022,30021,30020,30019,30018,30017,30016,30015,30014,30013,30012,30011,30010,30009,30008,30007,30006,30005,30004,30003,30002,30001,30000,29999,29998,29997,29996,29995,29994,29993,29992,29991,29990,29989,29988,29987,29986,29985,29984,29983,29982,29981,29980,29979,29978,29977,29976,29975,29974,29973,29972,29971,29970,29969,29968,29967,29966,29965,29964,29963,29962,29961,29960,29959,29958,29957,29956,29955,29954,29953,29952,29951,29950,29949,29948,29947,29946,29945,29944,29943,29942,29941,29940,29939,29938,29937,29936,29935,29934,29933,29932,29931,29930,29929,29928,29927,29926,29925,29924,29923,29922,29921,29920,29919,29918,29917,29916,29915,29914,29913,29912,29911,29910,29909,29908,29907,29906,29905,29904,29903,29902,29901,29900,29899,29898,29897,29896,29895,29894,29893,29892,29891,29890,29889,29888,29887,29886,29885,29884,29883,29882,29881,29880,29879,29878,29877,29876,29875,29874,29873,29872,29871,29870,29869,29868,29867,29866,29865,29864,29863,29862,29861,29860,29859,29858,29857,29856,29855,29854,29853,29852,29851,29850,29849,29848,29847,29846,29845,29844,29843,29842,29841,29840,29839,29838,29837,29836,29835,29834,29833,29832,29831,29830,29829,29828,29827,29826,29825,29824,29823,29822,29821,29820,29819,29818,29817,29816,29815,29814,29813,29812,29811,29810,29809,29808,29807,29806,29805,29804,29803,29802,29801,29800,29799,29798,29797,29796,29795,29794,29793,29792,29791,29790,29789,29788,29787,29786,29785,29784,29783,29782,29781,29780,29779,29778,29777,29776,29775,29774,29773,29772,29771,29770,29769,29768,29767,29766,29765,29764,29763,29762,29761,29760,29759,29758,29757,29756,29755,29754,29753,29752,29751,29750,29749,29748,29747,29746,29745,29744,29743,29742,29741,29740,29739,29738,29737,29736,29735,29734,29733,29732,29731,29730,29729,29728,29727,29726,29725,29724,29723,29722,29721,29720,29719,29718,29717,29716,29715,29714,29713,29712,29711,29710,29709,29708,29707,29706,29705,29704,29703,29702,29701,29700,29699,29698,29697,29696,29695,29694,29693,29692,29691,29690,29689,29688,29687,29686,29685,29684,29683,29682,29681,29680,29679,29678,29677,29676,29675,29674,29673,29672,29671,29670,29669,29668,29667,29666,29665,29664,29663,29662,29661,29660,29659,29658,29657,29656,29655,29654,29653,29652,29651,29650,29649,29648,29647,29646,29645,29644,29643,29642,29641,29640,29639,29638,29637,29636,29635,29634,29633,29632,29631,29630,29629,29628,29627,29626,29625,29624,29623,29622,29621,29620,29619,29618,29617,29616,29615,29614,29613,29612,29611,29610,29609,29608,29607,29606,29605,29604,29603,29602,29601,29600,29599,29598,29597,29596,29595,29594,29593,29592,29591,29590,29589,29588,29587,29586,29585,29584,29583,29582,29581,29580,29579,29578,29577,29576,29575,29574,29573,29572,29571,29570,29569,29568,29567,29566,29565,29564,29563,29562,29561,29560,29559,29558,29557,29556,29555,29554,29553,29552,29551,29550,29549,29548,29547,29546,29545,29544,29543,29542,29541,29540,29539,29538,29537,29536,29535,29534,29533,29532,29531,29530,29529,29528,29527,29526,29525,29524,29523,29522,29521,29520,29519,29518,29517,29516,29515,29514,29513,29512,29511,29510,29509,29508,29507,29506,29505,29504,29503,29502,29501,29500,29499,29498,29497,29496,29495,29494,29493,29492,29491,29490,29489,29488,29487,29486,29485,29484,29483,29482,29481,29480,29479,29478,29477,29476,29475,29474,29473,29472,29471,29470,29469,29468,29467,29466,29465,29464,29463,29462,29461,29460,29459,29458,29457,29456,29455,29454,29453,29452,29451,29450,29449,29448,29447,29446,29445,29444,29443,29442,29441,29440,29439,29438,29437,29436,29435,29434,29433,29432,29431,29430,29429,29428,29427,29426,29425,29424,29423,29422,29421,29420,29419,29418,29417,29416,29415,29414,29413,29412,29411,29410,29409,29408,29407,29406,29405,29404,29403,29402,29401,29400,29399,29398,29397,29396,29395,29394,29393,29392,29391,29390,29389,29388,29387,29386,29385,29384,29383,29382,29381,29380,29379,29378,29377,29376,29375,29374,29373,29372,29371,29370,29369,29368,29367,29366,29365,29364,29363,29362,29361,29360,29359,29358,29357,29356,29355,29354,29353,29352,29351,29350,29349,29348,29347,29346,29345,29344,29343,29342,29341,29340,29339,29338,29337,29336,29335,29334,29333,29332,29331,29330,29329,29328,29327,29326,29325,29324,29323,29322,29321,29320,29319,29318,29317,29316,29315,29314,29313,29312,29311,29310,29309,29308,29307,29306,29305,29304,29303,29302,29301,29300,29299,29298,29297,29296,29295,29294,29293,29292,29291,29290,29289,29288,29287,29286,29285,29284,29283,29282,29281,29280,29279,29277,29276,29275,29274,29273,29272,29271,29270,29269,29268,29267,29266,29265,29264,29263,29262,29261,29260,29259,29258,29257,29256,29255,29254,29253,29252,29251,29250,29249,29248,29247,29246,29245,29244,29243,29242,29241,29240,29239,29238,29237,29236,29235,29234,29233,29232,29231,29230,29229,29228,29227,29226,29225,29224,29223,29222,29221,29220,29219,29218,29217,29216,29215,29214,29213,29212,29211,29210,29209,29207,29206,29205,29204,29203,29202,29201,29200,29199,29198,29197,29196,29195,29194,29193,29192,29191,29190,29189,29188,29187,29186,29185,29184,29183,29182,29181,29180,29179,29178,29177,29176,29175,29174,29173,29172,29171,29170,29169,29168,29167,29166,29165,29164,29163,29162,29161,29160,29159,29158,29157,29155,29154,29153,29152,29151,29150,29149,29148,29147,29146,29145,29144,29143,29142,29141,29140,29139,29138,29137,29136,29135,29134,29133,29132,29131,29130,29129,29128,29127,29126,29125,29124,29123,29122,29121,29120,29119,29118,29117,29116,29115,29114,29113,29112,29111,29110,29109,29108,29107,29106,29105,29104,29103,29102,29101,29100,29099,29098,29097,29096,29095,29094,29093,29092,29091,29090,29089,29088,29087,29086,29085,29084,29083,29082,29081,29080,29079,29078,29077,29076,29075,29074,29073,29072,29071,29070,29069,29068,29067,29066,29065,29064,29063,29062,29061,29060,29059,29058,29057,29056,29055,29054,29053,29052,29051,29050,29049,29048,29047,29046,29045,29044,29043,29042,29041,29040,29039,29038,29037,29036,29035,29034,29033,29032,29031,29030,29029,29028,29027,29026,29025,29024,29023,29022,29021,29020,29019,29018,29017,29016,29015,29014,29013,29012,29011,29010,29009,29008,29007,29006,29005,29004,29003,29002,29001,29000,28999,28998,28997,28996,28995,28994,28993,28992,28991,28990,28989,28988,28987,28986,28985,28984,28983,28982,28981,28980,28979,28978,28977,28976,28975,28974,28973,28972,28971,28970,28969,28968,28967,28966,28965,28964,28963,28962,28961,28960,28959,28958,28957,28956,28955,28954,28953,28952,28951,28950,28949,28948,28947,28946,28945,28944,28943,28942,28941,28940,28939,28938,28937,28936,28935,28934,28933,28932,28931,28930,28929,28928,28927,28926,28925,28924,28923,28922,28921,28920,28919,28918,28917,28916,28915,28914,28913,28912,28911,28910,28909,28908,28907,28906,28905)1.47ms640B/components/com_fwrealestate/helpers/fwrealestatefields.php:188Copy
  • SELECT property_id, `image` FROM `jos3l_fwre_property_gallery` WHERE property_id IN (29278,29208,29156,30270,30269,30268,30267,30266,30265,30264,30263,30262,30261,30260,30259,30258,30257,30256,30255,30254,30253,30252,30251,30250,30249,30248,30247,30246,30245,30244,30243,30242,30241,30240,30239,30238,30237,30236,30235,30234,30233,30232,30231,30230,30229,30228,30227,30226,30225,30224,30223,30222,30221,30220,30219,30218,30217,30216,30215,30214,30213,30212,30211,30210,30209,30208,30207,30206,30205,30204,30203,30202,30201,30200,30199,30198,30197,30196,30195,30194,30193,30192,30191,30190,30189,30188,30187,30186,30185,30184,30183,30182,30181,30180,30179,30178,30177,30176,30175,30174,30173,30172,30171,30170,30169,30168,30167,30166,30165,30164,30163,30162,30161,30160,30159,30158,30157,30156,30155,30154,30153,30152,30151,30150,30149,30148,30147,30146,30145,30144,30143,30142,30141,30140,30139,30138,30137,30136,30135,30134,30133,30132,30131,30130,30129,30128,30127,30126,30125,30124,30123,30122,30121,30120,30119,30118,30117,30116,30115,30114,30113,30112,30111,30110,30109,30108,30107,30106,30105,30104,30103,30102,30101,30100,30099,30098,30097,30096,30095,30094,30093,30092,30091,30090,30089,30088,30087,30086,30085,30084,30083,30082,30081,30080,30079,30078,30077,30076,30075,30074,30073,30072,30071,30070,30069,30068,30067,30066,30065,30064,30063,30062,30061,30060,30059,30058,30057,30056,30055,30054,30053,30052,30051,30050,30049,30048,30047,30046,30045,30044,30043,30042,30041,30040,30039,30038,30037,30036,30035,30034,30033,30032,30031,30030,30029,30028,30027,30026,30025,30024,30023,30022,30021,30020,30019,30018,30017,30016,30015,30014,30013,30012,30011,30010,30009,30008,30007,30006,30005,30004,30003,30002,30001,30000,29999,29998,29997,29996,29995,29994,29993,29992,29991,29990,29989,29988,29987,29986,29985,29984,29983,29982,29981,29980,29979,29978,29977,29976,29975,29974,29973,29972,29971,29970,29969,29968,29967,29966,29965,29964,29963,29962,29961,29960,29959,29958,29957,29956,29955,29954,29953,29952,29951,29950,29949,29948,29947,29946,29945,29944,29943,29942,29941,29940,29939,29938,29937,29936,29935,29934,29933,29932,29931,29930,29929,29928,29927,29926,29925,29924,29923,29922,29921,29920,29919,29918,29917,29916,29915,29914,29913,29912,29911,29910,29909,29908,29907,29906,29905,29904,29903,29902,29901,29900,29899,29898,29897,29896,29895,29894,29893,29892,29891,29890,29889,29888,29887,29886,29885,29884,29883,29882,29881,29880,29879,29878,29877,29876,29875,29874,29873,29872,29871,29870,29869,29868,29867,29866,29865,29864,29863,29862,29861,29860,29859,29858,29857,29856,29855,29854,29853,29852,29851,29850,29849,29848,29847,29846,29845,29844,29843,29842,29841,29840,29839,29838,29837,29836,29835,29834,29833,29832,29831,29830,29829,29828,29827,29826,29825,29824,29823,29822,29821,29820,29819,29818,29817,29816,29815,29814,29813,29812,29811,29810,29809,29808,29807,29806,29805,29804,29803,29802,29801,29800,29799,29798,29797,29796,29795,29794,29793,29792,29791,29790,29789,29788,29787,29786,29785,29784,29783,29782,29781,29780,29779,29778,29777,29776,29775,29774,29773,29772,29771,29770,29769,29768,29767,29766,29765,29764,29763,29762,29761,29760,29759,29758,29757,29756,29755,29754,29753,29752,29751,29750,29749,29748,29747,29746,29745,29744,29743,29742,29741,29740,29739,29738,29737,29736,29735,29734,29733,29732,29731,29730,29729,29728,29727,29726,29725,29724,29723,29722,29721,29720,29719,29718,29717,29716,29715,29714,29713,29712,29711,29710,29709,29708,29707,29706,29705,29704,29703,29702,29701,29700,29699,29698,29697,29696,29695,29694,29693,29692,29691,29690,29689,29688,29687,29686,29685,29684,29683,29682,29681,29680,29679,29678,29677,29676,29675,29674,29673,29672,29671,29670,29669,29668,29667,29666,29665,29664,29663,29662,29661,29660,29659,29658,29657,29656,29655,29654,29653,29652,29651,29650,29649,29648,29647,29646,29645,29644,29643,29642,29641,29640,29639,29638,29637,29636,29635,29634,29633,29632,29631,29630,29629,29628,29627,29626,29625,29624,29623,29622,29621,29620,29619,29618,29617,29616,29615,29614,29613,29612,29611,29610,29609,29608,29607,29606,29605,29604,29603,29602,29601,29600,29599,29598,29597,29596,29595,29594,29593,29592,29591,29590,29589,29588,29587,29586,29585,29584,29583,29582,29581,29580,29579,29578,29577,29576,29575,29574,29573,29572,29571,29570,29569,29568,29567,29566,29565,29564,29563,29562,29561,29560,29559,29558,29557,29556,29555,29554,29553,29552,29551,29550,29549,29548,29547,29546,29545,29544,29543,29542,29541,29540,29539,29538,29537,29536,29535,29534,29533,29532,29531,29530,29529,29528,29527,29526,29525,29524,29523,29522,29521,29520,29519,29518,29517,29516,29515,29514,29513,29512,29511,29510,29509,29508,29507,29506,29505,29504,29503,29502,29501,29500,29499,29498,29497,29496,29495,29494,29493,29492,29491,29490,29489,29488,29487,29486,29485,29484,29483,29482,29481,29480,29479,29478,29477,29476,29475,29474,29473,29472,29471,29470,29469,29468,29467,29466,29465,29464,29463,29462,29461,29460,29459,29458,29457,29456,29455,29454,29453,29452,29451,29450,29449,29448,29447,29446,29445,29444,29443,29442,29441,29440,29439,29438,29437,29436,29435,29434,29433,29432,29431,29430,29429,29428,29427,29426,29425,29424,29423,29422,29421,29420,29419,29418,29417,29416,29415,29414,29413,29412,29411,29410,29409,29408,29407,29406,29405,29404,29403,29402,29401,29400,29399,29398,29397,29396,29395,29394,29393,29392,29391,29390,29389,29388,29387,29386,29385,29384,29383,29382,29381,29380,29379,29378,29377,29376,29375,29374,29373,29372,29371,29370,29369,29368,29367,29366,29365,29364,29363,29362,29361,29360,29359,29358,29357,29356,29355,29354,29353,29352,29351,29350,29349,29348,29347,29346,29345,29344,29343,29342,29341,29340,29339,29338,29337,29336,29335,29334,29333,29332,29331,29330,29329,29328,29327,29326,29325,29324,29323,29322,29321,29320,29319,29318,29317,29316,29315,29314,29313,29312,29311,29310,29309,29308,29307,29306,29305,29304,29303,29302,29301,29300,29299,29298,29297,29296,29295,29294,29293,29292,29291,29290,29289,29288,29287,29286,29285,29284,29283,29282,29281,29280,29279,29277,29276,29275,29274,29273,29272,29271,29270,29269,29268,29267,29266,29265,29264,29263,29262,29261,29260,29259,29258,29257,29256,29255,29254,29253,29252,29251,29250,29249,29248,29247,29246,29245,29244,29243,29242,29241,29240,29239,29238,29237,29236,29235,29234,29233,29232,29231,29230,29229,29228,29227,29226,29225,29224,29223,29222,29221,29220,29219,29218,29217,29216,29215,29214,29213,29212,29211,29210,29209,29207,29206,29205,29204,29203,29202,29201,29200,29199,29198,29197,29196,29195,29194,29193,29192,29191,29190,29189,29188,29187,29186,29185,29184,29183,29182,29181,29180,29179,29178,29177,29176,29175,29174,29173,29172,29171,29170,29169,29168,29167,29166,29165,29164,29163,29162,29161,29160,29159,29158,29157,29155,29154,29153,29152,29151,29150,29149,29148,29147,29146,29145,29144,29143,29142,29141,29140,29139,29138,29137,29136,29135,29134,29133,29132,29131,29130,29129,29128,29127,29126,29125,29124,29123,29122,29121,29120,29119,29118,29117,29116,29115,29114,29113,29112,29111,29110,29109,29108,29107,29106,29105,29104,29103,29102,29101,29100,29099,29098,29097,29096,29095,29094,29093,29092,29091,29090,29089,29088,29087,29086,29085,29084,29083,29082,29081,29080,29079,29078,29077,29076,29075,29074,29073,29072,29071,29070,29069,29068,29067,29066,29065,29064,29063,29062,29061,29060,29059,29058,29057,29056,29055,29054,29053,29052,29051,29050,29049,29048,29047,29046,29045,29044,29043,29042,29041,29040,29039,29038,29037,29036,29035,29034,29033,29032,29031,29030,29029,29028,29027,29026,29025,29024,29023,29022,29021,29020,29019,29018,29017,29016,29015,29014,29013,29012,29011,29010,29009,29008,29007,29006,29005,29004,29003,29002,29001,29000,28999,28998,28997,28996,28995,28994,28993,28992,28991,28990,28989,28988,28987,28986,28985,28984,28983,28982,28981,28980,28979,28978,28977,28976,28975,28974,28973,28972,28971,28970,28969,28968,28967,28966,28965,28964,28963,28962,28961,28960,28959,28958,28957,28956,28955,28954,28953,28952,28951,28950,28949,28948,28947,28946,28945,28944,28943,28942,28941,28940,28939,28938,28937,28936,28935,28934,28933,28932,28931,28930,28929,28928,28927,28926,28925,28924,28923,28922,28921,28920,28919,28918,28917,28916,28915,28914,28913,28912,28911,28910,28909,28908,28907,28906,28905) ORDER BY ordering, id52.69ms2.11MB/components/com_fwrealestate/models/search.php:303Copy
  • SELECT DISTINCT property_id, name FROM `jos3l_fwre_property_categories` AS pc, `jos3l_fwre_category_translation` AS ct WHERE ct.category_id = pc.category_id AND ct.lang = 'en-GB' AND pc.property_id IN (29278,29208,29156,30270,30269,30268,30267,30266,30265,30264,30263,30262,30261,30260,30259,30258,30257,30256,30255,30254,30253,30252,30251,30250,30249,30248,30247,30246,30245,30244,30243,30242,30241,30240,30239,30238,30237,30236,30235,30234,30233,30232,30231,30230,30229,30228,30227,30226,30225,30224,30223,30222,30221,30220,30219,30218,30217,30216,30215,30214,30213,30212,30211,30210,30209,30208,30207,30206,30205,30204,30203,30202,30201,30200,30199,30198,30197,30196,30195,30194,30193,30192,30191,30190,30189,30188,30187,30186,30185,30184,30183,30182,30181,30180,30179,30178,30177,30176,30175,30174,30173,30172,30171,30170,30169,30168,30167,30166,30165,30164,30163,30162,30161,30160,30159,30158,30157,30156,30155,30154,30153,30152,30151,30150,30149,30148,30147,30146,30145,30144,30143,30142,30141,30140,30139,30138,30137,30136,30135,30134,30133,30132,30131,30130,30129,30128,30127,30126,30125,30124,30123,30122,30121,30120,30119,30118,30117,30116,30115,30114,30113,30112,30111,30110,30109,30108,30107,30106,30105,30104,30103,30102,30101,30100,30099,30098,30097,30096,30095,30094,30093,30092,30091,30090,30089,30088,30087,30086,30085,30084,30083,30082,30081,30080,30079,30078,30077,30076,30075,30074,30073,30072,30071,30070,30069,30068,30067,30066,30065,30064,30063,30062,30061,30060,30059,30058,30057,30056,30055,30054,30053,30052,30051,30050,30049,30048,30047,30046,30045,30044,30043,30042,30041,30040,30039,30038,30037,30036,30035,30034,30033,30032,30031,30030,30029,30028,30027,30026,30025,30024,30023,30022,30021,30020,30019,30018,30017,30016,30015,30014,30013,30012,30011,30010,30009,30008,30007,30006,30005,30004,30003,30002,30001,30000,29999,29998,29997,29996,29995,29994,29993,29992,29991,29990,29989,29988,29987,29986,29985,29984,29983,29982,29981,29980,29979,29978,29977,29976,29975,29974,29973,29972,29971,29970,29969,29968,29967,29966,29965,29964,29963,29962,29961,29960,29959,29958,29957,29956,29955,29954,29953,29952,29951,29950,29949,29948,29947,29946,29945,29944,29943,29942,29941,29940,29939,29938,29937,29936,29935,29934,29933,29932,29931,29930,29929,29928,29927,29926,29925,29924,29923,29922,29921,29920,29919,29918,29917,29916,29915,29914,29913,29912,29911,29910,29909,29908,29907,29906,29905,29904,29903,29902,29901,29900,29899,29898,29897,29896,29895,29894,29893,29892,29891,29890,29889,29888,29887,29886,29885,29884,29883,29882,29881,29880,29879,29878,29877,29876,29875,29874,29873,29872,29871,29870,29869,29868,29867,29866,29865,29864,29863,29862,29861,29860,29859,29858,29857,29856,29855,29854,29853,29852,29851,29850,29849,29848,29847,29846,29845,29844,29843,29842,29841,29840,29839,29838,29837,29836,29835,29834,29833,29832,29831,29830,29829,29828,29827,29826,29825,29824,29823,29822,29821,29820,29819,29818,29817,29816,29815,29814,29813,29812,29811,29810,29809,29808,29807,29806,29805,29804,29803,29802,29801,29800,29799,29798,29797,29796,29795,29794,29793,29792,29791,29790,29789,29788,29787,29786,29785,29784,29783,29782,29781,29780,29779,29778,29777,29776,29775,29774,29773,29772,29771,29770,29769,29768,29767,29766,29765,29764,29763,29762,29761,29760,29759,29758,29757,29756,29755,29754,29753,29752,29751,29750,29749,29748,29747,29746,29745,29744,29743,29742,29741,29740,29739,29738,29737,29736,29735,29734,29733,29732,29731,29730,29729,29728,29727,29726,29725,29724,29723,29722,29721,29720,29719,29718,29717,29716,29715,29714,29713,29712,29711,29710,29709,29708,29707,29706,29705,29704,29703,29702,29701,29700,29699,29698,29697,29696,29695,29694,29693,29692,29691,29690,29689,29688,29687,29686,29685,29684,29683,29682,29681,29680,29679,29678,29677,29676,29675,29674,29673,29672,29671,29670,29669,29668,29667,29666,29665,29664,29663,29662,29661,29660,29659,29658,29657,29656,29655,29654,29653,29652,29651,29650,29649,29648,29647,29646,29645,29644,29643,29642,29641,29640,29639,29638,29637,29636,29635,29634,29633,29632,29631,29630,29629,29628,29627,29626,29625,29624,29623,29622,29621,29620,29619,29618,29617,29616,29615,29614,29613,29612,29611,29610,29609,29608,29607,29606,29605,29604,29603,29602,29601,29600,29599,29598,29597,29596,29595,29594,29593,29592,29591,29590,29589,29588,29587,29586,29585,29584,29583,29582,29581,29580,29579,29578,29577,29576,29575,29574,29573,29572,29571,29570,29569,29568,29567,29566,29565,29564,29563,29562,29561,29560,29559,29558,29557,29556,29555,29554,29553,29552,29551,29550,29549,29548,29547,29546,29545,29544,29543,29542,29541,29540,29539,29538,29537,29536,29535,29534,29533,29532,29531,29530,29529,29528,29527,29526,29525,29524,29523,29522,29521,29520,29519,29518,29517,29516,29515,29514,29513,29512,29511,29510,29509,29508,29507,29506,29505,29504,29503,29502,29501,29500,29499,29498,29497,29496,29495,29494,29493,29492,29491,29490,29489,29488,29487,29486,29485,29484,29483,29482,29481,29480,29479,29478,29477,29476,29475,29474,29473,29472,29471,29470,29469,29468,29467,29466,29465,29464,29463,29462,29461,29460,29459,29458,29457,29456,29455,29454,29453,29452,29451,29450,29449,29448,29447,29446,29445,29444,29443,29442,29441,29440,29439,29438,29437,29436,29435,29434,29433,29432,29431,29430,29429,29428,29427,29426,29425,29424,29423,29422,29421,29420,29419,29418,29417,29416,29415,29414,29413,29412,29411,29410,29409,29408,29407,29406,29405,29404,29403,29402,29401,29400,29399,29398,29397,29396,29395,29394,29393,29392,29391,29390,29389,29388,29387,29386,29385,29384,29383,29382,29381,29380,29379,29378,29377,29376,29375,29374,29373,29372,29371,29370,29369,29368,29367,29366,29365,29364,29363,29362,29361,29360,29359,29358,29357,29356,29355,29354,29353,29352,29351,29350,29349,29348,29347,29346,29345,29344,29343,29342,29341,29340,29339,29338,29337,29336,29335,29334,29333,29332,29331,29330,29329,29328,29327,29326,29325,29324,29323,29322,29321,29320,29319,29318,29317,29316,29315,29314,29313,29312,29311,29310,29309,29308,29307,29306,29305,29304,29303,29302,29301,29300,29299,29298,29297,29296,29295,29294,29293,29292,29291,29290,29289,29288,29287,29286,29285,29284,29283,29282,29281,29280,29279,29277,29276,29275,29274,29273,29272,29271,29270,29269,29268,29267,29266,29265,29264,29263,29262,29261,29260,29259,29258,29257,29256,29255,29254,29253,29252,29251,29250,29249,29248,29247,29246,29245,29244,29243,29242,29241,29240,29239,29238,29237,29236,29235,29234,29233,29232,29231,29230,29229,29228,29227,29226,29225,29224,29223,29222,29221,29220,29219,29218,29217,29216,29215,29214,29213,29212,29211,29210,29209,29207,29206,29205,29204,29203,29202,29201,29200,29199,29198,29197,29196,29195,29194,29193,29192,29191,29190,29189,29188,29187,29186,29185,29184,29183,29182,29181,29180,29179,29178,29177,29176,29175,29174,29173,29172,29171,29170,29169,29168,29167,29166,29165,29164,29163,29162,29161,29160,29159,29158,29157,29155,29154,29153,29152,29151,29150,29149,29148,29147,29146,29145,29144,29143,29142,29141,29140,29139,29138,29137,29136,29135,29134,29133,29132,29131,29130,29129,29128,29127,29126,29125,29124,29123,29122,29121,29120,29119,29118,29117,29116,29115,29114,29113,29112,29111,29110,29109,29108,29107,29106,29105,29104,29103,29102,29101,29100,29099,29098,29097,29096,29095,29094,29093,29092,29091,29090,29089,29088,29087,29086,29085,29084,29083,29082,29081,29080,29079,29078,29077,29076,29075,29074,29073,29072,29071,29070,29069,29068,29067,29066,29065,29064,29063,29062,29061,29060,29059,29058,29057,29056,29055,29054,29053,29052,29051,29050,29049,29048,29047,29046,29045,29044,29043,29042,29041,29040,29039,29038,29037,29036,29035,29034,29033,29032,29031,29030,29029,29028,29027,29026,29025,29024,29023,29022,29021,29020,29019,29018,29017,29016,29015,29014,29013,29012,29011,29010,29009,29008,29007,29006,29005,29004,29003,29002,29001,29000,28999,28998,28997,28996,28995,28994,28993,28992,28991,28990,28989,28988,28987,28986,28985,28984,28983,28982,28981,28980,28979,28978,28977,28976,28975,28974,28973,28972,28971,28970,28969,28968,28967,28966,28965,28964,28963,28962,28961,28960,28959,28958,28957,28956,28955,28954,28953,28952,28951,28950,28949,28948,28947,28946,28945,28944,28943,28942,28941,28940,28939,28938,28937,28936,28935,28934,28933,28932,28931,28930,28929,28928,28927,28926,28925,28924,28923,28922,28921,28920,28919,28918,28917,28916,28915,28914,28913,28912,28911,28910,28909,28908,28907,28906,28905)4.06ms40.56KB/components/com_fwrealestate/models/search.php:310Copy
  • SELECT DISTINCT property_id, name FROM `jos3l_fwre_property_types` AS pc, `jos3l_fwre_property_type_translation` AS ct WHERE ct.property_type_id = pc.property_type_id AND ct.lang = 'en-GB' AND pc.property_id IN (29278,29208,29156,30270,30269,30268,30267,30266,30265,30264,30263,30262,30261,30260,30259,30258,30257,30256,30255,30254,30253,30252,30251,30250,30249,30248,30247,30246,30245,30244,30243,30242,30241,30240,30239,30238,30237,30236,30235,30234,30233,30232,30231,30230,30229,30228,30227,30226,30225,30224,30223,30222,30221,30220,30219,30218,30217,30216,30215,30214,30213,30212,30211,30210,30209,30208,30207,30206,30205,30204,30203,30202,30201,30200,30199,30198,30197,30196,30195,30194,30193,30192,30191,30190,30189,30188,30187,30186,30185,30184,30183,30182,30181,30180,30179,30178,30177,30176,30175,30174,30173,30172,30171,30170,30169,30168,30167,30166,30165,30164,30163,30162,30161,30160,30159,30158,30157,30156,30155,30154,30153,30152,30151,30150,30149,30148,30147,30146,30145,30144,30143,30142,30141,30140,30139,30138,30137,30136,30135,30134,30133,30132,30131,30130,30129,30128,30127,30126,30125,30124,30123,30122,30121,30120,30119,30118,30117,30116,30115,30114,30113,30112,30111,30110,30109,30108,30107,30106,30105,30104,30103,30102,30101,30100,30099,30098,30097,30096,30095,30094,30093,30092,30091,30090,30089,30088,30087,30086,30085,30084,30083,30082,30081,30080,30079,30078,30077,30076,30075,30074,30073,30072,30071,30070,30069,30068,30067,30066,30065,30064,30063,30062,30061,30060,30059,30058,30057,30056,30055,30054,30053,30052,30051,30050,30049,30048,30047,30046,30045,30044,30043,30042,30041,30040,30039,30038,30037,30036,30035,30034,30033,30032,30031,30030,30029,30028,30027,30026,30025,30024,30023,30022,30021,30020,30019,30018,30017,30016,30015,30014,30013,30012,30011,30010,30009,30008,30007,30006,30005,30004,30003,30002,30001,30000,29999,29998,29997,29996,29995,29994,29993,29992,29991,29990,29989,29988,29987,29986,29985,29984,29983,29982,29981,29980,29979,29978,29977,29976,29975,29974,29973,29972,29971,29970,29969,29968,29967,29966,29965,29964,29963,29962,29961,29960,29959,29958,29957,29956,29955,29954,29953,29952,29951,29950,29949,29948,29947,29946,29945,29944,29943,29942,29941,29940,29939,29938,29937,29936,29935,29934,29933,29932,29931,29930,29929,29928,29927,29926,29925,29924,29923,29922,29921,29920,29919,29918,29917,29916,29915,29914,29913,29912,29911,29910,29909,29908,29907,29906,29905,29904,29903,29902,29901,29900,29899,29898,29897,29896,29895,29894,29893,29892,29891,29890,29889,29888,29887,29886,29885,29884,29883,29882,29881,29880,29879,29878,29877,29876,29875,29874,29873,29872,29871,29870,29869,29868,29867,29866,29865,29864,29863,29862,29861,29860,29859,29858,29857,29856,29855,29854,29853,29852,29851,29850,29849,29848,29847,29846,29845,29844,29843,29842,29841,29840,29839,29838,29837,29836,29835,29834,29833,29832,29831,29830,29829,29828,29827,29826,29825,29824,29823,29822,29821,29820,29819,29818,29817,29816,29815,29814,29813,29812,29811,29810,29809,29808,29807,29806,29805,29804,29803,29802,29801,29800,29799,29798,29797,29796,29795,29794,29793,29792,29791,29790,29789,29788,29787,29786,29785,29784,29783,29782,29781,29780,29779,29778,29777,29776,29775,29774,29773,29772,29771,29770,29769,29768,29767,29766,29765,29764,29763,29762,29761,29760,29759,29758,29757,29756,29755,29754,29753,29752,29751,29750,29749,29748,29747,29746,29745,29744,29743,29742,29741,29740,29739,29738,29737,29736,29735,29734,29733,29732,29731,29730,29729,29728,29727,29726,29725,29724,29723,29722,29721,29720,29719,29718,29717,29716,29715,29714,29713,29712,29711,29710,29709,29708,29707,29706,29705,29704,29703,29702,29701,29700,29699,29698,29697,29696,29695,29694,29693,29692,29691,29690,29689,29688,29687,29686,29685,29684,29683,29682,29681,29680,29679,29678,29677,29676,29675,29674,29673,29672,29671,29670,29669,29668,29667,29666,29665,29664,29663,29662,29661,29660,29659,29658,29657,29656,29655,29654,29653,29652,29651,29650,29649,29648,29647,29646,29645,29644,29643,29642,29641,29640,29639,29638,29637,29636,29635,29634,29633,29632,29631,29630,29629,29628,29627,29626,29625,29624,29623,29622,29621,29620,29619,29618,29617,29616,29615,29614,29613,29612,29611,29610,29609,29608,29607,29606,29605,29604,29603,29602,29601,29600,29599,29598,29597,29596,29595,29594,29593,29592,29591,29590,29589,29588,29587,29586,29585,29584,29583,29582,29581,29580,29579,29578,29577,29576,29575,29574,29573,29572,29571,29570,29569,29568,29567,29566,29565,29564,29563,29562,29561,29560,29559,29558,29557,29556,29555,29554,29553,29552,29551,29550,29549,29548,29547,29546,29545,29544,29543,29542,29541,29540,29539,29538,29537,29536,29535,29534,29533,29532,29531,29530,29529,29528,29527,29526,29525,29524,29523,29522,29521,29520,29519,29518,29517,29516,29515,29514,29513,29512,29511,29510,29509,29508,29507,29506,29505,29504,29503,29502,29501,29500,29499,29498,29497,29496,29495,29494,29493,29492,29491,29490,29489,29488,29487,29486,29485,29484,29483,29482,29481,29480,29479,29478,29477,29476,29475,29474,29473,29472,29471,29470,29469,29468,29467,29466,29465,29464,29463,29462,29461,29460,29459,29458,29457,29456,29455,29454,29453,29452,29451,29450,29449,29448,29447,29446,29445,29444,29443,29442,29441,29440,29439,29438,29437,29436,29435,29434,29433,29432,29431,29430,29429,29428,29427,29426,29425,29424,29423,29422,29421,29420,29419,29418,29417,29416,29415,29414,29413,29412,29411,29410,29409,29408,29407,29406,29405,29404,29403,29402,29401,29400,29399,29398,29397,29396,29395,29394,29393,29392,29391,29390,29389,29388,29387,29386,29385,29384,29383,29382,29381,29380,29379,29378,29377,29376,29375,29374,29373,29372,29371,29370,29369,29368,29367,29366,29365,29364,29363,29362,29361,29360,29359,29358,29357,29356,29355,29354,29353,29352,29351,29350,29349,29348,29347,29346,29345,29344,29343,29342,29341,29340,29339,29338,29337,29336,29335,29334,29333,29332,29331,29330,29329,29328,29327,29326,29325,29324,29323,29322,29321,29320,29319,29318,29317,29316,29315,29314,29313,29312,29311,29310,29309,29308,29307,29306,29305,29304,29303,29302,29301,29300,29299,29298,29297,29296,29295,29294,29293,29292,29291,29290,29289,29288,29287,29286,29285,29284,29283,29282,29281,29280,29279,29277,29276,29275,29274,29273,29272,29271,29270,29269,29268,29267,29266,29265,29264,29263,29262,29261,29260,29259,29258,29257,29256,29255,29254,29253,29252,29251,29250,29249,29248,29247,29246,29245,29244,29243,29242,29241,29240,29239,29238,29237,29236,29235,29234,29233,29232,29231,29230,29229,29228,29227,29226,29225,29224,29223,29222,29221,29220,29219,29218,29217,29216,29215,29214,29213,29212,29211,29210,29209,29207,29206,29205,29204,29203,29202,29201,29200,29199,29198,29197,29196,29195,29194,29193,29192,29191,29190,29189,29188,29187,29186,29185,29184,29183,29182,29181,29180,29179,29178,29177,29176,29175,29174,29173,29172,29171,29170,29169,29168,29167,29166,29165,29164,29163,29162,29161,29160,29159,29158,29157,29155,29154,29153,29152,29151,29150,29149,29148,29147,29146,29145,29144,29143,29142,29141,29140,29139,29138,29137,29136,29135,29134,29133,29132,29131,29130,29129,29128,29127,29126,29125,29124,29123,29122,29121,29120,29119,29118,29117,29116,29115,29114,29113,29112,29111,29110,29109,29108,29107,29106,29105,29104,29103,29102,29101,29100,29099,29098,29097,29096,29095,29094,29093,29092,29091,29090,29089,29088,29087,29086,29085,29084,29083,29082,29081,29080,29079,29078,29077,29076,29075,29074,29073,29072,29071,29070,29069,29068,29067,29066,29065,29064,29063,29062,29061,29060,29059,29058,29057,29056,29055,29054,29053,29052,29051,29050,29049,29048,29047,29046,29045,29044,29043,29042,29041,29040,29039,29038,29037,29036,29035,29034,29033,29032,29031,29030,29029,29028,29027,29026,29025,29024,29023,29022,29021,29020,29019,29018,29017,29016,29015,29014,29013,29012,29011,29010,29009,29008,29007,29006,29005,29004,29003,29002,29001,29000,28999,28998,28997,28996,28995,28994,28993,28992,28991,28990,28989,28988,28987,28986,28985,28984,28983,28982,28981,28980,28979,28978,28977,28976,28975,28974,28973,28972,28971,28970,28969,28968,28967,28966,28965,28964,28963,28962,28961,28960,28959,28958,28957,28956,28955,28954,28953,28952,28951,28950,28949,28948,28947,28946,28945,28944,28943,28942,28941,28940,28939,28938,28937,28936,28935,28934,28933,28932,28931,28930,28929,28928,28927,28926,28925,28924,28923,28922,28921,28920,28919,28918,28917,28916,28915,28914,28913,28912,28911,28910,28909,28908,28907,28906,28905)26.96ms56.56KB/components/com_fwrealestate/models/search.php:317Copy
  • SELECT pa.property_id, up.*, u.name AS _system_user_name, u.email AS _user_email, (SELECT att.name FROM `jos3l_fwre_agent_title_translation` AS att WHERE att.lang = 'en-GB' AND att.agent_title_id = pa.agent_title_id LIMIT 1) AS _title, prt.name AS _user_name, (SELECT tt.name FROM `jos3l_fwre_profile_translation` AS tt WHERE tt.user_id = u.id AND tt.lang = 'en-GB' LIMIT 1) AS _user_name_eng_translation, (SELECT tt.name FROM `jos3l_fwre_profile_translation` AS tt WHERE tt.user_id = u.id LIMIT 1) AS _user_name_any_translation, prt.company AS _company_name, prt.address AS _address, prt.details AS _details FROM `jos3l_fwre_property_agent` AS pa, `jos3l_users` AS u LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = u.id LEFT JOIN `jos3l_fwre_profile_translation` AS prt ON prt.user_id = u.id AND prt.lang = 'en-GB' WHERE pa.property_id IN (29278,29208,29156,30270,30269,30268,30267,30266,30265,30264,30263,30262,30261,30260,30259,30258,30257,30256,30255,30254,30253,30252,30251,30250,30249,30248,30247,30246,30245,30244,30243,30242,30241,30240,30239,30238,30237,30236,30235,30234,30233,30232,30231,30230,30229,30228,30227,30226,30225,30224,30223,30222,30221,30220,30219,30218,30217,30216,30215,30214,30213,30212,30211,30210,30209,30208,30207,30206,30205,30204,30203,30202,30201,30200,30199,30198,30197,30196,30195,30194,30193,30192,30191,30190,30189,30188,30187,30186,30185,30184,30183,30182,30181,30180,30179,30178,30177,30176,30175,30174,30173,30172,30171,30170,30169,30168,30167,30166,30165,30164,30163,30162,30161,30160,30159,30158,30157,30156,30155,30154,30153,30152,30151,30150,30149,30148,30147,30146,30145,30144,30143,30142,30141,30140,30139,30138,30137,30136,30135,30134,30133,30132,30131,30130,30129,30128,30127,30126,30125,30124,30123,30122,30121,30120,30119,30118,30117,30116,30115,30114,30113,30112,30111,30110,30109,30108,30107,30106,30105,30104,30103,30102,30101,30100,30099,30098,30097,30096,30095,30094,30093,30092,30091,30090,30089,30088,30087,30086,30085,30084,30083,30082,30081,30080,30079,30078,30077,30076,30075,30074,30073,30072,30071,30070,30069,30068,30067,30066,30065,30064,30063,30062,30061,30060,30059,30058,30057,30056,30055,30054,30053,30052,30051,30050,30049,30048,30047,30046,30045,30044,30043,30042,30041,30040,30039,30038,30037,30036,30035,30034,30033,30032,30031,30030,30029,30028,30027,30026,30025,30024,30023,30022,30021,30020,30019,30018,30017,30016,30015,30014,30013,30012,30011,30010,30009,30008,30007,30006,30005,30004,30003,30002,30001,30000,29999,29998,29997,29996,29995,29994,29993,29992,29991,29990,29989,29988,29987,29986,29985,29984,29983,29982,29981,29980,29979,29978,29977,29976,29975,29974,29973,29972,29971,29970,29969,29968,29967,29966,29965,29964,29963,29962,29961,29960,29959,29958,29957,29956,29955,29954,29953,29952,29951,29950,29949,29948,29947,29946,29945,29944,29943,29942,29941,29940,29939,29938,29937,29936,29935,29934,29933,29932,29931,29930,29929,29928,29927,29926,29925,29924,29923,29922,29921,29920,29919,29918,29917,29916,29915,29914,29913,29912,29911,29910,29909,29908,29907,29906,29905,29904,29903,29902,29901,29900,29899,29898,29897,29896,29895,29894,29893,29892,29891,29890,29889,29888,29887,29886,29885,29884,29883,29882,29881,29880,29879,29878,29877,29876,29875,29874,29873,29872,29871,29870,29869,29868,29867,29866,29865,29864,29863,29862,29861,29860,29859,29858,29857,29856,29855,29854,29853,29852,29851,29850,29849,29848,29847,29846,29845,29844,29843,29842,29841,29840,29839,29838,29837,29836,29835,29834,29833,29832,29831,29830,29829,29828,29827,29826,29825,29824,29823,29822,29821,29820,29819,29818,29817,29816,29815,29814,29813,29812,29811,29810,29809,29808,29807,29806,29805,29804,29803,29802,29801,29800,29799,29798,29797,29796,29795,29794,29793,29792,29791,29790,29789,29788,29787,29786,29785,29784,29783,29782,29781,29780,29779,29778,29777,29776,29775,29774,29773,29772,29771,29770,29769,29768,29767,29766,29765,29764,29763,29762,29761,29760,29759,29758,29757,29756,29755,29754,29753,29752,29751,29750,29749,29748,29747,29746,29745,29744,29743,29742,29741,29740,29739,29738,29737,29736,29735,29734,29733,29732,29731,29730,29729,29728,29727,29726,29725,29724,29723,29722,29721,29720,29719,29718,29717,29716,29715,29714,29713,29712,29711,29710,29709,29708,29707,29706,29705,29704,29703,29702,29701,29700,29699,29698,29697,29696,29695,29694,29693,29692,29691,29690,29689,29688,29687,29686,29685,29684,29683,29682,29681,29680,29679,29678,29677,29676,29675,29674,29673,29672,29671,29670,29669,29668,29667,29666,29665,29664,29663,29662,29661,29660,29659,29658,29657,29656,29655,29654,29653,29652,29651,29650,29649,29648,29647,29646,29645,29644,29643,29642,29641,29640,29639,29638,29637,29636,29635,29634,29633,29632,29631,29630,29629,29628,29627,29626,29625,29624,29623,29622,29621,29620,29619,29618,29617,29616,29615,29614,29613,29612,29611,29610,29609,29608,29607,29606,29605,29604,29603,29602,29601,29600,29599,29598,29597,29596,29595,29594,29593,29592,29591,29590,29589,29588,29587,29586,29585,29584,29583,29582,29581,29580,29579,29578,29577,29576,29575,29574,29573,29572,29571,29570,29569,29568,29567,29566,29565,29564,29563,29562,29561,29560,29559,29558,29557,29556,29555,29554,29553,29552,29551,29550,29549,29548,29547,29546,29545,29544,29543,29542,29541,29540,29539,29538,29537,29536,29535,29534,29533,29532,29531,29530,29529,29528,29527,29526,29525,29524,29523,29522,29521,29520,29519,29518,29517,29516,29515,29514,29513,29512,29511,29510,29509,29508,29507,29506,29505,29504,29503,29502,29501,29500,29499,29498,29497,29496,29495,29494,29493,29492,29491,29490,29489,29488,29487,29486,29485,29484,29483,29482,29481,29480,29479,29478,29477,29476,29475,29474,29473,29472,29471,29470,29469,29468,29467,29466,29465,29464,29463,29462,29461,29460,29459,29458,29457,29456,29455,29454,29453,29452,29451,29450,29449,29448,29447,29446,29445,29444,29443,29442,29441,29440,29439,29438,29437,29436,29435,29434,29433,29432,29431,29430,29429,29428,29427,29426,29425,29424,29423,29422,29421,29420,29419,29418,29417,29416,29415,29414,29413,29412,29411,29410,29409,29408,29407,29406,29405,29404,29403,29402,29401,29400,29399,29398,29397,29396,29395,29394,29393,29392,29391,29390,29389,29388,29387,29386,29385,29384,29383,29382,29381,29380,29379,29378,29377,29376,29375,29374,29373,29372,29371,29370,29369,29368,29367,29366,29365,29364,29363,29362,29361,29360,29359,29358,29357,29356,29355,29354,29353,29352,29351,29350,29349,29348,29347,29346,29345,29344,29343,29342,29341,29340,29339,29338,29337,29336,29335,29334,29333,29332,29331,29330,29329,29328,29327,29326,29325,29324,29323,29322,29321,29320,29319,29318,29317,29316,29315,29314,29313,29312,29311,29310,29309,29308,29307,29306,29305,29304,29303,29302,29301,29300,29299,29298,29297,29296,29295,29294,29293,29292,29291,29290,29289,29288,29287,29286,29285,29284,29283,29282,29281,29280,29279,29277,29276,29275,29274,29273,29272,29271,29270,29269,29268,29267,29266,29265,29264,29263,29262,29261,29260,29259,29258,29257,29256,29255,29254,29253,29252,29251,29250,29249,29248,29247,29246,29245,29244,29243,29242,29241,29240,29239,29238,29237,29236,29235,29234,29233,29232,29231,29230,29229,29228,29227,29226,29225,29224,29223,29222,29221,29220,29219,29218,29217,29216,29215,29214,29213,29212,29211,29210,29209,29207,29206,29205,29204,29203,29202,29201,29200,29199,29198,29197,29196,29195,29194,29193,29192,29191,29190,29189,29188,29187,29186,29185,29184,29183,29182,29181,29180,29179,29178,29177,29176,29175,29174,29173,29172,29171,29170,29169,29168,29167,29166,29165,29164,29163,29162,29161,29160,29159,29158,29157,29155,29154,29153,29152,29151,29150,29149,29148,29147,29146,29145,29144,29143,29142,29141,29140,29139,29138,29137,29136,29135,29134,29133,29132,29131,29130,29129,29128,29127,29126,29125,29124,29123,29122,29121,29120,29119,29118,29117,29116,29115,29114,29113,29112,29111,29110,29109,29108,29107,29106,29105,29104,29103,29102,29101,29100,29099,29098,29097,29096,29095,29094,29093,29092,29091,29090,29089,29088,29087,29086,29085,29084,29083,29082,29081,29080,29079,29078,29077,29076,29075,29074,29073,29072,29071,29070,29069,29068,29067,29066,29065,29064,29063,29062,29061,29060,29059,29058,29057,29056,29055,29054,29053,29052,29051,29050,29049,29048,29047,29046,29045,29044,29043,29042,29041,29040,29039,29038,29037,29036,29035,29034,29033,29032,29031,29030,29029,29028,29027,29026,29025,29024,29023,29022,29021,29020,29019,29018,29017,29016,29015,29014,29013,29012,29011,29010,29009,29008,29007,29006,29005,29004,29003,29002,29001,29000,28999,28998,28997,28996,28995,28994,28993,28992,28991,28990,28989,28988,28987,28986,28985,28984,28983,28982,28981,28980,28979,28978,28977,28976,28975,28974,28973,28972,28971,28970,28969,28968,28967,28966,28965,28964,28963,28962,28961,28960,28959,28958,28957,28956,28955,28954,28953,28952,28951,28950,28949,28948,28947,28946,28945,28944,28943,28942,28941,28940,28939,28938,28937,28936,28935,28934,28933,28932,28931,28930,28929,28928,28927,28926,28925,28924,28923,28922,28921,28920,28919,28918,28917,28916,28915,28914,28913,28912,28911,28910,28909,28908,28907,28906,28905) AND u.id = pa.user_id ORDER BY pa.ordering1.26ms2.73KB/plugins/fwrealestate/agents/agents.php:978Copy
  • SELECT cf.*, c.group_id, (SELECT rt.name FROM `jos3l_fwre_customfield_translation` AS rt WHERE rt.customfield_id = c.id AND rt.lang = 'en-GB' LIMIT 1) AS _name, (SELECT rt.name FROM `jos3l_fwre_customfield_translation` AS rt WHERE rt.customfield_id = c.id AND rt.lang = 'en-GB' LIMIT 1) AS _name_eng_translation, (SELECT rt.name FROM `jos3l_fwre_customfield_translation` AS rt WHERE rt.customfield_id = c.id AND rt.name <> '' LIMIT 1) AS _name_any_translation, CONCAT('customfields.', c.`alias`) AS `key` FROM `jos3l_fwre_property_customfield` AS cf, `jos3l_fwre_customfield` AS c WHERE c.id = cf.customfield_id AND cf.`lang` = 'en-GB' AND cf.property_id IN (29278,29208,29156,30270,30269,30268,30267,30266,30265,30264,30263,30262,30261,30260,30259,30258,30257,30256,30255,30254,30253,30252,30251,30250,30249,30248,30247,30246,30245,30244,30243,30242,30241,30240,30239,30238,30237,30236,30235,30234,30233,30232,30231,30230,30229,30228,30227,30226,30225,30224,30223,30222,30221,30220,30219,30218,30217,30216,30215,30214,30213,30212,30211,30210,30209,30208,30207,30206,30205,30204,30203,30202,30201,30200,30199,30198,30197,30196,30195,30194,30193,30192,30191,30190,30189,30188,30187,30186,30185,30184,30183,30182,30181,30180,30179,30178,30177,30176,30175,30174,30173,30172,30171,30170,30169,30168,30167,30166,30165,30164,30163,30162,30161,30160,30159,30158,30157,30156,30155,30154,30153,30152,30151,30150,30149,30148,30147,30146,30145,30144,30143,30142,30141,30140,30139,30138,30137,30136,30135,30134,30133,30132,30131,30130,30129,30128,30127,30126,30125,30124,30123,30122,30121,30120,30119,30118,30117,30116,30115,30114,30113,30112,30111,30110,30109,30108,30107,30106,30105,30104,30103,30102,30101,30100,30099,30098,30097,30096,30095,30094,30093,30092,30091,30090,30089,30088,30087,30086,30085,30084,30083,30082,30081,30080,30079,30078,30077,30076,30075,30074,30073,30072,30071,30070,30069,30068,30067,30066,30065,30064,30063,30062,30061,30060,30059,30058,30057,30056,30055,30054,30053,30052,30051,30050,30049,30048,30047,30046,30045,30044,30043,30042,30041,30040,30039,30038,30037,30036,30035,30034,30033,30032,30031,30030,30029,30028,30027,30026,30025,30024,30023,30022,30021,30020,30019,30018,30017,30016,30015,30014,30013,30012,30011,30010,30009,30008,30007,30006,30005,30004,30003,30002,30001,30000,29999,29998,29997,29996,29995,29994,29993,29992,29991,29990,29989,29988,29987,29986,29985,29984,29983,29982,29981,29980,29979,29978,29977,29976,29975,29974,29973,29972,29971,29970,29969,29968,29967,29966,29965,29964,29963,29962,29961,29960,29959,29958,29957,29956,29955,29954,29953,29952,29951,29950,29949,29948,29947,29946,29945,29944,29943,29942,29941,29940,29939,29938,29937,29936,29935,29934,29933,29932,29931,29930,29929,29928,29927,29926,29925,29924,29923,29922,29921,29920,29919,29918,29917,29916,29915,29914,29913,29912,29911,29910,29909,29908,29907,29906,29905,29904,29903,29902,29901,29900,29899,29898,29897,29896,29895,29894,29893,29892,29891,29890,29889,29888,29887,29886,29885,29884,29883,29882,29881,29880,29879,29878,29877,29876,29875,29874,29873,29872,29871,29870,29869,29868,29867,29866,29865,29864,29863,29862,29861,29860,29859,29858,29857,29856,29855,29854,29853,29852,29851,29850,29849,29848,29847,29846,29845,29844,29843,29842,29841,29840,29839,29838,29837,29836,29835,29834,29833,29832,29831,29830,29829,29828,29827,29826,29825,29824,29823,29822,29821,29820,29819,29818,29817,29816,29815,29814,29813,29812,29811,29810,29809,29808,29807,29806,29805,29804,29803,29802,29801,29800,29799,29798,29797,29796,29795,29794,29793,29792,29791,29790,29789,29788,29787,29786,29785,29784,29783,29782,29781,29780,29779,29778,29777,29776,29775,29774,29773,29772,29771,29770,29769,29768,29767,29766,29765,29764,29763,29762,29761,29760,29759,29758,29757,29756,29755,29754,29753,29752,29751,29750,29749,29748,29747,29746,29745,29744,29743,29742,29741,29740,29739,29738,29737,29736,29735,29734,29733,29732,29731,29730,29729,29728,29727,29726,29725,29724,29723,29722,29721,29720,29719,29718,29717,29716,29715,29714,29713,29712,29711,29710,29709,29708,29707,29706,29705,29704,29703,29702,29701,29700,29699,29698,29697,29696,29695,29694,29693,29692,29691,29690,29689,29688,29687,29686,29685,29684,29683,29682,29681,29680,29679,29678,29677,29676,29675,29674,29673,29672,29671,29670,29669,29668,29667,29666,29665,29664,29663,29662,29661,29660,29659,29658,29657,29656,29655,29654,29653,29652,29651,29650,29649,29648,29647,29646,29645,29644,29643,29642,29641,29640,29639,29638,29637,29636,29635,29634,29633,29632,29631,29630,29629,29628,29627,29626,29625,29624,29623,29622,29621,29620,29619,29618,29617,29616,29615,29614,29613,29612,29611,29610,29609,29608,29607,29606,29605,29604,29603,29602,29601,29600,29599,29598,29597,29596,29595,29594,29593,29592,29591,29590,29589,29588,29587,29586,29585,29584,29583,29582,29581,29580,29579,29578,29577,29576,29575,29574,29573,29572,29571,29570,29569,29568,29567,29566,29565,29564,29563,29562,29561,29560,29559,29558,29557,29556,29555,29554,29553,29552,29551,29550,29549,29548,29547,29546,29545,29544,29543,29542,29541,29540,29539,29538,29537,29536,29535,29534,29533,29532,29531,29530,29529,29528,29527,29526,29525,29524,29523,29522,29521,29520,29519,29518,29517,29516,29515,29514,29513,29512,29511,29510,29509,29508,29507,29506,29505,29504,29503,29502,29501,29500,29499,29498,29497,29496,29495,29494,29493,29492,29491,29490,29489,29488,29487,29486,29485,29484,29483,29482,29481,29480,29479,29478,29477,29476,29475,29474,29473,29472,29471,29470,29469,29468,29467,29466,29465,29464,29463,29462,29461,29460,29459,29458,29457,29456,29455,29454,29453,29452,29451,29450,29449,29448,29447,29446,29445,29444,29443,29442,29441,29440,29439,29438,29437,29436,29435,29434,29433,29432,29431,29430,29429,29428,29427,29426,29425,29424,29423,29422,29421,29420,29419,29418,29417,29416,29415,29414,29413,29412,29411,29410,29409,29408,29407,29406,29405,29404,29403,29402,29401,29400,29399,29398,29397,29396,29395,29394,29393,29392,29391,29390,29389,29388,29387,29386,29385,29384,29383,29382,29381,29380,29379,29378,29377,29376,29375,29374,29373,29372,29371,29370,29369,29368,29367,29366,29365,29364,29363,29362,29361,29360,29359,29358,29357,29356,29355,29354,29353,29352,29351,29350,29349,29348,29347,29346,29345,29344,29343,29342,29341,29340,29339,29338,29337,29336,29335,29334,29333,29332,29331,29330,29329,29328,29327,29326,29325,29324,29323,29322,29321,29320,29319,29318,29317,29316,29315,29314,29313,29312,29311,29310,29309,29308,29307,29306,29305,29304,29303,29302,29301,29300,29299,29298,29297,29296,29295,29294,29293,29292,29291,29290,29289,29288,29287,29286,29285,29284,29283,29282,29281,29280,29279,29277,29276,29275,29274,29273,29272,29271,29270,29269,29268,29267,29266,29265,29264,29263,29262,29261,29260,29259,29258,29257,29256,29255,29254,29253,29252,29251,29250,29249,29248,29247,29246,29245,29244,29243,29242,29241,29240,29239,29238,29237,29236,29235,29234,29233,29232,29231,29230,29229,29228,29227,29226,29225,29224,29223,29222,29221,29220,29219,29218,29217,29216,29215,29214,29213,29212,29211,29210,29209,29207,29206,29205,29204,29203,29202,29201,29200,29199,29198,29197,29196,29195,29194,29193,29192,29191,29190,29189,29188,29187,29186,29185,29184,29183,29182,29181,29180,29179,29178,29177,29176,29175,29174,29173,29172,29171,29170,29169,29168,29167,29166,29165,29164,29163,29162,29161,29160,29159,29158,29157,29155,29154,29153,29152,29151,29150,29149,29148,29147,29146,29145,29144,29143,29142,29141,29140,29139,29138,29137,29136,29135,29134,29133,29132,29131,29130,29129,29128,29127,29126,29125,29124,29123,29122,29121,29120,29119,29118,29117,29116,29115,29114,29113,29112,29111,29110,29109,29108,29107,29106,29105,29104,29103,29102,29101,29100,29099,29098,29097,29096,29095,29094,29093,29092,29091,29090,29089,29088,29087,29086,29085,29084,29083,29082,29081,29080,29079,29078,29077,29076,29075,29074,29073,29072,29071,29070,29069,29068,29067,29066,29065,29064,29063,29062,29061,29060,29059,29058,29057,29056,29055,29054,29053,29052,29051,29050,29049,29048,29047,29046,29045,29044,29043,29042,29041,29040,29039,29038,29037,29036,29035,29034,29033,29032,29031,29030,29029,29028,29027,29026,29025,29024,29023,29022,29021,29020,29019,29018,29017,29016,29015,29014,29013,29012,29011,29010,29009,29008,29007,29006,29005,29004,29003,29002,29001,29000,28999,28998,28997,28996,28995,28994,28993,28992,28991,28990,28989,28988,28987,28986,28985,28984,28983,28982,28981,28980,28979,28978,28977,28976,28975,28974,28973,28972,28971,28970,28969,28968,28967,28966,28965,28964,28963,28962,28961,28960,28959,28958,28957,28956,28955,28954,28953,28952,28951,28950,28949,28948,28947,28946,28945,28944,28943,28942,28941,28940,28939,28938,28937,28936,28935,28934,28933,28932,28931,28930,28929,28928,28927,28926,28925,28924,28923,28922,28921,28920,28919,28918,28917,28916,28915,28914,28913,28912,28911,28910,28909,28908,28907,28906,28905) ORDER BY c.ordering288ms1.7MB/plugins/fwrealestate/customfields/customfields.php:103Copy
  • SELECT COUNT(*) FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND p.latitude IS NOT NULL AND p.longitude IS NOT NULL AND p.latitude <> 0 AND p.longitude <> 0 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1))3.2ms536B/components/com_fwrealestate/models/search.php:345Copy
  • SELECT `element`, `enabled`, `folder` FROM `jos3l_extensions` WHERE `type` = 'plugin' AND `folder` IN ('fwrealestate', 'fwrealestatetmpl')812μs1KB/components/com_fwrealestate/helpers/helper.php:812Copy
  • SELECT DISTINCT t.*, (SELECT ttr.name FROM jos3l_fwre_status_translation AS ttr WHERE ttr.status_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS name, (SELECT ttr.name FROM jos3l_fwre_status_translation AS ttr WHERE ttr.status_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS eng, (SELECT ttr.name FROM jos3l_fwre_status_translation AS ttr WHERE ttr.status_id = t.id AND (ttr.lang <> '' AND ttr.lang IS NOT NULL) LIMIT 1) AS any , (SELECT ttr.image FROM jos3l_fwre_status_translation AS ttr WHERE ttr.status_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS image FROM jos3l_fwre_status AS t ORDER BY name, eng, any1.32ms976B/components/com_fwrealestate/helpers/helper.php:1490Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos3l_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40)588μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `jos3l_modules` AS `m` LEFT JOIN `jos3l_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `jos3l_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`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`953μs1.88KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT (SELECT MAX(p.bth) FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND p.latitude IS NOT NULL AND p.longitude IS NOT NULL AND p.latitude <> 0 AND p.longitude <> 0 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1))) AS max_bth, (SELECT MAX(p.bdr) FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND p.latitude IS NOT NULL AND p.longitude IS NOT NULL AND p.latitude <> 0 AND p.longitude <> 0 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1))) AS max_bdr, (SELECT MAX(p.numeric_price) FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND p.latitude IS NOT NULL AND p.longitude IS NOT NULL AND p.latitude <> 0 AND p.longitude <> 0 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1))) AS max_price, (SELECT MAX(CASE WHEN p.living_area IS NOT NULL THEN p.living_area ELSE 0 END) FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND p.latitude IS NOT NULL AND p.longitude IS NOT NULL AND p.latitude <> 0 AND p.longitude <> 0 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1))) AS max_area, (SELECT MAX(CASE WHEN p.lot_size IS NOT NULL THEN p.lot_size ELSE 0 END) FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND p.latitude IS NOT NULL AND p.longitude IS NOT NULL AND p.latitude <> 0 AND p.longitude <> 0 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1))) AS max_size13.21ms768B/modules/mod_fwre_search/helper.php:287Copy
  • SELECT DISTINCT t.*, (SELECT ttr.name FROM jos3l_fwre_amenities_translation AS ttr WHERE ttr.amenities_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS name, (SELECT ttr.name FROM jos3l_fwre_amenities_translation AS ttr WHERE ttr.amenities_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS eng, (SELECT ttr.name FROM jos3l_fwre_amenities_translation AS ttr WHERE ttr.amenities_id = t.id AND (ttr.lang <> '' AND ttr.lang IS NOT NULL) LIMIT 1) AS any FROM jos3l_fwre_amenities AS t ORDER BY name, eng, any156μs3.17KB/components/com_fwrealestate/helpers/helper.php:1490Copy
  • SELECT t.id, (SELECT st.name FROM `jos3l_fwre_property_type_translation` AS st WHERE st.lang = 'en-GB' AND st.property_type_id = t.id LIMIT 1) AS property_type, (SELECT st.name FROM `jos3l_fwre_property_type_translation` AS st WHERE st.property_type_id = t.id LIMIT 1) AS property_type_any, (SELECT COUNT(*) FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND p.latitude IS NOT NULL AND p.longitude IS NOT NULL AND p.latitude <> 0 AND p.longitude <> 0 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1)) AND EXISTS(SELECT * FROM `jos3l_fwre_property_types` AS pc WHERE pc.property_id = p.id AND pc.property_type_id = t.id)) AS qty FROM `jos3l_fwre_property_type` AS t WHERE EXISTS(SELECT * FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND p.latitude IS NOT NULL AND p.longitude IS NOT NULL AND p.latitude <> 0 AND p.longitude <> 0 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1)) AND EXISTS(SELECT * FROM `jos3l_fwre_property_types` AS pc WHERE pc.property_id = p.id AND pc.property_type_id = t.id)) ORDER BY property_type, property_type_any33.91ms720B/modules/mod_fwre_search/helper.php:485Copy
  • SELECT pc.category_id, (SELECT st.name FROM `jos3l_fwre_category_translation` AS st WHERE st.lang = 'en-GB' AND st.category_id = pc.category_id) AS category, (SELECT st.name FROM `jos3l_fwre_category_translation` AS st WHERE st.category_id = pc.category_id LIMIT 1) AS category_any, COUNT(*) AS qty FROM jos3l_fwre_property AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB', `jos3l_fwre_property_categories` AS pc WHERE p.published = 1 AND p.latitude IS NOT NULL AND p.longitude IS NOT NULL AND p.latitude <> 0 AND p.longitude <> 0 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1)) AND pc.property_id = p.id GROUP BY pc.category_id ORDER BY category22.35ms704B/modules/mod_fwre_search/helper.php:450Copy
  • SELECT bdr, COUNT(*) AS qty FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND p.latitude IS NOT NULL AND p.longitude IS NOT NULL AND p.latitude <> 0 AND p.longitude <> 0 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1)) GROUP BY bdr ORDER BY bdr3.58ms736B/modules/mod_fwre_search/helper.php:343Copy
  • SELECT bth, COUNT(*) AS qty FROM `jos3l_fwre_property` AS p LEFT JOIN `jos3l_fwre_property_translation` AS pt ON pt.property_id = p.id AND pt.lang = 'en-GB' LEFT JOIN `jos3l_fwre_profile` AS up ON up.user_id = p.user_id LEFT JOIN jos3l_fwre_city_translation AS pct ON pct.city_id = p.city_id AND pct.lang = 'en-GB' LEFT JOIN jos3l_fwre_region_translation AS pret ON pret.region_id = p.region_id AND pret.lang = 'en-GB' LEFT JOIN jos3l_fwre_country_translation AS pcot ON pcot.country_id = p.country_id AND pcot.lang = 'en-GB' WHERE p.published = 1 AND p.latitude IS NOT NULL AND p.longitude IS NOT NULL AND p.latitude <> 0 AND p.longitude <> 0 AND (NOT EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id) OR EXISTS(SELECT * FROM `jos3l_fwre_property_agent` AS pa, `jos3l_fwre_profile` AS up WHERE pa.property_id = p.id AND pa.user_id = up.user_id AND up.published = 1)) GROUP BY bth ORDER BY bth3.13ms1.06KB/modules/mod_fwre_search/helper.php:310Copy
  • SELECT DISTINCT t.*, (SELECT ttr.name FROM jos3l_fwre_dimension_translation AS ttr WHERE ttr.dimension_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS name, (SELECT ttr.name FROM jos3l_fwre_dimension_translation AS ttr WHERE ttr.dimension_id = t.id AND ttr.lang = 'en-GB' LIMIT 1) AS eng, (SELECT ttr.name FROM jos3l_fwre_dimension_translation AS ttr WHERE ttr.dimension_id = t.id AND (ttr.lang <> '' AND ttr.lang IS NOT NULL) LIMIT 1) AS any FROM jos3l_fwre_dimension AS t ORDER BY name, eng, any96μs768B/components/com_fwrealestate/helpers/helper.php:1490Copy
  • SELECT * FROM `jos3l_nspro_lists` WHERE `state` = 1 ORDER BY `id`105μs1.28KB/components/com_nspro/models/nspro.php:28Copy
  • SELECT * FROM `jos3l_nspro_fields` WHERE `state` = 1 AND `abovepos` = "1" ORDER BY `ordering` ASC110μs1.61KB/administrator/components/com_nspro/lib.php:1787Copy
  • SELECT * FROM `jos3l_nspro_fields` WHERE `state` = 1 AND `abovepos` = "2" ORDER BY `ordering` ASC92μs1.61KB/administrator/components/com_nspro/lib.php:1787Copy
  • SELECT * FROM `jos3l_nspro_fields` WHERE `state` = 1 AND `abovepos` = "0" ORDER BY `ordering` ASC89μs1.61KB/administrator/components/com_nspro/lib.php:1787Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM jos3l_fields AS a LEFT JOIN `jos3l_languages` AS l ON l.lang_code = a.language LEFT JOIN jos3l_users AS uc ON uc.id=a.checked_out LEFT JOIN jos3l_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos3l_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos3l_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC220μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `jos3l_scheduler_tasks` AS `a` WHERE `a`.`state` = 1514μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `jos3l_session` WHERE `session_id` = ?263μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `jos3l_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.29ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy