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

Properties listing

15 of 1366 Properties
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
Pending
10
1/10
One acre lot with a home, great investment opportunity.
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
  •  - Image# 24
  •  - Image# 25
  •  - Image# 26
  •  - Image# 27
  •  - Image# 28
  •  - Image# 29
  •  - Image# 30
  •  - Image# 31
  •  - Image# 32
  •  - Image# 33
  •  - Image# 34
Active
34
1/34
Highly Sought-After Collierville Living! Don’t miss this rare 2-bedroom, 2-bathroom corner unit in The Oaks of Schilling Farms! This spacious floorplan includes a gorgeous sunroom and an office that can easily be used as a 3rd bedroom. Located across from the clubhouse and pool, this unit offers both space and convenience. The open living, dining, and kitchen areas are perfect for entertaining, and the split bedroom layout ensures privacy. Features include: Gorgeous Sunroom Office/Flex Room th…
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
  •  - Image# 24
  •  - Image# 25
  •  - Image# 26
  •  - Image# 27
  •  - Image# 28
Pending
28
1/28
Detached Single Family
3
2
1200 sqft
Discover the unique charm of this newly renovated 3-bedroom, 2-bath home, where classic character meets modern comfort. Nestled on a quiet dead-end street, this inviting residence boasts a spacious separate living room, perfect for cozy gatherings, and a delightful kitchen/dining room combo ideal for sharing meals with family and friends. The home features a large front porch, perfect for sipping your morning coffee or enjoying the sunset. A convenient laundry room adds to the functionality and…
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
  •  - Image# 24
  •  - Image# 25
  •  - Image# 26
Active
26
1/26
Detached Single Family
3
2.1
2400 sqft
Seller says "Make an offer!" Get ready for summer with this beautiful 3 bedroom/2.5 bath home with a bonus room & an in-ground pool! Fresh paint throughout! Large living room with vaulted ceilings ~ Formal Dining Room off of entry hall ~ Spacious kitchen beautifully updated to feature hardwood flooring & stainless steel appliances. Cozy front room/office w/ hardwood floors off of the kitchen ~ Primary bedroom downstairs w/ high ceiling & en-suite bath offering double sinks…
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
Pending
23
1/23
Beautifully renovated midtown home with open concept kitchen and living room. Split bedroom plan with large primary and private bath, 2 large bedrooms with shared updated hall bath and a sunroom/office space off the living room. Updated kitchen has gas cooking, stackable washer/dryer and eat-in dining area. Enjoy your evenings on the new deck off the back of the home. Location is close to Crosstown Concourse, the Zoo, Overton Park, & Rhodes College.
  •  - Image# 1
Active
1
1/1
Tenant occupied until 12/31/2025 at $835/month. Check out this 2-bedroom, 1 bathroom home in a great location! Fully rent ready rehabbed in 2023. Market rent is $1000/month. DO NOT DISTURB TENANT. Please reach out to Brett Bernard for further info. Do not miss out!
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
Pending
17
1/17
One owner home impeccable condition. New roof, new appliances, new flooring, lavish drapes, and much more. Home shows as one in Better Homes and Garden. Expanded patio in back yard. Easy to show.
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
  •  - Image# 24
  •  - Image# 25
  •  - Image# 26
  •  - Image# 27
  •  - Image# 28
  •  - Image# 29
  •  - Image# 30
  •  - Image# 31
  •  - Image# 32
  •  - Image# 33
  •  - Image# 34
  •  - Image# 35
  •  - Image# 36
  •  - Image# 37
  •  - Image# 38
  •  - Image# 39
  •  - Image# 40
Active
40
1/40
Detached Single Family
5
4
3600 sqft
This spacious 5-bedroom (2 down!), 4-bathroom home on a generous 1.69-acre lot in Hernando offers the perfect blend of modern updates and thoughtful design. Built in 2020/2021, the home features an inviting open floor plan with a two-story living room and striking brick fireplace. The kitchen is a dream, complete with granite countertops, custom cabinetry, stainless steel appliances, a gas cooktop, a farm sink, and a walk-in pantry. The main-level primary suite boasts a spa-like bathroom with a …
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
Active
16
1/16
Quaint 3 bedroom/2 bath home conveniently located just outside city limits with plenty of yard space for kids and animals. This home has a large living space, master bedroom with full bath and large eat-in kitchen.
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
  •  - Image# 24
  •  - Image# 25
  •  - Image# 26
  •  - Image# 27
  •  - Image# 28
  •  - Image# 29
  •  - Image# 30
