Retirement Villages in Kangy Angy New South Wales

done loading required files

loading adodb

loading page functions

loading content functions

loading translation functions

loading php4 entity decode functions

done loading files

Initialize Database

(mysqli): SET NAMES 'utf8'

Done Initializing Database

Initialize Smarty

Loading /home/retire/public_html/lib/classes/class.Smarty_CMS.php = 682960 bytes for an approximate total of 682960

Loading /home/retire/public_html/lib/classes/class.CMSModuleDbTemplateResource.php = 24192 bytes for an approximate total of 707152

Loading /home/retire/public_html/lib/classes/class.CMSPageTemplateResource.php = 16192 bytes for an approximate total of 723344

Loading /home/retire/public_html/lib/classes/class.usertagoperations.inc.php = 20904 bytes for an approximate total of 744248

(mysqli): SELECT * FROM cms_userplugins ORDER BY userplugin_name

Loading /home/retire/public_html/lib/classes/class.cms_siteprefs.php = 9416 bytes for an approximate total of 753664

(mysqli): SELECT sitepref_name,sitepref_value FROM cms_siteprefs

Loading /home/retire/public_html/lib/classes/class.CMSContentTemplateResource.php = 6712 bytes for an approximate total of 760376

Loading /home/retire/public_html/lib/classes/class.CMSGlobalContentTemplateResource.php = 5408 bytes for an approximate total of 765784

Done Initialiing Smarty

Loading /home/retire/public_html/lib/classes/class.moduleoperations.inc.php = 139416 bytes for an approximate total of 905200

(mysqli): SELECT * FROM cms_modules ORDER BY module_name

loading module AceEditor

Loading /home/retire/public_html/lib/classes/class.CMSModule.php = 258304 bytes for an approximate total of 1163504

Loading /home/retire/public_html/lib/classes/class.CmsLangOperations.php = 22736 bytes for an approximate total of 1186240

loading module Captcha

loading module CGBlog

Loading /home/retire/public_html/lib/classes/class.CmsNlsOperations.php = 29392 bytes for an approximate total of 1215632

Loading /home/retire/public_html/lib/classes/class.CmsNls.php = 17272 bytes for an approximate total of 1232904

Loading /home/retire/public_html/lib/classes/class.cms_utils.php = 26656 bytes for an approximate total of 1259560

(mysqli): SET @CG_ZEROTIME = NOW() - INTERVAL 150 YEAR,@CG_FUTURETIME = NOW() + INTERVAL 5 YEAR

loading module CGSimpleSmarty

Loading /home/retire/public_html/lib/classes/class.CmsRoute.php = 15896 bytes for an approximate total of 1275456

Loading /home/retire/public_html/lib/classes/class.cms_route_manager.php = 30560 bytes for an approximate total of 1306016

(mysqli): SELECT cgblog_id,url FROM cms_module_cgblog WHERE url != '' AND status = 'published' AND COALESCE(start_time,@CG_ZEROTIME) < NOW() AND COALESCE(end_time,@CG_FUTURETIME) > NOW() ORDER BY cgblog_date DESC

loading module CGFBPost

loading module CGSmartImage

loading module CGSocialBlaster

loading module CGTiny

loading module CMSPrinting

loading module CustomContent

loading module FrontEndUsers

loading module CMSMailer

Loading /home/retire/public_html/lib/classes/class.contentoperations.inc.php = 111128 bytes for an approximate total of 1417144

Loading /home/retire/public_html/lib/classes/class.module_meta.php = 22424 bytes for an approximate total of 1439568

loading module AdvancedContent

Loading /home/retire/public_html/lib/classes/class.cms_module_smarty_plugin_manager.php = 27080 bytes for an approximate total of 1466648

(mysqli): SELECT * FROM cms_module_smarty_plugins ORDER BY module

loading module FormBuilder

loading module JQueryTools

loading module MenuManager

loading module NetBookings

loading module SelfRegistration

loading module TinyMCE

Loading /home/retire/public_html/lib/classes/class.CmsRegularTaskHandler.php = 16632 bytes for an approximate total of 1483280

