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

Jacksonville Nursing & Rehab Center

Wheel Chair Accessible Equal Housing Opportunity

Subacute Care,Long Term Care, Respite Care, Hospice Care

Jacksonville Nursing & Rehab Center is here to help whether you have a serious illness, recovering from surgery or you need long-term care our experienced staff can help make a difference in a speedy recovery. Subacute Care, Long Term Care, Respite Care, Terminal Care

Payment Options

  • Private Pay
  • Credit Cards
  • Some Private Insurance
  • 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/jacksonville-nursing-rehab/
Request Method: GET
Referrer:
User Agent: CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address: 3.221.159.255
Request Time: 0.12396502494812 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
                (
                    [0000000032032ef3000000003a6fb045rewriteTitle] => 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
                (
                    [0000000032032979000000003a6fb045print_marker] => Array
                        (
                            [function] => Array
                                (
                                    [0] => C_Photocrati_Resource_Manager Object
                                        (
                                            [marker] => 
                                            [buffer] => 



    
    
            
    
    
    
    
    
    
    
    
    		
	 
	

	
	

		
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	        	
		
		
		
		
		
		






		
		
	














 





    Jacksonville Nursing & Rehab Center
    
    
    
    
    




    

        

            

                
            

            

                
                
                    sign-post
                    Community Locations & Specialties Offered
                

                
                
                    book
                    Request a Guide
                
            

        


        
        
        
    








    

        

                        

                Select Senior Care
                
            

                        

                Text Size: + -
            

            

                                                	
	
	
	

    


        

            

                
Jacksonville Nursing & Rehab Center

                
                
                
                    
                                

                
                                    

                                                    Wheel Chair Accessible
                                                    Equal Housing Opportunity
                                            

                            

            

                
            

        

        

            
        

        
                

            
        

        
                    

                

                    

                        Subacute Care,Long Term Care, Respite Care, Hospice Care                    

                    

                        Jacksonville Nursing & Rehab Center is here to help whether you have a serious illness, recovering from surgery or you need long-term care our experienced staff can help make a difference in a speedy recovery. Subacute Care, Long Term Care, Respite Care, Terminal Care

                    

                

            

                

                                        

                    
Payment Options

                    
    
                                                    
  • Private Pay
    • 
                                                    
  • Credit Cards
    • 
                                                    
  • Some Private Insurance
    • 
                                            

                

                    

    



            

                    

    

    
    
    
    




    

        

            
        

        

            
    
                
  • 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
                (
                    [0000000032032ef7000000003a6fb045adminFooter] => 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
                (
                    [0000000032032ef3000000003a6fb045rewriteTitle] => 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
                (
                    [0000000032032979000000003a6fb045print_marker] => Array
                        (
                            [function] => Array
                                (
                                    [0] => C_Photocrati_Resource_Manager Object
                                        (
                                            [marker] => 
                                            [buffer] => 



    
    
            
    
    
    
    
    
    
    
    
    		
	 
	

	
	

		
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	        	
		
		
		
		
		
		






		
		
	














 





    Jacksonville Nursing & Rehab Center
    
    
    
    
    




    

        

            

                
            

            

                
                
                    sign-post
                    Community Locations & Specialties Offered
                

                
                
                    book
                    Request a Guide
                
            

        


        
        
        
    








    

        

                        

                Select Senior Care
                
            

                        

                Text Size: + -
            

            

                                                	
	
	
	

    


        

            

                
Jacksonville Nursing & Rehab Center

                
                
                
                    
                                

                
                                    

                                                    Wheel Chair Accessible
                                                    Equal Housing Opportunity
                                            

                            

            

                
            

        

        

            
        

        
                

            
        

        
                    

                

                    

                        Subacute Care,Long Term Care, Respite Care, Hospice Care                    

                    

                        Jacksonville Nursing & Rehab Center is here to help whether you have a serious illness, recovering from surgery or you need long-term care our experienced staff can help make a difference in a speedy recovery. Subacute Care, Long Term Care, Respite Care, Terminal Care

                    

                

            

                

                                        

                    
Payment Options

                    
    
                                                    
  • Private Pay
    • 
                                                    
  • Credit Cards
    • 
                                                    
  • Some Private Insurance
    • 
                                            

                

                    

    



            

                    

    

    
    
    
    




    

        

            
        

        

            
    
                
  • 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
                (
                    [0000000032032ef7000000003a6fb045adminFooter] => 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=jacksonville-nursing-rehab) 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
	(
	358,
	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 = 480

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