Active
30
1/30
Detached Single Family
5
3
3800 sqft
Looking for a nice home with a mixture of modern and country living sitting on 1.64 acres? This is the home for you! Features 5br/3 full bath + an additional in law suite that entails full kitchen, living room, bathroom and 1 bedroom.
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
  •  - Image# 24
  •  - Image# 25
  •  - Image# 26
  •  - Image# 27
  •  - Image# 28
  •  - Image# 29
  •  - Image# 30
  •  - Image# 31
  •  - Image# 32
  •  - Image# 33
  •  - Image# 34
  •  - Image# 35
  •  - Image# 36
  •  - Image# 37
  •  - Image# 38
  •  - Image# 39
  •  - Image# 40
Active
40
1/40
Introducing the deal of the century, worth double renovated- a charming,historic gem surrounded by luxury homes in the heart of Midtown! This beautiful home blends timeless character with modern convenience, offering an unmatched lifestyle in one of the city’s most sought-after neighborhoods.Amazing architectural charm-high ceilings, original hardwood floors, and elegant moldings bring the history of this home to life,spacious layout with generous living spaces, a formal dining room, large bedro…
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
  •  - Image# 24
Active
24
1/24
Detached Single Family
3
2.1
3000 sqft
NEW LOWER PRICE!! A LOT OF HOUSE FOR THE $$!! GREAT POTENTIAL HERE!! 3 bedroom/2 bath Main House AND an approximate 837 sf detached structure that would make a wonderful mother-in-law suite/office/salon/guest house, etc. Both brick structures are selling in "As Is" condition (needs work.) See photos for additional information. DON'T MISS OUT...SCHEDULE YOUR APPOINTMENT TODAY!
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
  •  - Image# 16
  •  - Image# 17
  •  - Image# 18
  •  - Image# 19
  •  - Image# 20
  •  - Image# 21
  •  - Image# 22
  •  - Image# 23
  •  - Image# 24
Active
24
1/24
Completely renovated East Memphis gem! Open floor plan with 4 bdrms 2 1/2 baths. Split bedroom. Stainless steel appliances. 2 refrigerators stay. Granite countertops. Separate laundry room. Built in murphy bed with shelves and desk in one bedroom. Huge backyard with equipment shed. Don't miss out on this home that has it all!
  •  - Image# 1
  •  - Image# 2
  •  - Image# 3
  •  - Image# 4
  •  - Image# 5
  •  - Image# 6
  •  - Image# 7
  •  - Image# 8
  •  - Image# 9
  •  - Image# 10
  •  - Image# 11
  •  - Image# 12
  •  - Image# 13
  •  - Image# 14
  •  - Image# 15
Active
15
1/15
Detached Single Family
4
1
1000 sqft
This beautiful updated and well maintained home has 4 bedroom and 1 full bath sitting in a large lot in south Memphis, jut 10 minutes away from xAI supercomputer center. All upgraded interior, exterior, roof and HVAC system. Make it your primary home or add it to your rental portfolio. 861 Buntyn st, 1814 Marjorie st are offered for sell with this property. You can buy it individually or bundle all together. Bring offer.
  •  - Image# 1