Loading /home/retire/public_html/lib/classes/class.cms_content_cache.php = 77400 bytes for an approximate total of 1560680

(mysqli): SELECT * FROM cms_content WHERE content_alias = 'retirement-search-results' AND active = 1 LIMIT  1

Loading /home/retire/public_html/lib/classes/class.ContentBase.php = 216232 bytes for an approximate total of 1776912

Loading /home/retire/public_html/lib/classes/contenttypes/Content.inc.php = 291848 bytes for an approximate total of 2068760

(mysqli): SELECT * FROM cms_content_props WHERE content_id = '57'

process template top

Loading /home/retire/public_html/lib/classes/class.Events.php = 50248 bytes for an approximate total of 2119008

(mysqli): SELECT eh.tag_name, eh.module_name, e.originator, e.event_name, eh.handler_order, eh.handler_id, eh.removable FROM cms_event_handlers eh
        INNER JOIN cms_events e ON e.event_id = eh.event_id
        ORDER BY eh.handler_order ASC

Loading /home/retire/public_html/lib/classes/class.templateoperations.inc.php = 47064 bytes for an approximate total of 2166072

(mysqli): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date 
                      FROM cms_templates WHERE template_id = '26' LIMIT  1

Loading /home/retire/public_html/lib/classes/class.CMS_Content_Block.php = 51152 bytes for an approximate total of 2217224

process template body

(mysqli): SELECT modified_date FROM cms_content ORDER BY modified_date DESC LIMIT  1

Content tree file needs loading

Loading /home/retire/public_html/lib/classes/class.cms_tree.php = 16168 bytes for an approximate total of 2233392

Loading /home/retire/public_html/lib/classes/class.cms_content_tree.php = 40032 bytes for an approximate total of 2273424

Loading /home/retire/public_html/modules/CGExtensions/lib/class.cge_tmpdata.php = 4568 bytes for an approximate total of 2277992

Loading /home/retire/public_html/modules/CGExtensions/lib/class.cge_utils.php = 66240 bytes for an approximate total of 2344232

Loading /home/retire/public_html/modules/CGExtensions/lib/class.Browser.php = 304840 bytes for an approximate total of 2649072

Loading /home/retire/public_html/modules/CGExtensions/lib/class.cge_browser.php = 362088 bytes for an approximate total of 3011160

(mysqli): SELECT * FROM cms_module_nb_cities n
             WHERE n.state = 'new south wales'
             AND n.name = 'kangy angy'

(mysqli): SELECT * FROM cms_module_nb_cities n
             WHERE n.state = 'new south wales'
             AND n.name = 'kangy angy'

(mysqli): SELECT count(distinct c.id) as count, if(c.city = 'kangy angy', 0, if(c.lat + c.lng is null, 999999999, 6378.7 * acos(sin('-33.3503' / 57.2958) * sin(c.lat / 57.2958) + cos('-33.3503' / 57.2958) * cos(c.lat/57.2958) *  cos(c.lng / 57.2958 - '151.35' / 57.2958)))), c.* FROM cms_module_nb_companies c LEFT JOIN cms_module_nb_acr_companies a on a.id = c.acr_id LEFT JOIN cms_module_nb_vacancy v1 on v1.company_id = c.id and v1.active = 'Y' WHERE (c.enabled = 'Y' or c.enabled = 'M') AND (c.platinum <> 'Y' or c.platinum is null) AND ((c.city = 'kangy angy') or (6378.7 * acos(sin('-33.3503' / 57.2958) * sin(c.lat / 57.2958) + cos('-33.3503' / 57.2958) * cos(lat/57.2958) *  cos(c.lng / 57.2958 - '151.35' / 57.2958)) < '10')) AND (c.state = 'new south wales') AND (c.classification = 'retirement') LIMIT  1

