sign-post Community Locations & Specialties Offered book Request a Guide
Select Senior Care
Text Size: + -

Westminster Woods Retirement Living on Julington Creek

Wheel Chair Accessible Equal Housing Opportunity

Active Lifestyle for Seniors

Westminster Woods on Julington Creek is a faith based, not-for-profit active living community for Independent Living with continuing care as needs change. Our beautiful 90 acre campus, located on the banks of Julington Creek offers Independent Living villas and apartment homes, Assisted Living, Memory Care, Short-term Rehabilitation and Long-term Nursing. We offer the protection of the Entrance Fee product. WWJC has been serving area families of over 50 years and holds a 5 Star rating for our Health Care center.

Payment Options

  • Medicare
  • Private Pay
  • Call for Current Pricing / Specials
  • Long Term Care Insurance
  • Checks
  • ACH Debit
  • Veterans Benefits
  • OurSeniorsGuide.com, Inc
  • 14286 Beach Blvd-19, Suite 335
  • Jacksonville, Florida 32250
  • Phone: 904-655-2130
  • Fax: 904-647-6038
  • Contact Us
Page requested: /advertisers/westminster-woods-retirement-living-on-julington-creek/
Request Method: GET
Referrer:
User Agent: CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address: 3.239.242.55
Request Time: 0.10857605934143 seconds
Errors
Console
Query Log
E_NOTICE: Undefined offset: 1 on line 131 in file /home/ourseniorsguide/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Main/Head.php
Stack Trace
#0 AIOSEO\Plugin\Common\Main\Head->rewriteTitle("") Object...
AIOSEO\Plugin\Common\Main\Head Object
(
    [analytics] => AIOSEO\Plugin\Common\Main\GoogleAnalytics Object
        (
        )

    [links] => AIOSEO\Plugin\Common\Meta\Links Object
        (
        )

    [robots] => AIOSEO\Plugin\Common\Meta\Robots Object
        (
            [attributes:protected] => Array
                (
                    [noindex] => 
                    [nofollow] => 
                    [noarchive] => 
                    [nosnippet] => 
                    [noimageindex] => 
                    [noodp] => 
                    [notranslate] => 
                    [max-snippet] => 
                    [max-image-preview] => 
                    [max-video-preview] => 
                )

        )

    [keywords] => AIOSEO\Plugin\Common\Meta\Keywords Object
        (
        )

    [verification] => AIOSEO\Plugin\Common\Meta\SiteVerification Object
        (
            [webmasterTools:AIOSEO\Plugin\Common\Meta\SiteVerification:private] => Array
                (
                    [google] => google-site-verification
                    [bing] => msvalidate.01
                    [pinterest] => p:domain_verify
                    [yandex] => yandex-verification
                    [baidu] => baidu-site-verification
                )

        )

    [views] => Array
        (
            [meta] => /home/ourseniorsguide/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Views/main/meta.php
            [social] => /home/ourseniorsguide/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Views/main/social.php
            [schema] => /home/ourseniorsguide/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Views/main/schema.php
            [analytics] => /home/ourseniorsguide/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Views/main/analytics.php
        )

)
#1 call_user_func_array(Array...
Array
(
    [0] => AIOSEO\Plugin\Common\Main\Head Object
        (
            [analytics] => AIOSEO\Plugin\Common\Main\GoogleAnalytics Object
                (
                )

            [links] => AIOSEO\Plugin\Common\Meta\Links Object
                (
                )

            [robots] => AIOSEO\Plugin\Common\Meta\Robots Object
                (
                    [attributes:protected] => Array
                        (
                            [noindex] => 
                            [nofollow] => 
                            [noarchive] => 
                            [nosnippet] => 
                            [noimageindex] => 
                            [noodp] => 
                            [notranslate] => 
                            [max-snippet] => 
                            [max-image-preview] => 
                            [max-video-preview] => 
                        )

                )

            [keywords] => AIOSEO\Plugin\Common\Meta\Keywords Object
                (
                )

            [verification] => AIOSEO\Plugin\Common\Meta\SiteVerification Object
                (
                    [webmasterTools:AIOSEO\Plugin\Common\Meta\SiteVerification:private] => Array
                        (
                            [google] => google-site-verification
                            [bing] => msvalidate.01
                            [pinterest] => p:domain_verify
                            [yandex] => yandex-verification
                            [baidu] => baidu-site-verification
                        )

                )

            [views] => Array
                (
                    [meta] => /home/ourseniorsguide/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Views/main/meta.php
                    [social] => /home/ourseniorsguide/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Views/main/social.php
                    [schema] => /home/ourseniorsguide/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Views/main/schema.php
                    [analytics] => /home/ourseniorsguide/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Views/main/analytics.php
                )

        )

    [1] => rewriteTitle
)
, Array...
Array
(
    [0] => 
)
)		 /home/ourseniorsguide/public_html/wp-includes/class-wp-hook.php 287
#2 WP_Hook->apply_filters("", Array...
Array
(
    [0] => 
)
)		 /home/ourseniorsguide/public_html/wp-includes/class-wp-hook.php 311 Object...
WP_Hook Object
(
    [callbacks] => Array
        (
            [-2] => Array
                (
                    [000000000ddaaaa1000000003d89913drewriteTitle] => Array
                        (
                            [function] => Array
                                (
                                    [0] => AIOSEO\Plugin\Common\Main\Head Object
                                        (
                                            [analytics] => AIOSEO\Plugin\Common\Main\GoogleAnalytics Object
                                                (
                                                )

                                            [links] => AIOSEO\Plugin\Common\Meta\Links Object
                                                (
                                                )

                                            [robots] => AIOSEO\Plugin\Common\Meta\Robots Object
                                                (
                                                    [attributes:protected] => Array
                                                        (
                                                            [noindex] => 
                                                            [nofollow] => 
                                                            [noarchive] => 
                                                            [nosnippet] => 
                                                            [noimageindex] => 
                                                            [noodp] => 
                                                            [notranslate] => 
                                                            [max-snippet] => 
                                                            [max-image-preview] => 
                                                            [max-video-preview] => 
                                                        )

                                                )

                                            [keywords] => AIOSEO\Plugin\Common\Meta\Keywords Object
                                                (
                                                )

                                            [verification] => AIOSEO\Plugin\Common\Meta\SiteVerification Object
                                                (
                                                    [webmasterTools:AIOSEO\Plugin\Common\Meta\SiteVerification:private] => Array
                                                        (
                                                            [google] => google-site-verification
                                                            [bing] => msvalidate.01
                                                            [pinterest] => p:domain_verify
                                                            [yandex] => yandex-verification
                                                            [baidu] => baidu-site-verification
                                                        )

                                                )

                                            [views] => Array
                                                (
                                                    [meta] => /home/ourseniorsguide/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Views/main/meta.php
                                                    [social] => /home/ourseniorsguide/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Views/main/social.php
                                                    [schema] => /home/ourseniorsguide/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Views/main/schema.php
                                                    [analytics] => /home/ourseniorsguide/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Views/main/analytics.php
                                                )

                                        )

                                    [1] => rewriteTitle
                                )

                            [accepted_args] => 1
                        )

                )

            [-1] => Array
                (
                    [000000000ddaad3b000000003d89913dprint_marker] => Array
                        (
                            [function] => Array
                                (
                                    [0] => C_Photocrati_Resource_Manager Object
                                        (
                                            [marker] => 
                                            [buffer] => 



    
    
            
    
    
    
    
    
    
    
    
    		
	 
	

	
	

		
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	        	
		
		
		
		
		
		






		
		
	














 





    Westminster Woods Retirement Living on Julington Creek
    
    
    
    
    




    

        

            

                
            

            

                
                
                    sign-post
                    Community Locations & Specialties Offered
                

                
                
                    book
                    Request a Guide
                
            

        


        
        
        
    








    

        

                        

                Select Senior Care
                
            

                        

                Text Size: + -
            

            

                                                	
	
	
	

    


        

            

                
Westminster Woods Retirement Living on Julington Creek

                
                
                
                    
                                

                
                                    

                                                    Wheel Chair Accessible
                                                    Equal Housing Opportunity
                                            

                            

            

                
            

        

        

            
        

        
                

            
        

        
                    

                

                    

                        Active Lifestyle for Seniors                    

                    

                        Westminster Woods on Julington Creek is a faith based, not-for-profit active living community for Independent Living with continuing care as needs change. Our beautiful 90 acre campus, located on the banks of Julington Creek offers Independent Living villas and apartment homes, Assisted Living, Memory Care, Short-term Rehabilitation and Long-term Nursing. We offer the protection of the Entrance Fee product. WWJC has been serving area families of over 50 years and holds a 5 Star rating for our Health Care center.                    

                

            

                

                                        

                    
Payment Options

                    
    
                                                    
  • Medicare
    • 
                                                    
  • Private Pay
    • 
                                                    
  • Call for Current Pricing / Specials
    • 
                                                    
  • Long Term Care Insurance
    • 
                                                    
  • Checks
    • 
                                                    
  • ACH Debit
    • 
                                                    
  • Veterans Benefits 
    • 
                                            

                

                    

    



            

                    

    

    
    
    
    




    

        

            
        

        

            
    
                
  • OurSeniorsGuide.com, Inc
    • 
                
  • 14286 Beach Blvd-19, Suite 335
    • 
                
  • Jacksonville, Florida 32250
    • 
            

        

        

            
    
                
  • Phone: 904-655-2130
    • 
                
  • Fax: 904-647-6038
    • 
                
  • Contact Us
    • 
            

        

    























                                            [styles] => 
                                            [scripts] => 






                                            [other_output] => 
                                            [wrote_footer] => 1
                                            [run_shutdown] => 
                                            [valid_request] => 1
                                        )

                                    [1] => print_marker
                                )

                            [accepted_args] => 1
                        )

                )

            [10] => Array
                (
                    [000000000ddaaaa5000000003d89913dadminFooter] => Array
                        (
                            [function] => Array
                                (
                                    [0] => AIOSEO\Plugin\Common\Main\Main Object
                                        (
                                            [media] => AIOSEO\Plugin\Common\Main\Media Object
                                                (
                                                )

                                        )

                                    [1] => adminFooter
                                )

                            [accepted_args] => 1
                        )

                )

            [20] => Array
                (
                    [wp_print_footer_scripts] => Array
                        (
                            [function] => wp_print_footer_scripts
                            [accepted_args] => 1
                        )

                )

            [1000] => Array
                (
                    [wp_admin_bar_render] => Array
                        (
                            [function] => wp_admin_bar_render
                            [accepted_args] => 1
                        )

                )

        )

    [iterations:WP_Hook:private] => Array
        (
        )

    [current_priority:WP_Hook:private] => Array
        (
        )

    [nesting_level:WP_Hook:private] => 0
    [doing_action:WP_Hook:private] => 
)
#3 WP_Hook->do_action(Array...
Array
(
    [0] => 
)
)		 /home/ourseniorsguide/public_html/wp-includes/plugin.php 484 Object...
WP_Hook Object
(
    [callbacks] => Array
        (
            [-2] => Array
                (
                    [000000000ddaaaa1000000003d89913drewriteTitle] => Array
                        (
                            [function] => Array
                                (
                                    [0] => AIOSEO\Plugin\Common\Main\Head Object
                                        (
                                            [analytics] => AIOSEO\Plugin\Common\Main\GoogleAnalytics Object
                                                (
                                                )

                                            [links] => AIOSEO\Plugin\Common\Meta\Links Object
                                                (
                                                )

                                            [robots] => AIOSEO\Plugin\Common\Meta\Robots Object
                                                (
                                                    [attributes:protected] => Array
                                                        (
                                                            [noindex] => 
                                                            [nofollow] => 
                                                            [noarchive] => 
                                                            [nosnippet] => 
                                                            [noimageindex] => 
                                                            [noodp] => 
                                                            [notranslate] => 
                                                            [max-snippet] => 
                                                            [max-image-preview] => 
                                                            [max-video-preview] => 
                                                        )

                                                )

                                            [keywords] => AIOSEO\Plugin\Common\Meta\Keywords Object
                                                (
                                                )

                                            [verification] => AIOSEO\Plugin\Common\Meta\SiteVerification Object
                                                (
                                                    [webmasterTools:AIOSEO\Plugin\Common\Meta\SiteVerification:private] => Array
                                                        (
                                                            [google] => google-site-verification
                                                            [bing] => msvalidate.01
                                                            [pinterest] => p:domain_verify
                                                            [yandex] => yandex-verification
                                                            [baidu] => baidu-site-verification
                                                        )

                                                )

                                            [views] => Array
                                                (
                                                    [meta] => /home/ourseniorsguide/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Views/main/meta.php
                                                    [social] => /home/ourseniorsguide/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Views/main/social.php
                                                    [schema] => /home/ourseniorsguide/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Views/main/schema.php
                                                    [analytics] => /home/ourseniorsguide/public_html/wp-content/plugins/all-in-one-seo-pack/app/Common/Views/main/analytics.php
                                                )

                                        )

                                    [1] => rewriteTitle
                                )

                            [accepted_args] => 1
                        )

                )

            [-1] => Array
                (
                    [000000000ddaad3b000000003d89913dprint_marker] => Array
                        (
                            [function] => Array
                                (
                                    [0] => C_Photocrati_Resource_Manager Object
                                        (
                                            [marker] => 
                                            [buffer] => 



    
    
            
    
    
    
    
    
    
    
    
    		
	 
	

	
	

		
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	        	
		
		
		
		
		
		






		
		
	














 





    Westminster Woods Retirement Living on Julington Creek
    
    
    
    
    




    

        

            

                
            

            

                
                
                    sign-post
                    Community Locations & Specialties Offered
                

                
                
                    book
                    Request a Guide
                
            

        


        
        
        
    








    

        

                        

                Select Senior Care
                
            

                        

                Text Size: + -
            

            

                                                	
	
	
	

    


        

            

                
Westminster Woods Retirement Living on Julington Creek

                
                
                
                    
                                

                
                                    

                                                    Wheel Chair Accessible
                                                    Equal Housing Opportunity
                                            

                            

            

                
            

        

        

            
        

        
                

            
        

        
                    

                

                    

                        Active Lifestyle for Seniors                    

                    

                        Westminster Woods on Julington Creek is a faith based, not-for-profit active living community for Independent Living with continuing care as needs change. Our beautiful 90 acre campus, located on the banks of Julington Creek offers Independent Living villas and apartment homes, Assisted Living, Memory Care, Short-term Rehabilitation and Long-term Nursing. We offer the protection of the Entrance Fee product. WWJC has been serving area families of over 50 years and holds a 5 Star rating for our Health Care center.                    

                

            

                

                                        

                    
Payment Options

                    
    
                                                    
  • Medicare
    • 
                                                    
  • Private Pay
    • 
                                                    
  • Call for Current Pricing / Specials
    • 
                                                    
  • Long Term Care Insurance
    • 
                                                    
  • Checks
    • 
                                                    
  • ACH Debit
    • 
                                                    
  • Veterans Benefits 
    • 
                                            

                

                    

    



            

                    

    

    
    
    
    




    

        

            
        

        

            
    
                
  • OurSeniorsGuide.com, Inc
    • 
                
  • 14286 Beach Blvd-19, Suite 335
    • 
                
  • Jacksonville, Florida 32250
    • 
            

        

        

            
    
                
  • Phone: 904-655-2130
    • 
                
  • Fax: 904-647-6038
    • 
                
  • Contact Us
    • 
            

        

    























                                            [styles] => 
                                            [scripts] => 






                                            [other_output] => 
                                            [wrote_footer] => 1
                                            [run_shutdown] => 
                                            [valid_request] => 1
                                        )

                                    [1] => print_marker
                                )

                            [accepted_args] => 1
                        )

                )

            [10] => Array
                (
                    [000000000ddaaaa5000000003d89913dadminFooter] => Array
                        (
                            [function] => Array
                                (
                                    [0] => AIOSEO\Plugin\Common\Main\Main Object
                                        (
                                            [media] => AIOSEO\Plugin\Common\Main\Media Object
                                                (
                                                )

                                        )

                                    [1] => adminFooter
                                )

                            [accepted_args] => 1
                        )

                )

            [20] => Array
                (
                    [wp_print_footer_scripts] => Array
                        (
                            [function] => wp_print_footer_scripts
                            [accepted_args] => 1
                        )

                )

            [1000] => Array
                (
                    [wp_admin_bar_render] => Array
                        (
                            [function] => wp_admin_bar_render
                            [accepted_args] => 1
                        )

                )

        )

    [iterations:WP_Hook:private] => Array
        (
        )

    [current_priority:WP_Hook:private] => Array
        (
        )

    [nesting_level:WP_Hook:private] => 0
    [doing_action:WP_Hook:private] => 
)
#4 do_action("wp_footer") /home/ourseniorsguide/public_html/wp-includes/general-template.php 3021
#5 wp_footer() /home/ourseniorsguide/public_html/template.php 292
#6 include("/home/ourseniorsguide/public_html/template.php") /home/ourseniorsguide/_global/classes/TemplateSet.inc.php 103
#7 TemplateSet::display("/home/ourseniorsguide/public_html/template.php") /home/ourseniorsguide/public_html/wp-content/themes/seniorsguide/page-advertiser.php 244
#8 include("/home/ourseniorsguide/public_html/wp-content/themes/seniorsguide/page-advertiser.php") /home/ourseniorsguide/public_html/wp-includes/template-loader.php 106
#9 require_once("/home/ourseniorsguide/public_html/wp-includes/template-loader.php") /home/ourseniorsguide/public_html/wp-blog-header.php 19
#10 require("/home/ourseniorsguide/public_html/wp-blog-header.php") /home/ourseniorsguide/public_html/index.php 17 