Active
1
1/1
Detached Single Family
3
1
1200 sqft
Perfect home for first time home buyer or investors. This is a 3 bedrooms 1 bath home, one year old roof, new wiring, plumbing and 6 month old hvac system. Only 6 minutes drive from university of Memphis making it ideal for rental property. 1814 Marjorie St and 44 Peebles St are up for sale too. Buy it individually or all three houses together. Ideal for investors who wants to increase their portfolio.
10.477MBMemory Usage682msRequest 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" => "165" ]
$_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.33ms)
  • afterInitialise (2.37MB) (86.03ms)
  • afterRoute (1.82MB) (33.39ms)
  • beforeRenderComponent com_fwrealestate (7.92KB) (2.65ms)
  • Before Access::preloadComponents (all components) (2.02MB) (144ms)
  • After Access::preloadComponents (all components) (145.36KB) (1.24ms)
  • Before Access::getAssetRules (id:1 name:root.1) (104B) (36μs)
  • After Access::getAssetRules (id:1 name:root.1) (7.2KB) (416μs)
  • afterRenderComponent com_fwrealestate (1.6MB) (177ms)
  • afterDispatch (83KB) (3.95ms)
  • beforeRenderRawModule mod_yootheme_builder (Property Search Display) (149.95KB) (36.06ms)
  • beforeRenderRawModule mod_fwre_search (Property Search) (63.47KB) (3.32ms)
  • afterRenderRawModule mod_fwre_search (Property Search) (151.27KB) (74.1ms)
  • beforeRenderModule mod_fwre_search (Property Search) (720B) (13μs)
  • afterRenderModule mod_fwre_search (Property Search) (3.91KB) (1.03ms)
  • afterRenderRawModule mod_yootheme_builder (Property Search Display) (169.05KB) (11.3ms)
  • beforeRenderModule mod_yootheme_builder (Property Search Display) (736B) (16μs)
  • afterRenderModule mod_yootheme_builder (Property Search Display) (2.48KB) (273μs)
  • beforeRenderRawModule mod_nspro (Mailing List Subscribe (Footer)) (144.62KB) (8.86ms)
  • afterRenderRawModule mod_nspro (Mailing List Subscribe (Footer)) (124.05KB) (5.43ms)
  • beforeRenderModule mod_nspro (Mailing List Subscribe (Footer)) (736B) (22μs)
  • afterRenderModule mod_nspro (Mailing List Subscribe (Footer)) (6.37KB) (515μs)
  • beforeRenderRawModule mod_custom () (13.41KB) (30.58ms)
  • afterRenderRawModule mod_custom () (40.01KB) (5.17ms)
  • beforeRenderModule mod_custom () (704B) (42μs)
  • afterRenderModule mod_custom () (1.81KB) (308μs)
  • beforeRenderRawModule mod_menu () (1.41KB) (675μs)
  • afterRenderRawModule mod_menu () (45.84KB) (4.6ms)
  • beforeRenderModule mod_menu () (696B) (11μs)
  • afterRenderModule mod_menu () (3.41KB) (247μs)
  • beforeRenderRawModule mod_custom () (1.28KB) (563μs)
  • afterRenderRawModule mod_custom () (944B) (653μs)
  • beforeRenderModule mod_custom () (704B) (10μs)
  • afterRenderModule mod_custom () (3.06KB) (237μs)
  • beforeRenderRawModule mod_custom () (1.11KB) (493μs)
  • afterRenderRawModule mod_custom () (896B) (1.34ms)
  • beforeRenderModule mod_custom () (704B) (10μs)
  • afterRenderModule mod_custom () (1.81KB) (170μs)
  • beforeRenderRawModule mod_custom () (2.61KB) (542μs)
  • afterRenderRawModule mod_custom () (896B) (1.18ms)
  • beforeRenderModule mod_custom () (704B) (14μs)
  • afterRenderModule mod_custom () (1.81KB) (185μs)
  • beforeRenderRawModule mod_custom () (184B) (25μs)
  • afterRenderRawModule mod_custom () (816B) (370μs)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (1.81KB) (184μs)
  • beforeRenderRawModule mod_menu () (376B) (29μs)
  • afterRenderRawModule mod_menu () (2.27KB) (5.51ms)
  • beforeRenderModule mod_menu () (696B) (17μs)
  • afterRenderModule mod_menu () (1.81KB) (259μs)
  • beforeRenderRawModule mod_custom () (5.98KB) (1.07ms)
  • afterRenderRawModule mod_custom () (896B) (508μs)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (2.94KB) (192μs)
  • beforeRenderRawModule mod_custom () (880B) (300μs)
  • afterRenderRawModule mod_custom () (896B) (374μs)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (3.78KB) (183μs)
  • afterRender (463.53KB) (19.37ms)
  • 1 x afterRenderComponent com_fwrealestate (1.6MB) (25.92%)
    177ms
    1 x Before Access::preloadComponents (all components) (2.02MB) (21.1%)
    144ms
    1 x afterInitialise (2.37MB) (12.61%)
    86.03ms
    1 x afterRenderRawModule mod_fwre_search (Property Search) (151.27KB) (10.86%)
    74.10ms
    1 x beforeRenderRawModule mod_yootheme_builder (Property Search Display) (149.95KB) (5.29%)
    36.06ms
    1 x afterRoute (1.82MB) (4.89%)
    33.39ms
    1 x beforeRenderRawModule mod_custom () (13.41KB) (4.48%)
    30.58ms
    1 x afterRender (463.53KB) (2.84%)
    19.37ms
    1 x afterLoad (71.1KB) (2.25%)
    15.33ms
    1 x afterRenderRawModule mod_yootheme_builder (Property Search Display) (169.05KB) (1.66%)
    11.30ms
    1 x beforeRenderRawModule mod_nspro (Mailing List Subscribe (Footer)) (144.62KB) (1.3%)
    8.86ms
    1 x afterRenderRawModule mod_menu () (2.27KB) (0.81%)
    5.51ms
    1 x afterRenderRawModule mod_nspro (Mailing List Subscribe (Footer)) (124.05KB) (0.8%)
    5.43ms
    1 x afterRenderRawModule mod_custom () (40.01KB) (0.76%)
    5.17ms
    1 x afterRenderRawModule mod_menu () (45.84KB) (0.67%)
    4.60ms
    1 x afterDispatch (83KB) (0.58%)
    3.95ms
    4 x afterRenderRawModule mod_custom () (896B) (0.5%)
    3.40ms
    1 x beforeRenderRawModule mod_fwre_search (Property Search) (63.47KB) (0.49%)
    3.32ms
    1 x beforeRenderComponent com_fwrealestate (7.92KB) (0.39%)
    2.65ms
    1 x After Access::preloadComponents (all components) (145.36KB) (0.18%)
    1.24ms
    1 x beforeRenderRawModule mod_custom () (5.98KB) (0.16%)
    1.07ms
    1 x afterRenderModule mod_fwre_search (Property Search) (3.91KB) (0.15%)
    1.03ms
    4 x afterRenderModule mod_custom () (1.81KB) (0.12%)
    847μs
    1 x beforeRenderRawModule mod_menu () (1.41KB) (0.1%)
    675μs
    1 x afterRenderRawModule mod_custom () (944B) (0.1%)
    653μs
    1 x beforeRenderRawModule mod_custom () (1.28KB) (0.08%)
    563μs
    1 x beforeRenderRawModule mod_custom () (2.61KB) (0.08%)
    542μs
    1 x afterRenderModule mod_nspro (Mailing List Subscribe (Footer)) (6.37KB) (0.08%)
    515μs
    1 x beforeRenderRawModule mod_custom () (1.11KB) (0.07%)
    493μs
    1 x After Access::getAssetRules (id:1 name:root.1) (7.2KB) (0.06%)
    416μs
    1 x afterRenderRawModule mod_custom () (816B) (0.05%)
    370μs
    1 x beforeRenderRawModule mod_custom () (880B) (0.04%)
    300μs
    1 x afterRenderModule mod_yootheme_builder (Property Search Display) (2.48KB) (0.04%)
    273μs
    1 x afterRenderModule mod_menu () (1.81KB) (0.04%)
    259μs
    1 x afterRenderModule mod_menu () (3.41KB) (0.04%)
    247μs
    1 x afterRenderModule mod_custom () (3.06KB) (0.03%)
    237μs
    1 x afterRenderModule mod_custom () (2.94KB) (0.03%)
    192μs
    1 x afterRenderModule mod_custom () (3.78KB) (0.03%)
    183μs
    7 x beforeRenderModule mod_custom () (704B) (0.02%)
    103μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (104B) (0.01%)
    36μs
    1 x beforeRenderRawModule mod_menu () (376B) (0%)
    29μs
    2 x beforeRenderModule mod_menu () (696B) (0%)
    28μs
    1 x beforeRenderRawModule mod_custom () (184B) (0%)
    25μs
    1 x beforeRenderModule mod_nspro (Mailing List Subscribe (Footer)) (736B) (0%)
    22μs
    1 x beforeRenderModule mod_yootheme_builder (Property Search Display) (736B) (0%)
    16μs
    1 x beforeRenderModule mod_fwre_search (Property Search) (720B) (0%)
    13μs