(mysqli): SELECT if(c.city = 'kangy angy', True, False) as citymatch,  if(c.rating < 1000, c.rating, 1000) as ratingcrap,
               if(c.lat + c.lng is null, 999999999, 6378.7 * acos(sin('-33.3503' / 57.2958) * sin(c.lat / 57.2958) + cos('-33.3503' / 57.2958) * cos(c.lat/57.2958) *  cos(c.lng / 57.2958 - '151.35' / 57.2958))) as radius, min(v1.rad) as minrad, max(v1.rad) as maxrad, c.*,
                 a.rating as acr_rating, a.rating_type, a.date_rated, a.expiry_date, a.rating_page, a.rating_badge_url_4, a.comments,
                (SELECT count(id) FROM cms_module_nb_review r WHERE company_id = c.id and r.enabled = "Y") as reviews FROM cms_module_nb_companies c LEFT JOIN cms_module_nb_acr_companies a on a.id = c.acr_id LEFT JOIN cms_module_nb_vacancy v1 on v1.company_id = c.id and v1.active = 'Y' WHERE (c.enabled = 'Y' or c.enabled = 'M') AND (c.platinum <> 'Y' or c.platinum is null) AND ((c.city = 'kangy angy') or (6378.7 * acos(sin('-33.3503' / 57.2958) * sin(c.lat / 57.2958) + cos('-33.3503' / 57.2958) * cos(lat/57.2958) *  cos(c.lng / 57.2958 - '151.35' / 57.2958)) < '10')) AND (c.state = 'new south wales') AND (c.classification = 'retirement') GROUP BY c.id ORDER BY listing_type ASC, citymatch DESC, ratingcrap, radius ASC, ISNULL(c.rating), c.rating, c.company_name LIMIT 0, 20

(mysqli): SELECT vacancy_type, count(id) AS vacancy_count_active FROM cms_module_nb_vacancy v
      WHERE company_id = '132'
      AND active = 'Y'
      GROUP BY vacancy_type

(mysqli): SELECT vacancy_type, count(id) AS vacancy_count_vacant FROM cms_module_nb_vacancy v
      WHERE company_id = '132'
      AND active = 'Y'
      AND vacant = 'Y'
      GROUP BY vacancy_type

(mysqli): SELECT name FROM cms_module_nb_gallery
      WHERE company_id = '132'
      ORDER BY sequence

(mysqli): SELECT company_name as name, classification, name_alias FROM cms_module_nb_companies WHERE id = '132'

(mysqli): SELECT c.* FROM cms_module_nb_companies c WHERE c.id = '132'

(mysqli): SELECT * FROM cms_module_nb_types WHERE category = 'retirement' ORDER BY sequence

Loading /home/retire/public_html/modules/CGExtensions/lib/class.cge_array.php = 38272 bytes for an approximate total of 3049432

(mysqli): SELECT c.* FROM cms_module_nb_company_types c WHERE c.company_id = '132'

(mysqli): SELECT * FROM cms_module_nb_lifestyles

(mysqli): SELECT c.* FROM cms_module_nb_company_lifestyles c WHERE c.company_id = '132'

(mysqli): SELECT vacancy_type, count(id) AS vacancy_count_active FROM cms_module_nb_vacancy v
      WHERE company_id = '35'
      AND active = 'Y'
      GROUP BY vacancy_type

(mysqli): SELECT vacancy_type, count(id) AS vacancy_count_vacant FROM cms_module_nb_vacancy v
      WHERE company_id = '35'
      AND active = 'Y'
      AND vacant = 'Y'
      GROUP BY vacancy_type

(mysqli): SELECT name FROM cms_module_nb_gallery
      WHERE company_id = '35'
      ORDER BY sequence

(mysqli): SELECT company_name as name, classification, name_alias FROM cms_module_nb_companies WHERE id = '3299'

(mysqli): SELECT c.* FROM cms_module_nb_companies c WHERE c.id = '35'

(mysqli): SELECT * FROM cms_module_nb_types WHERE category = 'retirement' ORDER BY sequence

(mysqli): SELECT c.* FROM cms_module_nb_company_types c WHERE c.company_id = '35'

(mysqli): SELECT * FROM cms_module_nb_lifestyles

(mysqli): SELECT c.* FROM cms_module_nb_company_lifestyles c WHERE c.company_id = '35'

(mysqli): SELECT vacancy_type, count(id) AS vacancy_count_active FROM cms_module_nb_vacancy v
      WHERE company_id = '30'
      AND active = 'Y'
      GROUP BY vacancy_type

(mysqli): SELECT vacancy_type, count(id) AS vacancy_count_vacant FROM cms_module_nb_vacancy v
      WHERE company_id = '30'
      AND active = 'Y'
      AND vacant = 'Y'
      GROUP BY vacancy_type

(mysqli): SELECT name FROM cms_module_nb_gallery
      WHERE company_id = '30'
      ORDER BY sequence

(mysqli): SELECT company_name as name, classification, name_alias FROM cms_module_nb_companies WHERE id = '30'

(mysqli): SELECT c.* FROM cms_module_nb_companies c WHERE c.id = '30'

(mysqli): SELECT * FROM cms_module_nb_types WHERE category = 'retirement' ORDER BY sequence

(mysqli): SELECT c.* FROM cms_module_nb_company_types c WHERE c.company_id = '30'

(mysqli): SELECT * FROM cms_module_nb_lifestyles

(mysqli): SELECT c.* FROM cms_module_nb_company_lifestyles c WHERE c.company_id = '30'

(mysqli): SELECT vacancy_type, count(id) AS vacancy_count_active FROM cms_module_nb_vacancy v
      WHERE company_id = '33'
      AND active = 'Y'
      GROUP BY vacancy_type

(mysqli): SELECT vacancy_type, count(id) AS vacancy_count_vacant FROM cms_module_nb_vacancy v
      WHERE company_id = '33'
      AND active = 'Y'
      AND vacant = 'Y'
      GROUP BY vacancy_type

(mysqli): SELECT name FROM cms_module_nb_gallery
      WHERE company_id = '33'
      ORDER BY sequence

(mysqli): SELECT company_name as name, classification, name_alias FROM cms_module_nb_companies WHERE id = '33'

(mysqli): SELECT c.* FROM cms_module_nb_companies c WHERE c.id = '33'

(mysqli): SELECT * FROM cms_module_nb_types WHERE category = 'retirement' ORDER BY sequence

(mysqli): SELECT c.* FROM cms_module_nb_company_types c WHERE c.company_id = '33'

(mysqli): SELECT * FROM cms_module_nb_lifestyles

(mysqli): SELECT c.* FROM cms_module_nb_company_lifestyles c WHERE c.company_id = '33'

(mysqli): SELECT vacancy_type, count(id) AS vacancy_count_active FROM cms_module_nb_vacancy v
      WHERE company_id = '58'
      AND active = 'Y'
      GROUP BY vacancy_type

(mysqli): SELECT vacancy_type, count(id) AS vacancy_count_vacant FROM cms_module_nb_vacancy v
      WHERE company_id = '58'
      AND active = 'Y'
      AND vacant = 'Y'
      GROUP BY vacancy_type

(mysqli): SELECT name FROM cms_module_nb_gallery
      WHERE company_id = '58'
      ORDER BY sequence

(mysqli): SELECT company_name as name, classification, name_alias FROM cms_module_nb_companies WHERE id = '58'

(mysqli): SELECT c.* FROM cms_module_nb_companies c WHERE c.id = '58'

(mysqli): SELECT * FROM cms_module_nb_types WHERE category = 'retirement' ORDER BY sequence

(mysqli): SELECT c.* FROM cms_module_nb_company_types c WHERE c.company_id = '58'

(mysqli): SELECT * FROM cms_module_nb_lifestyles

(mysqli): SELECT c.* FROM cms_module_nb_company_lifestyles c WHERE c.company_id = '58'

(mysqli): SELECT vacancy_type, count(id) AS vacancy_count_active FROM cms_module_nb_vacancy v
      WHERE company_id = '244'
      AND active = 'Y'
      GROUP BY vacancy_type

(mysqli): SELECT vacancy_type, count(id) AS vacancy_count_vacant FROM cms_module_nb_vacancy v
      WHERE company_id = '244'
      AND active = 'Y'
      AND vacant = 'Y'
      GROUP BY vacancy_type

(mysqli): SELECT name FROM cms_module_nb_gallery
      WHERE company_id = '244'
      ORDER BY sequence

(mysqli): SELECT company_name as name, classification, name_alias FROM cms_module_nb_companies WHERE id = '3134'

(mysqli): SELECT c.* FROM cms_module_nb_companies c WHERE c.id = '244'

(mysqli): SELECT * FROM cms_module_nb_types WHERE category = 'retirement' ORDER BY sequence

(mysqli): SELECT c.* FROM cms_module_nb_company_types c WHERE c.company_id = '244'

(mysqli): SELECT * FROM cms_module_nb_lifestyles

(mysqli): SELECT c.* FROM cms_module_nb_company_lifestyles c WHERE c.company_id = '244'

(mysqli): SELECT vacancy_type, count(id) AS vacancy_count_active FROM cms_module_nb_vacancy v
      WHERE company_id = '34'
      AND active = 'Y'
      GROUP BY vacancy_type

(mysqli): SELECT vacancy_type, count(id) AS vacancy_count_vacant FROM cms_module_nb_vacancy v
      WHERE company_id = '34'
      AND active = 'Y'
      AND vacant = 'Y'
      GROUP BY vacancy_type

(mysqli): SELECT name FROM cms_module_nb_gallery
      WHERE company_id = '34'
      ORDER BY sequence

(mysqli): SELECT company_name as name, classification, name_alias FROM cms_module_nb_companies WHERE id = '34'

(mysqli): SELECT c.* FROM cms_module_nb_companies c WHERE c.id = '34'

(mysqli): SELECT * FROM cms_module_nb_types WHERE category = 'retirement' ORDER BY sequence

(mysqli): SELECT c.* FROM cms_module_nb_company_types c WHERE c.company_id = '34'

(mysqli): SELECT * FROM cms_module_nb_lifestyles

(mysqli): SELECT c.* FROM cms_module_nb_company_lifestyles c WHERE c.company_id = '34'

(mysqli): SELECT distinct name as city, postcode as postCode, state FROM cms_module_nb_cities
  where state = "new south wales"
  ORDER BY city

(mysqli): SELECT distinct company_name as name FROM cms_module_nb_companies
  where state = 'new south wales'
  and (enabled = 'Y' or enabled = 'M')
  and classification = 'retirement'
  ORDER BY name

(mysqli): SELECT distinct t.name FROM cms_module_nb_types t
            JOIN cms_module_nb_company_types ct
              on t.id = ct.type_id
            JOIN cms_module_nb_companies c
              on c.id = ct.company_id
              and c.enabled in ('Y', 'M')
            WHERE t.category = 'retirement'

(mysqli): SELECT name FROM cms_module_nb_lifestyles l

(mysqli): SELECT c.*,
   (SELECT count(id) FROM cms_module_nb_review r WHERE company_id = c.id and r.enabled = 'Y') as reviews
    FROM cms_module_nb_companies c
  where c.state = 'new south wales'
  and c.classification = 'retirement'
  and c.platinum = 'Y'
  and (c.enabled = 'Y' or c.enabled = 'M')

(mysqli): SELECT * FROM cms_module_nb_banners_categories WHERE name = 'retirement-new-south-wales-top'

(mysqli): SELECT * FROM cms_module_nb_banners WHERE (category_id = "66") AND (start_date <= '2025-01-07 18:38:18') AND (expires > '2025-01-07 18:38:18' or isnull(expires)) AND (max_impressions = 0 OR num_impressions < max_impressions) ORDER BY RAND() LIMIT 0,1

(mysqli): SELECT DISTINCT r.* FROM cms_module_nb_regions r
           join cms_module_nb_regioncities rc on rc.region_id = r.id
           join cms_module_nb_cities c on rc.city_id = c.id
           join cms_module_nb_company_cities cc on cc.city = c.name
           join cms_module_nb_companies co on co.id = cc.company_id and co.state = r.state and co.enabled = "Y"
           WHERE r.state = 'new south wales'
           ORDER BY r.name

(mysqli): SELECT * FROM cms_module_nb_cities WHERE name = 'kangy angy'
          AND state = 'new south wales'

(mysqli): SELECT r.name, r.state, r.summary, r.description FROM cms_module_nb_cities c, cms_module_nb_regioncities rc, cms_module_nb_regions r
   WHERE c.name = 'kangy angy'
   AND c.state = 'new south wales'
   AND c.id = rc.city_id
   AND r.id = rc.region_id
   LIMIT 1

start global_content_get_template

Loading /home/retire/public_html/lib/classes/class.globalcontentoperations.inc.php = 50344 bytes for an approximate total of 3099776

(mysqli): SELECT htmlblob_id, htmlblob_name, html, owner, use_wysiwyg, description, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'HeaderAd' LIMIT  1

end global_content_get_template

Loading /home/retire/public_html/modules/FrontEndUsers/lib/class.UserManipulator.php = 103184 bytes for an approximate total of 3202960

Loading /home/retire/public_html/modules/FrontEndUsers/lib/class.FrontEndUsersManipulator.php = 372872 bytes for an approximate total of 3575832

Loading /home/retire/public_html/modules/FrontEndUsers/lib/class.feu_utils.php = 4280 bytes for an approximate total of 3580112

Loading /home/retire/public_html/modules/FrontEndUsers/lib/class.feu_pure_consumer.php = 14240 bytes for an approximate total of 3594352

Loading /home/retire/public_html/modules/FrontEndUsers/lib/class.feu_std_consumer.php = 30568 bytes for an approximate total of 3624920

FEU ExpireUsers 60 -- 1736235448

(mysqli): SELECT userid AS uid,lastused AS time FROM cms_module_feusers_loggedin WHERE sessionid = '1f0a02ff35966e8b0bd385d02e3d0185' LIMIT  1

(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id NOT IN (57)

(mysqli): SELECT * FROM cms_content_props WHERE content_id IN (56,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,110,111,112,113,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227) ORDER BY content_id

Loading /home/retire/public_html/lib/classes/class.CMSModuleContentType.php = 13400 bytes for an approximate total of 3638320

Loading /home/retire/public_html/modules/AdvancedContent/lib/class.ac_utils.php = 51448 bytes for an approximate total of 3689768

Loading /home/retire/public_html/modules/AdvancedContent/lib/class.AdvancedContentModule.php = 14328 bytes for an approximate total of 3704096

Loading /home/retire/public_html/lib/classes/contenttypes/SectionHeader.inc.php = 17128 bytes for an approximate total of 3721224

Loading /home/retire/public_html/lib/classes/contenttypes/Link.inc.php = 20704 bytes for an approximate total of 3741928

Loading /home/retire/public_html/lib/classes/contenttypes/ErrorPage.inc.php = 26184 bytes for an approximate total of 3768112

(mysqli): SELECT * from cms_module_templates WHERE module_name = 'MenuManager' and template_name = 'topBar-V6' LIMIT  1

(mysqli): SELECT * FROM cms_module_nb_banners_categories WHERE name = 'retirement-new-south-wales-top'

(mysqli): SELECT * FROM cms_module_nb_banners WHERE (category_id = "66") AND (start_date <= '2025-01-07 18:38:18') AND (expires > '2025-01-07 18:38:18' or isnull(expires)) AND (max_impressions = 0 OR num_impressions < max_impressions) ORDER BY RAND() LIMIT 0,1

process template head

start global_content_get_template

(mysqli): SELECT htmlblob_id, htmlblob_name, html, owner, use_wysiwyg, description, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'HTMLHeaderV6' LIMIT  1

end global_content_get_template

start global_content_get_template

(mysqli): SELECT htmlblob_id, htmlblob_name, html, owner, use_wysiwyg, description, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'Analytics' LIMIT  1

end global_content_get_template

calling module TinyMCE from event ContentPostRender

calling module CGExtensions from event ContentPostRender

Loading /home/retire/public_html/modules/CGExtensions/lib/class.cge_headers.php = 3152 bytes for an approximate total of 3771264