pdo:

SELECT
	DISTINCT 
	    
            advertisers.statuses_id as statuses_id,
            advertisers.id as advertisers_id,
            tabmin_pages.name AS advertiser_pages_name,
            tabmin_pages.page_title AS advertiser_pages_page_title,
            tabmin_pages.page_subtitle AS advertiser_pages_page_subtitle,
            tabmin_pages.meta_description AS advertiser_pages_meta_description,
            tabmin_pages.description AS advertiser_pages_description,
            tabmin_pages.pictures_id AS advertiser_pages_pictures_id,
            main_pictures.caption AS advertiser_pages_pictures_caption,
            advertiser_pages.ad_pictures_id AS advertiser_pages_ad_pictures_id,
            ad_pictures.caption AS advertiser_pages_ad_pictures_caption,
            advertiser_pages.dir_pictures_id AS advertiser_pages_dir_pictures_id,
            advertiser_pages.id AS advertiser_pages_id,
            advertiser_pages.phone AS phone,
            advertiser_pages.address AS address,
            advertiser_pages.website AS website,
            advertiser_pages.facebook AS facebook,
            advertiser_pages.license_number AS license_number,
            advertiser_pages.wheel_chair_access AS wheel_chair_access,
            advertiser_pages.equal_house AS equal_house,
            advertiser_pages.video AS video,
            tabmin_pages.slug AS advertiser_pages_slug,
            locations.id AS locations_id,
            locations.state AS locations_state,
            location_page.name AS locations_name,
            advertiser_types.id AS advertiser_types_id,
            advertiser_types.name AS advertiser_types_name,
            advertiser_types.search_results_order AS advertiser_types_search_results_order,
            advertiser_types.company_name AS advertiser_types_company_name,
            advertiser_types.phone_number AS advertiser_types_phone_number,
            advertiser_types.map_link AS advertiser_types_map_link,
            advertiser_types.payment_options AS advertiser_types_payment_options,
            advertiser_types.website_link AS advertiser_types_website_link,
            advertiser_types.amenities AS advertiser_types_amenities,
            advertiser_types.request_more_info AS advertiser_types_request_more_info,
            advertiser_types.text_description AS advertiser_types_text_description,
            advertiser_types.services AS advertiser_types_services,
            advertiser_types.multiple_pictures AS advertiser_types_multiple_pictures,
            advertiser_types.video AS advertiser_types_video,
            advertiser_types.home_page_ad AS advertiser_types_home_page_ad,
            advertiser_types.show_listing_picture AS advertiser_types_show_listing_picture,
            advertiser_types.show_listing_services AS advertiser_types_show_listing_services,
            advertiser_types.show_listing_description AS advertiser_types_show_listing_description,
            advertiser_types.listing_full_width AS advertiser_types_listing_full_width,
        
	users.id,
	email,
	first_name,
	last_name,
	UNIX_TIMESTAMP(last_login) AS last_login,

	roles.id AS roles_id,
	roles.hidden AS roles_hidden,
	roles.developer AS roles_developer,
	roles.role AS roles_role