46 statements were executed130ms399.16KB
  • SELECT @@SESSION.sql_mode;225μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `jos3l_session` WHERE `session_id` = ?371μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `jos3l_session` WHERE `session_id` = :session_id LIMIT 1239μ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)4.02ms944BParams/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` = 1263μs81.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos3l_viewlevels`202μ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` = :guest151μ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`572μs133.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT custom_data FROM jos3l_extensions WHERE element = 'yooessentials' AND folder = 'system'142μ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`199μs19.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `jos3l_languages` WHERE `published` = 1 ORDER BY `ordering` ASC192μ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` = 1119μs16.83KB/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT custom_data FROM jos3l_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 188μ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, any167μ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 (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.ordering LIMIT 165, 1545.12ms48.73KB/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.ordering156μ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 ordering159μ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 ordering110μ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)110μs752B/plugins/fwrealestate/customfields/customfields.php:1421Copy
  • SELECT * FROM `jos3l_fwre_fields_access` WHERE property_id = 083μ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 (30108,30107,30106,30105,30104,30103,30102,30101,30100,30099,30098,30097,30096,30095,30094)307μs640B/components/com_fwrealestate/helpers/fwrealestatefields.php:188Copy
  • SELECT property_id, `image` FROM `jos3l_fwre_property_gallery` WHERE property_id IN (30108,30107,30106,30105,30104,30103,30102,30101,30100,30099,30098,30097,30096,30095,30094) ORDER BY ordering, id3.3ms24.56KB/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 (30108,30107,30106,30105,30104,30103,30102,30101,30100,30099,30098,30097,30096,30095,30094)446μs832B/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 (30108,30107,30106,30105,30104,30103,30102,30101,30100,30099,30098,30097,30096,30095,30094)681μs832B/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 (30108,30107,30106,30105,30104,30103,30102,30101,30100,30099,30098,30097,30096,30095,30094) AND u.id = pa.user_id ORDER BY pa.ordering499μs2.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 (30108,30107,30106,30105,30104,30103,30102,30101,30100,30099,30098,30097,30096,30095,30094) ORDER BY c.ordering6.63ms19.83KB/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 (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))110μs536B/components/com_fwrealestate/models/search.php:345Copy
  • SELECT `element`, `enabled`, `folder` FROM `jos3l_extensions` WHERE `type` = 'plugin' AND `folder` IN ('fwrealestate', 'fwrealestatetmpl')146μ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, any140μs976B/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)302μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • 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, any168μs768B/components/com_fwrealestate/helpers/helper.php:1490Copy
  • 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`221μ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 (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 (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 (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 (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 (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_size203μs3.25KB/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, any135μs688B/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 (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 (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_any38.67ms720B/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 (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 category21.9ms704B/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 (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 bdr135μs736B/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 (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 bth186μs1.06KB/modules/mod_fwre_search/helper.php:310Copy
  • SELECT * FROM `jos3l_nspro_lists` WHERE `state` = 1 ORDER BY `id`168μs1.28KB/components/com_nspro/models/nspro.php:28Copy
  • SELECT * FROM `jos3l_nspro_fields` WHERE `state` = 1 AND `abovepos` = "1" ORDER BY `ordering` ASC193μs1.61KB/administrator/components/com_nspro/lib.php:1787Copy
  • SELECT * FROM `jos3l_nspro_fields` WHERE `state` = 1 AND `abovepos` = "2" ORDER BY `ordering` ASC136μs1.61KB/administrator/components/com_nspro/lib.php:1787Copy
  • SELECT * FROM `jos3l_nspro_fields` WHERE `state` = 1 AND `abovepos` = "0" ORDER BY `ordering` ASC182μ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 ASC361μ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` = 1521μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `jos3l_session` WHERE `session_id` = ?434μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `jos3l_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.05ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy