Sheffield Property Info

Quick Search

Number of properties

Number of months

Landlord Plan - 0.00 GBP

Landlord Plan
A Micro site & Multiple Property Listings.

Allows a prortfollio of:

1 to 5 properties: £20 per property per month.

6 to 10 properties: £15.00 per property per month.

11 to 25 properties: £10.00 per property per month.

26 to 50 properties: £7.50 per property per month.

51 to 100 properties: £6.00 per property per month.

101 to 200 properties: £4.00 per property per month.

Number of properties

Number of months

Property Services Listing - 36.50 GBP

Property Services Listing
List your Company/Services in our property services directory.
Allows you to list your property service.
£36.50 per Annum. (That's 10p a Day!)

General

Username^*

Full Name^*

Email^*

Auto generate password

Password

Your password:

Confirm your password:

captcha Please input letters you see on the image.
Click on image to redraw.

Account Menu

Properties

Newsletters

Array ( [0] => ia.core.sanitize (3.96Kb) [1] => ia.core.validate (4.27Kb) [2] => ia.core.db (24.84Kb) [3] => ia.core.language (4.31Kb) [4] => ia.core.cache (8.51Kb) [5] => ia.core.users (13.52Kb) [6] => ia.core.breadcrumb (4.33Kb) [7] => ia.core.view (48.66Kb) [8] => ia.core.acl (10.67Kb) [9] => ia.core.util (16.07Kb) [10] => ia.core.smarty (8.22Kb) [11] => plugin: ia.front.iaBanner (2.80Kb) [12] => abstractPackageFront (3.18Kb) [13] => package: ia.front.estate (11.89Kb) [14] => abstractPackageAdmin (4.56Kb) [15] => package: ia.common.location (21.88Kb) [16] => ia.core.fields (45.89Kb) [17] => ia.front.plan (8.64Kb) [18] => plugin: ia.front.iaCaptcha (2.19Kb) [19] => ia.core.item (6.61Kb) )

Array ( [extension] => / [id] => 15 [type] => [url] => [title] => Registration [name] => member_registration [alias] => registration/ [action] => read [extras] => [filename] => registration [parent] => [description] => [keywords] => [body] => registration [error_404] => [ia_url] => http://sheffieldproperty.info/en/ [admin_url] => http://sheffieldproperty.info/admin/ [subpage] => [css_rendered] => 1 )

Array ( [inventory] => Array ( [0] => inventory ) [mainmenu] => Array ( [0] => main ) [right] => Array ( [0] => account [1] => item_actions [2] => realestate [3] => recent_real_estates [4] => recently_viewed_properties [5] => banner_block_right_1 [6] => newsletters_subscription ) [copyright] => Array ( [0] => bottom ) [account] => Array ( [0] => account_area ) [footer1] => Array ( [0] => block_about ) [footer2] => Array ( [0] => block_features ) [footer3] => Array ( [0] => block_about_us ) [footer4] => Array ( [0] => block_contacts ) [left] => Array ( [0] => realestate_quick_search [1] => banner_block_left_1 ) )

Array ( [0] => smartyFrontAfterHeadSection [1] => smartyAdminAfterHeadSection [2] => editItemSetSystemDefaults [3] => phpCoreCodeBeforeStart [4] => frontEditProfile [5] => phpCoreGetUrlBeforeConstantDefine [6] => editProfileExtraTabs [7] => editProfileProcessData [8] => populateCommonStatisticsBlock [9] => phpCoreBeforePageDisplay [10] => phpAdminIndexBeforeStatsGet [11] => smartyAdminIndexAfterStats [12] => phpAdminDatabaseBeforeAll [13] => phpDbControlBeforeReset [14] => adminDatabaseConsistency [15] => phpAdminDatabaseConsistencyType [16] => paymentButtons [17] => phpSmartyAfterFuncInit [18] => smartyFrontBeforeHeadSection )

Array ( [realestate] => Array ( [name] => realestate [url] => http://sheffieldproperty.info/en/ [title] => Real Estate [tpl_url] => http://sheffieldproperty.info/packages/realestate/templates/ [tpl_common] => /var/www/vhosts/sheffieldproperty.info/httpdocs/packages/realestate/templates/common/ ) )

Array ( [bugs_email] => aboldyrev@intelliants.com [debug_pass] => [tmpl] => sheffieldproperty [baseurl] => http://sheffieldproperty.info/ [languages] => a:1:{s:2:"en";s:7:"English";} [backup] => backup/ [version] => 2.3.7 [cron] => 1 [admin_tmpl] => default [default_package] => realestate [ckeditor_color] => #868686 [home_page] => index [tmpl_rollback_data] => a:1:{s:6:"blocks";a:1:{s:17:"common_statistics";a:1:{s:6:"status";s:6:"active";}}} [site] => SheffieldProperty.info for Properties in Sheffield [suffix] => Sheffield Property [site_logo] => site_logo_1a4520475e.jpg [language_switch] => 1 [lang] => en [charset] => UTF-8 [locale] => en_UK [timezone] => Europe/London [date_format] => %b %e, %Y [admin_page] => admin [bc_home] => Home [frontend] => 1 [underconstruction] =>

We are sorry. Our site is under construction.

Sheffield Property Limited is a company
registered in England No: 8792792

[allow_animated_gifs] => 1 [thumb_w] => 80 [thumb_h] => 80 [watermark] => 1 [site_watermark] => [lightbox_name] => prettyphoto [accounts] => 1 [accounts_autoapproval] => 0 [currency] => GBP [balance_min_amount] => 0 [block_positions] => header,top-menu,left,right,contentTop,bottom,user1,user2,verybottom,afterHeader,verytop,copyright,inventory,mainmenu,footer1,footer2,footer3,footer4,slider,testimonials,welcome,tab_popular,tab_new,tab_random,author_info [ckeditor_code_highlighting] => 0 [captcha] => 1 [captcha_name] => kcaptcha [captcha_preview] => [site_from_name] => Sheffield Property Mail [site_email] => info@sheffieldproperty.info [mail_function] => php mail [smtp_auth] => 1 [smtp_server] => tls://smtp.example.org [smtp_port] => [smtp_user] => [smtp_password] => [sendmail_path] => /usr/bin/sendmail [mimetype] => 1 [intelliants_latest_news] => 0 [admin_online_expiry_time] => 180 [display_new_plugins] => 0 [display_feedbacks] => 1 [display_changelog] => 1 [display_twitter] => 1 [twitter_count] => 5 [check_for_updates] => 1 [redirect_time] => 4000 [prevent_csrf] => 1 [caching] => 0 [smarty_cache] => 0 [compress_js] => 0 [account_registration] => 1 [account_registration_subject] => Thanks for registration at {%SITE_NAME%} [account_registration_body] =>

Dear {%FULLNAME%},

Thanks for your registration at {%SITE_URL%}. Here is information you should use in order to login:

Your e-mail: {%EMAIL%}
Your password: {%PASSWORD%}

Your activation key: {%KEY%}

To activate your account go to {%SITE_URL%}confirm/?email={%EMAIL%}&key={%KEY%}
You may change your password later by editing your personal attributes in your account area.

______________________________
Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[account_registration_admin_subject] => Account has been created {%SITE_NAME%} [account_registration_admin_body] =>

Greetings {%FULLNAME%},

Administrator has just created an account for you at {%SITE_URL%}. Here is information you should use in order to login:

Your email: {%EMAIL%}
Your password: {%PASSWORD%}

______________________________
Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[member_removal] => 1 [member_removal_subject] => Account deleted at {%SITE_NAME%} [member_removal_body] =>

Dear {%FULLNAME%},

Your account was removed from {%SITE_URL%}.

______________________________

Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[password_restoration] => 1 [password_restoration_subject] => Password restoration request at {%SITE_NAME%} [password_restoration_body] =>

Dear {%FULLNAME%},

Please follow this link if you wish change the password at {%SITE_URL%}:
{%URL%}

Or use confirmation code on page: {%SITE_URL%}forgot/?code
E-mail: {%EMAIL%}
Code: {%CODE%}

______________________________
Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[password_changement] => 1 [password_changement_subject] => Password change request at {%SITE_NAME%} [password_changement_body] =>

Dear {%FULLNAME%},

You requested a password change in {%SITE_NAME%}. Now you should use the following credentials to log in as account:

username: {%USERNAME%}
password: {%PASSWORD%}

______________________________
Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[account_approved] => 1 [account_approved_subject] => Account was approved at {%SITE_NAME%} [account_approved_body] =>

Dear {%FULLNAME%},

Your account was approved in {%SITE_NAME%}. Now you can log in.

______________________________

Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[account_disapproved] => 1 [account_disapproved_subject] => Account was disapproved at {%SITE_NAME%} [account_disapproved_body] =>

Dear {%FULLNAME%},

Your account was disapproved in {%SITE_NAME%}.

______________________________

Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[estates_locations_browse_type] => grid [estates_footer_locations_num] => 20 [estates_footer_states_num] => 12 [estates_recently_viewed_num] => 10 [estates_popular_num] => 15 [estates_featured_num] => 8 [estates_recent_num] => 10 [estates_addthis_widget] => 1 [estates_gmap_width] => 530 [estates_gmap_height] => 335 [estates_num_per_page] => 10 [estates_rss_entries] => 2000 [estates_location_columns] => 3 [estates_auto_approval] => 0 [sp_right_col] => 1 [sp_left_col] => 1 [sp_social_t] => https://twitter.com/Sheff_Property [sp_social_f] => https://www.facebook.com/pages/Sheffield-Property/365730463544663 [sp_social_g] => https://plus.google.com/+SheffieldPropertyInfo [sp_social_p] => http://pinterest.com/sheffproperty/sheffield-property/ [estates_country_name] => Sheffield, United Kingdom [paypal_currency_code] => GBP [paypal_email] => info@sheffieldproperty.info [paypal_demo] => 0 [captcha_case_sensitive] => 1 [captcha_num_chars] => 8 [prettyphoto_show_title] => 1 [prettyphoto_style] => dark_rounded [prettyphoto_anim_speed] => fast [prettyphoto_socialtools] => ????

[banner_folder] => banners [banner_prefix] => banner_ [banners_payment] => 1 [banners_payment_subject] => Banner was submitted to {own_site} [banners_payment_body] => Dear {admin_name}, Banner has been submitted to {own_site} Directory. Please check it. These are the attributes of a banner: Title: {item_title} URL: {item_url} Email: {item_email} Banner Plan: {item_plan} ______________________________ Thank you, {own_site} Administration Team {own_url} {own_email} [google_langs] => a:55:{s:2:"af";s:9:"Afrikaans";s:2:"sq";s:8:"Albanian";s:2:"ar";s:6:"Arabic";s:2:"be";s:10:"Belarusian";s:2:"bg";s:9:"Bulgarian";s:2:"ca";s:7:"Catalan";s:2:"zh";s:7:"Chinese";s:5:"zh-CN";s:18:"Chinese_simplified";s:5:"zh-TW";s:19:"Chinese_traditional";s:2:"hr";s:8:"Croatian";s:2:"cs";s:5:"Czech";s:2:"da";s:6:"Danish";s:2:"nl";s:5:"Dutch";s:2:"en";s:7:"English";s:2:"et";s:8:"Estonian";s:2:"fi";s:7:"Finnish";s:2:"fr";s:6:"French";s:2:"gl";s:8:"Galician";s:2:"de";s:6:"German";s:2:"el";s:5:"Greek";s:2:"ht";s:14:"Haitian_creole";s:2:"iw";s:6:"Hebrew";s:2:"hi";s:5:"Hindi";s:2:"hu";s:9:"Hungarian";s:2:"is";s:9:"Icelandic";s:2:"id";s:10:"Indonesian";s:2:"ga";s:5:"Irish";s:2:"it";s:7:"Italian";s:2:"ja";s:8:"Japanese";s:2:"ko";s:6:"Korean";s:2:"lv";s:7:"Latvian";s:2:"lt";s:10:"Lithuanian";s:2:"mk";s:10:"Macedonian";s:2:"ms";s:5:"Malay";s:2:"mt";s:7:"Maltese";s:2:"no";s:9:"Norwegian";s:2:"fa";s:7:"Persian";s:2:"pl";s:6:"Polish";s:2:"pt";s:10:"Portuguese";s:5:"pt-PT";s:19:"Portuguese_portugal";s:2:"ro";s:8:"Romanian";s:2:"ru";s:7:"Russian";s:2:"sr";s:7:"Serbian";s:2:"sk";s:6:"Slovak";s:2:"sl";s:9:"Slovenian";s:2:"es";s:7:"Spanish";s:2:"sw";s:7:"Swahili";s:2:"sv";s:7:"Swedish";s:2:"tl";s:7:"Tagalog";s:2:"th";s:4:"Thai";s:2:"tr";s:7:"Turkish";s:2:"uk";s:9:"Ukrainian";s:2:"vi";s:10:"Vietnamese";s:2:"cy";s:5:"Welsh";s:2:"yi";s:7:"Yiddish";} [googletools_analytics] => [googletools_verification] => dYkTRD9Vuq8prZmcypFGJCbOmON0uM0VbQC8egNQjiQ [google_api_key] => AIzaSyAvkUz6hiyP7lXP_YT2RDk9VMPIGNuFa1s [newsletters_items_limit] => 5 [description_chars_num] => 300 [newsletter_subscription] => 1 [newsletter_subscription_subject] => Newsletters from {%SITE_NAME%} [newsletter_subscription_body] =>

Thanks for subscribing to our newsletters at {%SITE_URL%}!

Please go to this page in order to choose topics you want to be subscribed to:

{%SITE_URL%}newsletters/?subscribe={%NEWSLETTERS_TOKEN%}

______________________________
Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[newsletter_send] => 1 [newsletter_send_subject] => Newsletters from {%SITE_NAME%} [newsletter_send_body] =>

Greetings!

Please check updates at {%SITE_URL%}.

==============================

{%NEWSLETTERS_CONTENT%}

To unsubscribe from the newsletters please use this link.

______________________________
Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[thank_you_for_payment] => Thank you for Payment! [thank_you_for_payment_body] =>

Thanks for your payment at {%SITE_URL%}!

______________________________
Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[favorite_listing_changed] =>

Greetings,

Status of {%LISTING%} has been changed to {%STATUS%}

______________________________
Thank you,
{%SITE_NAME%} Administration Team
{%SITE_URL%}

[one_of_favorite_listing_changed] => Status of your favorite listing has been changed. [extrasList] => realestate,paypal,kcaptcha,prettyphoto,banners,services,googletools,mailer,newsletters,importer,sheffieldproperty [estates_block_content] => [estates_display_sold] => 1 )

Array ( [PATH] => /sbin:/usr/sbin:/bin:/usr/bin [PP_CUSTOM_PHP_INI] => /var/www/vhosts/system/sheffieldproperty.info/etc/php.ini [PP_CUSTOM_PHP_CGI_INDEX] => plesk-php56-fastcgi [SCRIPT_NAME] => /system.php [REQUEST_URI] => /registration/ [QUERY_STRING] => _p=system&_p=registration/ [REQUEST_METHOD] => GET [SERVER_PROTOCOL] => HTTP/1.0 [GATEWAY_INTERFACE] => CGI/1.1 [REDIRECT_URL] => /registration/ [REDIRECT_QUERY_STRING] => _p=registration/ [REMOTE_PORT] => 50532 [SCRIPT_FILENAME] => /var/www/vhosts/sheffieldproperty.info/httpdocs/system.php [SERVER_ADMIN] => root@localhost [DOCUMENT_ROOT] => /var/www/vhosts/sheffieldproperty.info/httpdocs [REMOTE_ADDR] => 3.239.242.55 [SERVER_PORT] => 80 [SERVER_ADDR] => 87.239.17.180 [SERVER_NAME] => sheffieldproperty.info [SERVER_SOFTWARE] => Apache [SERVER_SIGNATURE] =>

Apache Server at sheffieldproperty.info Port 80

[HTTP_ACCEPT_ENCODING] => br,gzip [HTTP_IF_MODIFIED_SINCE] => Thu, 22 Oct 2020 11:45:18 GMT [HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5 [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 [HTTP_USER_AGENT] => CCBot/2.0 (https://commoncrawl.org/faq/) [HTTP_CONNECTION] => close [HTTP_X_FORWARDED_FOR] => 3.239.242.55 [HTTP_X_REAL_IP] => 3.239.242.55 [HTTP_HOST] => sheffieldproperty.info [REDIRECT_STATUS] => 200 [FCGI_ROLE] => RESPONDER [PHP_SELF] => /system.php [REQUEST_TIME_FLOAT] => 1611774670.6429 [REQUEST_TIME] => 1611774670 )

Array ( [error] => Array ( [0] => Unknown error type [8192]: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead
on line 76 in file includes/classes/ia.core.mysql.php [Backtrace] => Array ( [0] => in class iaCore::init()
on line [50] in file [includes/classes/ia.interfaces.php]

[1] => in class iaCore::factory("core", "db")
on line [71] in file [includes/classes/ia.core.php]

[2] => in class iaDb::init()
on line [676] in file [includes/classes/ia.core.php]

[3] => in class iaDb::_connect()
on line [66] in file [includes/classes/ia.core.mysql.php]

[4] => in function mysql_connect("localhost:3306", "SPadmin", "D4t4b4s3")
on line [76] in file [includes/classes/ia.core.mysql.php]

[5] => in class iaSystem::error(8192, "mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead", "/var/www/vhosts/sheffieldproperty.info/httpdocs/includes/classes/ia.core.mysql.php", 76, array()) ) [1] =>

[2] => Notice: Undefined index: fullname
on line 54 in file tmp/front_sheffieldproperty/e469425bbddf61f3751b39636d512e91054a7fce.file.render-menu.tpl.php [Backtrace] => Array ( [0] => in class iaCore::init()
on line [50] in file [includes/classes/ia.interfaces.php]

[1] => in class iaView::output()
on line [118] in file [includes/classes/ia.core.php]

[2] => in class iaSmarty::display("layout.tpl")
on line [1504] in file [includes/classes/ia.core.view.php]

[3] => in class Smarty_Internal_TemplateBase::display("/var/www/vhosts/sheffieldproperty.info/httpdocs/templates/sheffieldproperty/layout.tpl", , )
on line [179] in file [includes/classes/ia.core.smarty.php]

[4] => in class Smarty_Internal_TemplateBase::fetch("/var/www/vhosts/sheffieldproperty.info/httpdocs/templates/sheffieldproperty/layout.tpl", , , , true)
on line [344] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[5] => in function content_53f327f29c868(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[6] => in class iaSmartyPlugins::ia_section(array(), object(Smarty_Internal_Template))
on line [238] in file [tmp/front_sheffieldproperty/691904750855e55eb0b17583aaa9d3834b8afe13.file.layout.tpl.php]

[7] => in class Smarty_Internal_TemplateBase::fetch("render-blocks.tpl", "right1610")
on line [806] in file [includes/smarty3/SmartyPlugins.class.php]

[8] => in function content_53f327f2bdc95(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[9] => in class iaSmartyPlugins::blockView(array(), object(Smarty_Internal_Template))
on line [64] in file [tmp/front_sheffieldproperty/f0946515a10848c4d37c7be967f721319dfbf105.file.render-blocks.tpl.php]

[10] => in class Smarty_Internal_TemplateBase::fetch("render-menu.tpl")
on line [120] in file [includes/smarty3/SmartyPlugins.class.php]

[11] => in function content_53f327f2da23b(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[12] => in class iaSystem::error(8, "Undefined index: fullname", "/var/www/vhosts/sheffieldproperty.info/httpdocs/tmp/front_sheffieldproperty/e469425bbddf61f3751b39636d512e91054a7fce.file.render-menu.tpl.php", 54, array())
on line [54] in file [tmp/front_sheffieldproperty/e469425bbddf61f3751b39636d512e91054a7fce.file.render-menu.tpl.php]

) [3] =>

[4] => Notice: Undefined index: username
on line 54 in file tmp/front_sheffieldproperty/e469425bbddf61f3751b39636d512e91054a7fce.file.render-menu.tpl.php [Backtrace] => Array ( [0] => in class iaCore::init()
on line [50] in file [includes/classes/ia.interfaces.php]

[1] => in class iaView::output()
on line [118] in file [includes/classes/ia.core.php]

[2] => in class iaSmarty::display("layout.tpl")
on line [1504] in file [includes/classes/ia.core.view.php]

[5] => in function content_53f327f29c868(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[7] => in class Smarty_Internal_TemplateBase::fetch("render-blocks.tpl", "right1610")
on line [806] in file [includes/smarty3/SmartyPlugins.class.php]

[8] => in function content_53f327f2bdc95(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[10] => in class Smarty_Internal_TemplateBase::fetch("render-menu.tpl")
on line [120] in file [includes/smarty3/SmartyPlugins.class.php]

[11] => in function content_53f327f2da23b(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[12] => in class iaSystem::error(8, "Undefined index: username", "/var/www/vhosts/sheffieldproperty.info/httpdocs/tmp/front_sheffieldproperty/e469425bbddf61f3751b39636d512e91054a7fce.file.render-menu.tpl.php", 54, array())
on line [54] in file [tmp/front_sheffieldproperty/e469425bbddf61f3751b39636d512e91054a7fce.file.render-menu.tpl.php]

) [5] =>

[6] => Notice: Undefined index: fullname
on line 54 in file tmp/front_sheffieldproperty/e469425bbddf61f3751b39636d512e91054a7fce.file.render-menu.tpl.php [Backtrace] => Array ( [0] => in class iaCore::init()
on line [50] in file [includes/classes/ia.interfaces.php]

[1] => in class iaView::output()
on line [118] in file [includes/classes/ia.core.php]

[2] => in class iaSmarty::display("layout.tpl")
on line [1504] in file [includes/classes/ia.core.view.php]

[5] => in function content_53f327f29c868(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[7] => in class Smarty_Internal_TemplateBase::fetch("render-blocks.tpl", "right1610")
on line [806] in file [includes/smarty3/SmartyPlugins.class.php]

[8] => in function content_53f327f2bdc95(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[9] => in class iaSmartyPlugins::ia_block(array(), "  <div id="block_account" class="block box movable"> <div id="caption_account" class="box-caption-movable"> <h4>Account Menu</h4> <div class="box-caption-buttons"> </div> </div> <div id="content_account" class="box-content box-content-movable">  <div class="account-panel"> <div class="account-info"> <p> </p> </div> </div>  <ul class="nav nav-actions"> <li class="m_contact_sheffield_property"> <a href="Contact_Sheffield_Property/"> Contact Us </a> </li> <li class="m_sheffield_property_alerts"> <a href="sheffield_property_alerts/"> Property Alerts </a> </li> <li class="m_login"> <a href="login/" rel="nofollow"> Login </a> </li> <li class="m_member_registration active"> <a href="registration/" rel="nofollow"> Registration </a> </li> </ul>  </div></div> ", object(Smarty_Internal_Template), false)
on line [66] in file [tmp/front_sheffieldproperty/f0946515a10848c4d37c7be967f721319dfbf105.file.render-blocks.tpl.php]

[10] => in class Smarty_Internal_TemplateBase::fetch("render-menu.tpl")
on line [668] in file [includes/smarty3/SmartyPlugins.class.php]

[11] => in function content_53f327f2da23b(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

) [7] =>

[8] => Notice: Undefined index: username
on line 54 in file tmp/front_sheffieldproperty/e469425bbddf61f3751b39636d512e91054a7fce.file.render-menu.tpl.php [Backtrace] => Array ( [0] => in class iaCore::init()
on line [50] in file [includes/classes/ia.interfaces.php]

[1] => in class iaView::output()
on line [118] in file [includes/classes/ia.core.php]

[2] => in class iaSmarty::display("layout.tpl")
on line [1504] in file [includes/classes/ia.core.view.php]

[5] => in function content_53f327f29c868(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[7] => in class Smarty_Internal_TemplateBase::fetch("render-blocks.tpl", "right1610")
on line [806] in file [includes/smarty3/SmartyPlugins.class.php]

[8] => in function content_53f327f2bdc95(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

[10] => in class Smarty_Internal_TemplateBase::fetch("render-menu.tpl")
on line [668] in file [includes/smarty3/SmartyPlugins.class.php]

[11] => in function content_53f327f2da23b(object(Smarty_Internal_Template))
on line [165] in file [includes/smarty3/sysplugins/smarty_internal_templatebase.php]

) [9] =>

) )

Time		Sql
Core Queries
0.09 ms	1.	`SET NAMES 'utf8'`
0.12 ms	2.	*SELECT `name`,`code`,`type`,`extras`,`filename`,`pages`,`page_type`,`config` FRO ...* SELECT `name`,`code`,`type`,`extras`,`filename`,`pages`,`page_type`,`config` FROM `sbr237_hooks` WHERE `extras` IN('', 'realestate','paypal','kcaptcha','prettyphoto','banners','services','googletools','mailer','newsletters','importer','sheffieldproperty') AND `status` = 'active' ORDER BY `order`
0.05 ms	3.	*SELECT 1 FROM `sbr237_locations` WHERE `url` = 'registration/' AND `status` = 'a ...* SELECT 1 FROM `sbr237_locations` WHERE `url` = 'registration/' AND `status` = 'active'
0.04 ms	4.	*SELECT `name` FROM `sbr237_pages` WHERE `alias` = 'registration/' AND `status` ...* SELECT `name` FROM `sbr237_pages` WHERE `alias` = 'registration/' AND `status` = 'active' AND `extras` = 'realestate' LIMIT 0, 1
0.37 ms	5.	*SELECT `key`,`value` FROM `sbr237_language` WHERE `code` = 'en' AND `category` ...* SELECT `key`,`value` FROM `sbr237_language` WHERE `code` = 'en' AND `category` != 'tooltip' AND `category` != 'admin' ORDER BY `extras`
0.06 ms	6.	**SELECT FROM `sbr237_config_custom` WHERE (`type` = 'user' AND `type_id` = 0) ...*** SELECT * FROM `sbr237_config_custom` WHERE (`type` = 'user' AND `type_id` = 0) OR (`type` = 'group' AND `type_id` = 4)
0.05 ms	7.	*SELECT p.`id`, e.`type`, e.`url`, e.`title`, p.`name`, p.`alias`, p.`action`, p. ...* SELECT p.`id`, e.`type`, e.`url`, e.`title`, p.`name`, p.`alias`, p.`action`, p.`extras`, p.`filename`, p.`parent` , p.`meta_description` `description`, p.`meta_keywords` `keywords` FROM `sbr237_pages` p LEFT JOIN `sbr237_extras` e ON (e.`name` = p.`extras`) WHERE (p.`name` = 'registration' OR p.`alias` = 'registration' OR p.`alias` LIKE 'registration/%') AND p.`status` = 'active' AND (e.`status` = 'active' OR e.`status` IS NULL) ORDER BY LENGTH(p.`alias`) DESC, p.`extras` DESC
0.04 ms	8.	*SELECT `name`,`url`,`title` FROM `sbr237_extras` WHERE `type` = 'package' AND ` ...* SELECT `name`,`url`,`title` FROM `sbr237_extras` WHERE `type` = 'package' AND `status` = 'active'
0.07 ms	9.	**SELECT FROM `sbr237_acl_objects`*** SELECT * FROM `sbr237_acl_objects`
0.05 ms	10.	**SELECT FROM `sbr237_acl_privileges` WHERE (`type` = 'user' AND `type_id` = '0 ...*** SELECT * FROM `sbr237_acl_privileges` WHERE (`type` = 'user' AND `type_id` = '0') OR (`type` = 'group' AND `type_id` = '4')
0.36 ms	11.	**SELECT FROM `sbr237_banners` WHERE `status` = 'active'*** SELECT * FROM `sbr237_banners` WHERE `status` = 'active'
0.04 ms	12.	*SELECT `block_id`,`amount_displayed` FROM `sbr237_banners_block_options`* SELECT `block_id`,`amount_displayed` FROM `sbr237_banners_block_options`
0.07 ms	13.	**SELECT FROM `sbr237_blocks` WHERE `status` = 'active' AND `extras` IN ('', 'r ...*** SELECT * FROM `sbr237_blocks` WHERE `status` = 'active' AND `extras` IN ('', 'realestate','paypal','kcaptcha','prettyphoto','banners','services','googletools','mailer','newsletters','importer','sheffieldproperty') ORDER BY `order`
0.04 ms	14.	**SELECT FROM `sbr237_actions` WHERE `status` = 'blocks'*** SELECT * FROM `sbr237_actions` WHERE `status` = 'blocks'
0.04 ms	15.	*SELECT `block_id`,`id` FROM `sbr237_blocks_pages` WHERE `page_name` = 'member_r ...* SELECT `block_id`,`id` FROM `sbr237_blocks_pages` WHERE `page_name` = 'member_registration'
0.06 ms	16.	*SELECT `id`, `alias`, `custom_url`, `name`, `parent`, `action` FROM `sbr237_page ...* SELECT `id`, `alias`, `custom_url`, `name`, `parent`, `action` FROM `sbr237_pages` WHERE `status` = 'active' AND `extras` IN ('', 'realestate','paypal','kcaptcha','prettyphoto','banners','services','googletools','mailer','newsletters','importer','sheffieldproperty')
0.81 ms	17.	**SELECT SQL_CALC_FOUND_ROWS e., l.`url`, l.`title` `location`, (SELECT `title` F ...*** SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` FROM `sbr237_locations` WHERE `id` = t.`parent`) `state` FROM `sbr237_estates` e LEFT JOIN `sbr237_locations` l ON (l.`id` = e.`location_id`) LEFT JOIN `sbr237_locations_tree` t ON (t.`nid` = e.`location_id`) WHERE 1 = 1 AND e.`featured` = '1' AND e.`status` IN ('available','sold') ORDER BY RAND() LIMIT 0, 8
0.05 ms	18.	*SELECT `values` FROM `sbr237_fields` WHERE `name` = 'type' AND `item` = 'estate ...* SELECT `values` FROM `sbr237_fields` WHERE `name` = 'type' AND `item` = 'estates' LIMIT 0, 1
0.04 ms	19.	*SELECT `values` FROM `sbr237_fields` WHERE `name` = 'bathrooms' AND `item` = 'e ...* SELECT `values` FROM `sbr237_fields` WHERE `name` = 'bathrooms' AND `item` = 'estates' LIMIT 0, 1
0.04 ms	20.	*SELECT `values` FROM `sbr237_fields` WHERE `name` = 'bedrooms' AND `item` = 'es ...* SELECT `values` FROM `sbr237_fields` WHERE `name` = 'bedrooms' AND `item` = 'estates' LIMIT 0, 1
0.04 ms	21.	*SELECT `values` FROM `sbr237_fields` WHERE `name` = 'category' AND `item` = 'es ...* SELECT `values` FROM `sbr237_fields` WHERE `name` = 'category' AND `item` = 'estates' LIMIT 0, 1
1.57 ms	22.	*SELECT d.`title` `title`, d.`url` `url`, p.`code` `abbreviation` FROM `sbr237_lo ...* SELECT d.`title` `title`, d.`url` `url`, p.`code` `abbreviation` FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.`nid` = d.`id`) LEFT JOIN `sbr237_locations` p ON (t.`parent` = p.`id` AND p.`status` = 'active') WHERE d.`status` = 'active' AND t.`level` > '1' ORDER BY d.`num_listings` DESC, RAND() LIMIT 0, 15
0.06 ms	23.	**SELECT SQL_CALC_FOUND_ROWS e., l.`url`, l.`title` `location`, (SELECT `title` F ...*** SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` FROM `sbr237_locations` WHERE `id` = t.`parent`) `state` FROM `sbr237_estates` e LEFT JOIN `sbr237_locations` l ON (l.`id` = e.`location_id`) LEFT JOIN `sbr237_locations_tree` t ON (t.`nid` = e.`location_id`) WHERE 1 = 1 AND e.`status` IN ('available','sold') ORDER BY e.`sponsored` DESC, e.`date_modified` DESC LIMIT 0, 10
0.04 ms	24.	DUPLICATED *SELECT `values` FROM `sbr237_fields` WHERE `name` = 'type' AND `item` = 'estate ...* SELECT `values` FROM `sbr237_fields` WHERE `name` = 'type' AND `item` = 'estates' LIMIT 0, 1
0.05 ms	25.	DUPLICATED **SELECT SQL_CALC_FOUND_ROWS e., l.`url`, l.`title` `location`, (SELECT `title` F ...*** SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` FROM `sbr237_locations` WHERE `id` = t.`parent`) `state` FROM `sbr237_estates` e LEFT JOIN `sbr237_locations` l ON (l.`id` = e.`location_id`) LEFT JOIN `sbr237_locations_tree` t ON (t.`nid` = e.`location_id`) WHERE 1 = 1 AND e.`status` IN ('available','sold') ORDER BY e.`sponsored` DESC, e.`date_modified` DESC LIMIT 0, 10
0.05 ms	26.	**SELECT d. FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.` ...*** SELECT d.* FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.`nid` = d.`id`) WHERE d.`status` = 'active' AND t.`level` > '1' ORDER BY d.`num_listings` DESC LIMIT 0, 20
0.06 ms	27.	DUPLICATED **SELECT d. FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.` ...*** SELECT d.* FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.`nid` = d.`id`) WHERE d.`status` = 'active' AND t.`level` > '1' ORDER BY d.`num_listings` DESC LIMIT 0, 20
0.05 ms	28.	**SELECT d. FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.` ...*** SELECT d.* FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.`nid` = d.`id`) WHERE d.`status` = 'active' AND t.`level` = '1' ORDER BY d.`num_listings` DESC LIMIT 0, 12
0.08 ms	29.	**SELECT FROM `sbr237_accounts` WHERE `featured` = 1*** SELECT * FROM `sbr237_accounts` WHERE `featured` = 1
0.05 ms	30.	*SELECT `id`, `id`, `days`, `cost`, `data` FROM `sbr237_plans` WHERE `item` = 'a ...* SELECT `id`, `id`, `days`, `cost`, `data` FROM `sbr237_plans` WHERE `item` = 'accounts' AND `status` = 'active' ORDER BY `order` ASC
0.06 ms	31.	**SELECT `f`., (SELECT GROUP_CONCAT(CONCAT(`element`,'-',`child`)) FROM `sbr237_f ...*** SELECT `f`.*, (SELECT GROUP_CONCAT(CONCAT(`element`,'-',`child`)) FROM `sbr237_fields_relations` fr WHERE fr.`field` = f.`name` AND fr.`item` = f.`item`) as `children` FROM `sbr237_fields_pages` fp LEFT JOIN `sbr237_fields` `f` ON (fp.`field_id` = f.`id`) WHERE `fp`.`page_name` = 'member_registration' AND f.`status` = 'active' AND f.`item` = 'accounts' AND f.`adminonly` = 0 GROUP BY f.`id` ORDER BY f.`order`
0.04 ms	32.	*SELECT `id`,`name`,`order`,`collapsed` FROM `sbr237_fields_groups` WHERE `item` ...* SELECT `id`,`name`,`order`,`collapsed` FROM `sbr237_fields_groups` WHERE `item` = 'accounts' ORDER BY `order`
0.04 ms	33.	*SELECT `id`,`name`,`alias`,`nofollow`,`menus`,`group`,`action` FROM `sbr237_page ...* SELECT `id`,`name`,`alias`,`nofollow`,`menus`,`group`,`action` FROM `sbr237_pages` WHERE `status` = 'active' AND `menus` != '' ORDER BY `order`
0.04 ms	34.	DUPLICATED **SELECT FROM `sbr237_config_custom` WHERE (`type` = 'user' AND `type_id` = 0) ...*** SELECT * FROM `sbr237_config_custom` WHERE (`type` = 'user' AND `type_id` = 0) OR (`type` = 'group' AND `type_id` = 4)
0.29 ms	35.	*UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '3'* UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '3'
0.22 ms	36.	*UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '2'* UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '2'
0.16 ms	37.	*UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '1'* UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '1'

Time

Sql

Core Queries

0.09 ms

SET NAMES 'utf8'

0.12 ms

SELECT `name`,`code`,`type`,`extras`,`filename`,`pages`,`page_type`,`config` FRO ...

SELECT `name`,`code`,`type`,`extras`,`filename`,`pages`,`page_type`,`config` 
   FROM `sbr237_hooks`  
   WHERE `extras` IN('', 'realestate','paypal','kcaptcha','prettyphoto','banners','services','googletools','mailer','newsletters','importer','sheffieldproperty') AND `status` = 'active' 
   ORDER BY `order`

0.05 ms

SELECT 1 FROM `sbr237_locations` WHERE `url` = 'registration/' AND `status` = 'a ...

SELECT 1 
   FROM `sbr237_locations` 
   WHERE `url` = 'registration/' AND `status` = 'active'

0.04 ms

SELECT `name` FROM `sbr237_pages` WHERE `alias` = 'registration/' AND `status` ...

SELECT `name` 
   FROM `sbr237_pages`  
   WHERE `alias` = 'registration/' AND `status` = 'active' AND `extras` = 'realestate' 
   LIMIT 0, 1

0.37 ms

SELECT `key`,`value` FROM `sbr237_language` WHERE `code` = 'en' AND `category` ...

SELECT `key`,`value` 
   FROM `sbr237_language`  
   WHERE `code` = 'en' AND `category` != 'tooltip' AND `category` != 'admin' 
   ORDER BY `extras`

0.06 ms

SELECT * FROM `sbr237_config_custom` WHERE (`type` = 'user' AND `type_id` = 0) ...

SELECT * 
   FROM `sbr237_config_custom`  
   WHERE (`type` = 'user' AND `type_id` = 0)  OR (`type` = 'group' AND `type_id` = 4)

0.05 ms

SELECT p.`id`, e.`type`, e.`url`, e.`title`, p.`name`, p.`alias`, p.`action`, p. ...

SELECT p.`id`, e.`type`, e.`url`, e.`title`, p.`name`, p.`alias`, p.`action`, p.`extras`, p.`filename`, p.`parent` , p.`meta_description` `description`, p.`meta_keywords` `keywords` 
   FROM `sbr237_pages` p 
      LEFT JOIN `sbr237_extras` e
         ON (e.`name` = p.`extras`) 
   WHERE (p.`name` = 'registration' OR p.`alias` = 'registration' OR p.`alias` LIKE 'registration/%') AND p.`status` = 'active' AND (e.`status` = 'active' OR e.`status` IS NULL) 
   ORDER BY LENGTH(p.`alias`) DESC, p.`extras` DESC

0.04 ms

SELECT `name`,`url`,`title` FROM `sbr237_extras` WHERE `type` = 'package' AND ` ...

SELECT `name`,`url`,`title` 
   FROM `sbr237_extras`  
   WHERE `type` = 'package' AND `status` = 'active'

0.07 ms

SELECT * FROM `sbr237_acl_objects`

SELECT * 
   FROM `sbr237_acl_objects`

0.05 ms

10.

SELECT * FROM `sbr237_acl_privileges` WHERE (`type` = 'user' AND `type_id` = '0 ...

SELECT * 
   FROM `sbr237_acl_privileges`  
   WHERE (`type` = 'user' AND `type_id` = '0') OR (`type` = 'group' AND `type_id` = '4')

0.36 ms

11.

SELECT * FROM `sbr237_banners` WHERE `status` = 'active'

SELECT * 
   FROM `sbr237_banners`  
   WHERE `status` = 'active'

0.04 ms

12.

SELECT `block_id`,`amount_displayed` FROM `sbr237_banners_block_options`

SELECT `block_id`,`amount_displayed` 
   FROM `sbr237_banners_block_options`

0.07 ms

13.

SELECT * FROM `sbr237_blocks` WHERE `status` = 'active' AND `extras` IN ('', 'r ...

SELECT * 
   FROM `sbr237_blocks`  
   WHERE `status` = 'active' AND `extras` IN ('', 'realestate','paypal','kcaptcha','prettyphoto','banners','services','googletools','mailer','newsletters','importer','sheffieldproperty') 
   ORDER BY `order`

0.04 ms

14.

SELECT * FROM `sbr237_actions` WHERE `status` = 'blocks'

SELECT * 
   FROM `sbr237_actions`  
   WHERE `status` = 'blocks'

0.04 ms

15.

SELECT `block_id`,`id` FROM `sbr237_blocks_pages` WHERE `page_name` = 'member_r ...

SELECT `block_id`,`id` 
   FROM `sbr237_blocks_pages`  
   WHERE `page_name` = 'member_registration'

0.06 ms

16.

SELECT `id`, `alias`, `custom_url`, `name`, `parent`, `action` FROM `sbr237_page ...

SELECT `id`, `alias`, `custom_url`, `name`, `parent`, `action` 
   FROM `sbr237_pages`  
   WHERE `status` = 'active' AND `extras` IN ('', 'realestate','paypal','kcaptcha','prettyphoto','banners','services','googletools','mailer','newsletters','importer','sheffieldproperty')

0.81 ms

17.

SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` F ...

SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` 
   FROM `sbr237_locations` 
   WHERE `id` = t.`parent`) `state`
   FROM `sbr237_estates` e 
      LEFT JOIN `sbr237_locations` l
         ON (l.`id` = e.`location_id`) 
      LEFT JOIN `sbr237_locations_tree` t
         ON (t.`nid` = e.`location_id`) 
   WHERE 1 = 1 AND e.`featured` = '1' AND e.`status` IN ('available','sold') 
   ORDER BY  RAND() 
   LIMIT 0, 8

0.05 ms

18.

SELECT `values` FROM `sbr237_fields` WHERE `name` = 'type' AND `item` = 'estate ...

SELECT `values` 
   FROM `sbr237_fields`  
   WHERE `name` = 'type' AND `item` = 'estates' 
   LIMIT 0, 1

0.04 ms

19.

SELECT `values` FROM `sbr237_fields` WHERE `name` = 'bathrooms' AND `item` = 'e ...

SELECT `values` 
   FROM `sbr237_fields`  
   WHERE `name` = 'bathrooms' AND `item` = 'estates' 
   LIMIT 0, 1

0.04 ms

20.

SELECT `values` FROM `sbr237_fields` WHERE `name` = 'bedrooms' AND `item` = 'es ...

SELECT `values` 
   FROM `sbr237_fields`  
   WHERE `name` = 'bedrooms' AND `item` = 'estates' 
   LIMIT 0, 1

0.04 ms

21.

SELECT `values` FROM `sbr237_fields` WHERE `name` = 'category' AND `item` = 'es ...

SELECT `values` 
   FROM `sbr237_fields`  
   WHERE `name` = 'category' AND `item` = 'estates' 
   LIMIT 0, 1

1.57 ms

22.

SELECT d.`title` `title`, d.`url` `url`, p.`code` `abbreviation` FROM `sbr237_lo ...

SELECT d.`title` `title`, d.`url` `url`, p.`code` `abbreviation` 
   FROM `sbr237_locations` d 
      LEFT JOIN `sbr237_locations_tree` t
         ON (t.`nid` = d.`id`) 
      LEFT JOIN `sbr237_locations` p
         ON (t.`parent` = p.`id` AND p.`status` = 'active') 
   WHERE d.`status` = 'active' AND t.`level` > '1' 
   ORDER BY d.`num_listings` DESC, RAND() 
   LIMIT 0, 15

0.06 ms

23.

SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` F ...

SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` 
   FROM `sbr237_locations` 
   WHERE `id` = t.`parent`) `state`
   FROM `sbr237_estates` e 
      LEFT JOIN `sbr237_locations` l
         ON (l.`id` = e.`location_id`) 
      LEFT JOIN `sbr237_locations_tree` t
         ON (t.`nid` = e.`location_id`) 
   WHERE 1 = 1 AND e.`status` IN ('available','sold') 
   ORDER BY e.`sponsored` DESC, e.`date_modified` DESC 
   LIMIT 0, 10

0.04 ms

24.

DUPLICATED

SELECT `values` FROM `sbr237_fields` WHERE `name` = 'type' AND `item` = 'estate ...

SELECT `values` 
   FROM `sbr237_fields`  
   WHERE `name` = 'type' AND `item` = 'estates' 
   LIMIT 0, 1

0.05 ms

25.

DUPLICATED

SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` F ...

SELECT SQL_CALC_FOUND_ROWS e.*, l.`url`, l.`title` `location`, (SELECT `title` 
   FROM `sbr237_locations` 
   WHERE `id` = t.`parent`) `state`
   FROM `sbr237_estates` e 
      LEFT JOIN `sbr237_locations` l
         ON (l.`id` = e.`location_id`) 
      LEFT JOIN `sbr237_locations_tree` t
         ON (t.`nid` = e.`location_id`) 
   WHERE 1 = 1 AND e.`status` IN ('available','sold') 
   ORDER BY e.`sponsored` DESC, e.`date_modified` DESC 
   LIMIT 0, 10

0.05 ms

26.

SELECT d.* FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.` ...

SELECT d.* 
   FROM `sbr237_locations` d 
      LEFT JOIN `sbr237_locations_tree` t
         ON (t.`nid` = d.`id`)  
   WHERE d.`status` = 'active' AND t.`level` > '1' 
   ORDER BY d.`num_listings` DESC 
   LIMIT 0, 20

0.06 ms

27.

DUPLICATED

SELECT d.* FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.` ...

SELECT d.* 
   FROM `sbr237_locations` d 
      LEFT JOIN `sbr237_locations_tree` t
         ON (t.`nid` = d.`id`)  
   WHERE d.`status` = 'active' AND t.`level` > '1' 
   ORDER BY d.`num_listings` DESC 
   LIMIT 0, 20

0.05 ms

28.

SELECT d.* FROM `sbr237_locations` d LEFT JOIN `sbr237_locations_tree` t ON (t.` ...

SELECT d.* 
   FROM `sbr237_locations` d 
      LEFT JOIN `sbr237_locations_tree` t
         ON (t.`nid` = d.`id`)  
   WHERE d.`status` = 'active' AND t.`level` = '1' 
   ORDER BY d.`num_listings` DESC 
   LIMIT 0, 12

0.08 ms

29.

SELECT * FROM `sbr237_accounts` WHERE `featured` = 1

SELECT * 
   FROM `sbr237_accounts`  
   WHERE `featured` = 1

0.05 ms

30.

SELECT `id`, `id`, `days`, `cost`, `data` FROM `sbr237_plans` WHERE `item` = 'a ...

SELECT `id`, `id`, `days`, `cost`, `data` 
   FROM `sbr237_plans`  
   WHERE `item` = 'accounts' AND `status` = 'active' 
   ORDER BY `order` ASC

0.06 ms

31.

SELECT `f`.*, (SELECT GROUP_CONCAT(CONCAT(`element`,'-',`child`)) FROM `sbr237_f ...

SELECT `f`.*, (SELECT GROUP_CONCAT(CONCAT(`element`,'-',`child`)) 
   FROM `sbr237_fields_relations` fr 
   WHERE fr.`field` = f.`name` AND fr.`item` = f.`item`) as `children`
                  
   FROM `sbr237_fields_pages` fp
                  
      LEFT JOIN `sbr237_fields` `f`
         ON (fp.`field_id` = f.`id`)
               
   WHERE `fp`.`page_name` = 'member_registration' AND f.`status` = 'active' AND f.`item` = 'accounts' AND f.`adminonly` = 0  
   GROUP BY f.`id` 
   ORDER BY f.`order`

0.04 ms

32.

SELECT `id`,`name`,`order`,`collapsed` FROM `sbr237_fields_groups` WHERE `item` ...

SELECT `id`,`name`,`order`,`collapsed` 
   FROM `sbr237_fields_groups`  
   WHERE `item` = 'accounts' 
   ORDER BY `order`

0.04 ms

33.

SELECT `id`,`name`,`alias`,`nofollow`,`menus`,`group`,`action` FROM `sbr237_page ...

SELECT `id`,`name`,`alias`,`nofollow`,`menus`,`group`,`action` 
   FROM `sbr237_pages`  
   WHERE `status` = 'active' AND `menus` != '' 
   ORDER BY `order`

0.04 ms

34.

DUPLICATED

SELECT * FROM `sbr237_config_custom` WHERE (`type` = 'user' AND `type_id` = 0) ...

SELECT * 
   FROM `sbr237_config_custom`  
   WHERE (`type` = 'user' AND `type_id` = 0)  OR (`type` = 'group' AND `type_id` = 4)

0.29 ms

35.

UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '3'

UPDATE `sbr237_banners` SET `showed` = `showed` + '1' 
   WHERE `id` = '3'

0.22 ms

36.

UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '2'

UPDATE `sbr237_banners` SET `showed` = `showed` + '1' 
   WHERE `id` = '2'

0.16 ms

37.

UPDATE `sbr237_banners` SET `showed` = `showed` + '1' WHERE `id` = '1'

UPDATE `sbr237_banners` SET `showed` = `showed` + '1' 
   WHERE `id` = '1'

Array ( [0] => in class iaCore::init()
on line [50] in file [includes/classes/ia.interfaces.php]