FROM
	users
	    
            LEFT JOIN advertisers ON advertisers.users_id = users.id
            LEFT JOIN advertiser_pages ON advertisers.advertiser_pages_id = advertiser_pages.id
            LEFT JOIN locations ON advertiser_pages.locations_id = locations.id
            LEFT JOIN tabmin_pages AS location_page ON locations.tabmin_pages_id = location_page.id
            LEFT JOIN tabmin_pages ON advertiser_pages.tabmin_pages_id = tabmin_pages.id
            LEFT JOIN pictures AS main_pictures ON tabmin_pages.pictures_id = main_pictures.id
            LEFT JOIN pictures AS ad_pictures ON advertiser_pages.ad_pictures_id = ad_pictures.id
            LEFT JOIN advertiser_types ON advertisers.advertiser_types_id = advertiser_types.id
            LEFT JOIN advertiser_pages_have_services ON advertiser_pages_have_services.advertiser_pages_id = advertiser_pages.id
            LEFT JOIN advertiser_pages_have_categories ON advertiser_pages_have_categories.advertiser_pages_id = advertiser_pages.id
        
LEFT JOIN
	roles ON users.roles_id=roles.id
WHERE
	(tabmin_pages.slug=westminster-woods-retirement-living-on-julington-creek) AND roles_id=3

pdo Stub:

SELECT
	DISTINCT 
	    
            advertisers.statuses_id as statuses_id,
            advertisers.id as advertisers_id,
            tabmin_pages.name AS advertiser_pages_name,
            tabmin_pages.page_title AS advertiser_pages_page_title,
            tabmin_pages.page_subtitle AS advertiser_pages_page_subtitle,
            tabmin_pages.meta_description AS advertiser_pages_meta_description,
            tabmin_pages.description AS advertiser_pages_description,
            tabmin_pages.pictures_id AS advertiser_pages_pictures_id,
            main_pictures.caption AS advertiser_pages_pictures_caption,
            advertiser_pages.ad_pictures_id AS advertiser_pages_ad_pictures_id,
            ad_pictures.caption AS advertiser_pages_ad_pictures_caption,
            advertiser_pages.dir_pictures_id AS advertiser_pages_dir_pictures_id,
            advertiser_pages.id AS advertiser_pages_id,
            advertiser_pages.phone AS phone,
            advertiser_pages.address AS address,
            advertiser_pages.website AS website,
            advertiser_pages.facebook AS facebook,
            advertiser_pages.license_number AS license_number,
            advertiser_pages.wheel_chair_access AS wheel_chair_access,
            advertiser_pages.equal_house AS equal_house,
            advertiser_pages.video AS video,
            tabmin_pages.slug AS advertiser_pages_slug,
            locations.id AS locations_id,
            locations.state AS locations_state,
            location_page.name AS locations_name,
            advertiser_types.id AS advertiser_types_id,
            advertiser_types.name AS advertiser_types_name,
            advertiser_types.search_results_order AS advertiser_types_search_results_order,
            advertiser_types.company_name AS advertiser_types_company_name,
            advertiser_types.phone_number AS advertiser_types_phone_number,
            advertiser_types.map_link AS advertiser_types_map_link,
            advertiser_types.payment_options AS advertiser_types_payment_options,
            advertiser_types.website_link AS advertiser_types_website_link,
            advertiser_types.amenities AS advertiser_types_amenities,
            advertiser_types.request_more_info AS advertiser_types_request_more_info,
            advertiser_types.text_description AS advertiser_types_text_description,
            advertiser_types.services AS advertiser_types_services,
            advertiser_types.multiple_pictures AS advertiser_types_multiple_pictures,
            advertiser_types.video AS advertiser_types_video,
            advertiser_types.home_page_ad AS advertiser_types_home_page_ad,
            advertiser_types.show_listing_picture AS advertiser_types_show_listing_picture,
            advertiser_types.show_listing_services AS advertiser_types_show_listing_services,
            advertiser_types.show_listing_description AS advertiser_types_show_listing_description,
            advertiser_types.listing_full_width AS advertiser_types_listing_full_width,
        
	users.id,
	email,
	first_name,
	last_name,
	UNIX_TIMESTAMP(last_login) AS last_login,

	roles.id AS roles_id,
	roles.hidden AS roles_hidden,
	roles.developer AS roles_developer,
	roles.role AS roles_role

FROM
	users
	    
            LEFT JOIN advertisers ON advertisers.users_id = users.id
            LEFT JOIN advertiser_pages ON advertisers.advertiser_pages_id = advertiser_pages.id
            LEFT JOIN locations ON advertiser_pages.locations_id = locations.id
            LEFT JOIN tabmin_pages AS location_page ON locations.tabmin_pages_id = location_page.id
            LEFT JOIN tabmin_pages ON advertiser_pages.tabmin_pages_id = tabmin_pages.id
            LEFT JOIN pictures AS main_pictures ON tabmin_pages.pictures_id = main_pictures.id
            LEFT JOIN pictures AS ad_pictures ON advertiser_pages.ad_pictures_id = ad_pictures.id
            LEFT JOIN advertiser_types ON advertisers.advertiser_types_id = advertiser_types.id
            LEFT JOIN advertiser_pages_have_services ON advertiser_pages_have_services.advertiser_pages_id = advertiser_pages.id
            LEFT JOIN advertiser_pages_have_categories ON advertiser_pages_have_categories.advertiser_pages_id = advertiser_pages.id
        
LEFT JOIN
	roles ON users.roles_id=roles.id
WHERE
	(tabmin_pages.slug=:slug) AND roles_id=3

pdo:

INSERT INTO statistics
	(
	    advertisers_id,
	stat_type
	)
	VALUES
	(
	99,
	page view
	)

pdo Stub:

INSERT INTO statistics
	(
	    advertisers_id,
	stat_type
	)
	VALUES
	(
	:advertisers_id,
	:stat_type
	)

pdo:

SELECT
	payment_options.id,
	payment_options.name
FROM
	payment_options
LEFT JOIN
	advertiser_pages_have_payment_options ON advertiser_pages_have_payment_options.payment_options_id = payment_options.id
WHERE
	advertiser_pages_have_payment_options.advertiser_pages_id = 144

pdo Stub:

SELECT
	payment_options.id,
	payment_options.name
FROM
	payment_options
LEFT JOIN
	advertiser_pages_have_payment_options ON advertiser_pages_have_payment_options.payment_options_id = payment_options.id
WHERE
	advertiser_pages_have_payment_options.advertiser_pages_id = :advertiser_pages_id

pdo:

SELECT
	DISTINCT 
	    
            categories.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	categories
	
LEFT JOIN
	tabmin_pages ON categories.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id

pdo Stub:

SELECT
	DISTINCT 
	    
            categories.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	categories
	
LEFT JOIN
	tabmin_pages ON categories.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id

pdo:

SELECT
	DISTINCT 
	    
            categories.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	categories
	
LEFT JOIN
	tabmin_pages ON categories.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id

pdo Stub:

SELECT
	DISTINCT 
	    
            categories.id AS id,
        
	tabmin_pages.id as base_id,
	tabmin_pages.name,
	tabmin_pages.slug,
	tabmin_pages.meta_description,
	tabmin_pages.page_title,
	tabmin_pages.page_subtitle,
	tabmin_pages.description,
	tabmin_pages.pictures_id,
	pictures.caption AS pictures_caption
FROM
	categories
	
LEFT JOIN
	tabmin_pages ON categories.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id