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

Please disable any ad block extensions or software.

The Webmaster of OurSeniorsGuide.com reserves the right to categorically decline any free profile.

Account

Note: fields marked with asterisk(*) are required

First Name*:

Last Name*:

Email*:

Password*:

Repeat Password*:

Account Type: Basic (Free)

Public Profile

Company Name*:
Location:

Your location not listed? Contact Us.

You can only be in one location
Phone Number*:
###-###-####
Address:
We'll show a map.
Website http://
Facebook Link
License Number:
If applicable
License Logos:
Categories:
Payment Options:
Picture:
Upload a quality picture to represent your business

We will review your profile before we publish your advertisement on our website.

  • OurSeniorsGuide.com, Inc
  • 14286 Beach Blvd-19, Suite 335
  • Jacksonville, Florida 32250
  • Phone: 904-655-2130
  • Fax: 904-647-6038
  • Contact Us
Page requested: /profile-online-senior-resource-guide/
Request Method: GET
Referrer:
User Agent: CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address: 3.221.159.255
Request Time: 0.13491201400757 seconds
Errors
Console
Query Log
E_NOTICE: Undefined index: advertiser on line 11 in file /home/ourseniorsguide/public_html/wp-content/themes/seniorsguide/header.php
Stack Trace
#0 require_once("/home/ourseniorsguide/public_html/wp-content/themes/seniorsguide/header.php") /home/ourseniorsguide/public_html/wp-includes/template.php 730
#1 load_template("/home/ourseniorsguide/public_html/wp-content/themes/seniorsguide/header.php", bool(true) , Array...
Array
(
)
)		 /home/ourseniorsguide/public_html/wp-includes/template.php 676
#2 locate_template(Array...
Array
(
    [0] => header.php
)
, bool(true) , bool(true) , Array...
Array
(
)
)		 /home/ourseniorsguide/public_html/wp-includes/general-template.php 48
#3 get_header() /home/ourseniorsguide/public_html/wp-content/themes/seniorsguide/page-start-account.php 6
#4 include("/home/ourseniorsguide/public_html/wp-content/themes/seniorsguide/page-start-account.php") /home/ourseniorsguide/public_html/wp-includes/template-loader.php 106
#5 require_once("/home/ourseniorsguide/public_html/wp-includes/template-loader.php") /home/ourseniorsguide/public_html/wp-blog-header.php 19
#6 require("/home/ourseniorsguide/public_html/wp-blog-header.php") /home/ourseniorsguide/public_html/index.php 17
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
                (
                    [000000004f927223000000000806b06brewriteTitle] => 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
                (
                    [000000004f9275a9000000000806b06bprint_marker] => Array
                        (
                            [function] => Array
                                (
                                    [0] => C_Photocrati_Resource_Manager Object
                                        (
                                            [marker] => 
                                            [buffer] => 



    
                    
    
    
    
    
    
    
    
    
    		
	 
	

	
	

		
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	        	
		
		
		
		
		
		
		






		
		
	














 





    
    
    
    
    
    




    

        

            

                
            

            

                
                
                    sign-post
                    Community Locations & Specialties Offered
                

                
                
                    book
                    Request a Guide
                
            

        


        
        
        
    








    

        

                        

                Select Senior Care
                
            

                        

                Text Size: + -
            

            

                                                    

        

    
    
        

        
Please disable any ad block extensions or software.

                    
The Webmaster of OurSeniorsGuide.com reserves the right to categorically decline any free profile.

            
        
Account


        

            Note: fields marked with asterisk(*) are required
        



        

                    

        

            

                
First Name*:


                

                

            

            

                
Last Name*:


                

                

            

            

                
Email*:


                

                    
                

            

        

        


            

                
Password*:


                

                    
                                    

            

            

                
Repeat Password*:


                

            

        

                

            Account Type: Basic (Free)        

        
    


    

        
Public Profile


        

            
Company Name*:

            

                
            

        


        

            
Location:

            

                

                

                    

                        Your location not listed? Contact Us.
                    

                

            

            
You can only be in one location

        


        

            
Phone Number*:

            

                
            

            
###-###-####

        


        

            
Address:

            

                
                
                
            

            
We'll show a map.

        



        

            
Website http://

            

                
            

        


        

            
Facebook Link

            

                
            

        


        

            
License Number:

            

                
            

            
If applicable

        


        

            
License Logos:

            

                

                    
                    
                

                

                    
                    
                

            

        


                

            
Categories:

            

                                    

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                

        


        

        

            
Payment Options:

            

                                    

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                    
            

        


        

            

                Picture:
            

            

                

                                        
                                

            
                    

        
Upload a quality picture to represent your business

        


        
    


    

    

                    

                
We will review your profile before we publish your advertisement on our website.


                

                    
                

            

                    

            

                            

            

                            

        

    



    

            

                    

    

    
    
    
    




    

        

            
        

        

            
    
                
  • 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
                (
                    [000000004f927227000000000806b06badminFooter] => 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
                (
                    [000000004f927223000000000806b06brewriteTitle] => 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
                (
                    [000000004f9275a9000000000806b06bprint_marker] => Array
                        (
                            [function] => Array
                                (
                                    [0] => C_Photocrati_Resource_Manager Object
                                        (
                                            [marker] => 
                                            [buffer] => 



    
                    
    
    
    
    
    
    
    
    
    		
	 
	

	
	

		
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	        	
		
		
		
		
		
		
		






		
		
	














 





    
    
    
    
    
    




    

        

            

                
            

            

                
                
                    sign-post
                    Community Locations & Specialties Offered
                

                
                
                    book
                    Request a Guide
                
            

        


        
        
        
    








    

        

                        

                Select Senior Care
                
            

                        

                Text Size: + -
            

            

                                                    

        

    
    
        

        
Please disable any ad block extensions or software.

                    
The Webmaster of OurSeniorsGuide.com reserves the right to categorically decline any free profile.

            
        
Account


        

            Note: fields marked with asterisk(*) are required
        



        

                    

        

            

                
First Name*:


                

                

            

            

                
Last Name*:


                

                

            

            

                
Email*:


                

                    
                

            

        

        


            

                
Password*:


                

                    
                                    

            

            

                
Repeat Password*:


                

            

        

                

            Account Type: Basic (Free)        

        
    


    

        
Public Profile


        

            
Company Name*:

            

                
            

        


        

            
Location:

            

                

                

                    

                        Your location not listed? Contact Us.
                    

                

            

            
You can only be in one location

        


        

            
Phone Number*:

            

                
            

            
###-###-####

        


        

            
Address:

            

                
                
                
            

            
We'll show a map.

        



        

            
Website http://

            

                
            

        


        

            
Facebook Link

            

                
            

        


        

            
License Number:

            

                
            

            
If applicable

        


        

            
License Logos:

            

                

                    
                    
                

                

                    
                    
                

            

        


                

            
Categories:

            

                                    

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                

        


        

        

            
Payment Options:

            

                                    

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                                        

                        
                        
                    

                    
            

        


        

            

                Picture:
            

            

                

                                        
                                

            
                    

        
Upload a quality picture to represent your business

        


        
    


    

    

                    

                
We will review your profile before we publish your advertisement on our website.


                

                    
                

            

                    

            

                            

            

                            

        

    



    

            

                    

    

    
    
    
    




    

        

            
        

        

            
    
                
  • 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
                (
                    [000000004f927227000000000806b06badminFooter] => 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-start-account.php 25
#8 include("/home/ourseniorsguide/public_html/wp-content/themes/seniorsguide/page-start-account.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
	advertiser_types.id,
	advertiser_types.name,
	advertiser_types.search_results_order,
	advertiser_types.company_name,
	advertiser_types.phone_number,
	advertiser_types.map_link,
	advertiser_types.payment_options,
	advertiser_types.website_link,
	advertiser_types.amenities,
	advertiser_types.request_more_info,
	advertiser_types.text_description,
	advertiser_types.text_description_length,
	advertiser_types.services,
	advertiser_types.multiple_pictures,
	advertiser_types.video,
	advertiser_types.home_page_ad,
	show_listing_picture,
	show_listing_services,
	show_listing_description,
	listing_full_width
FROM
	advertiser_types
	
WHERE
	advertiser_types.id= 1

pdo Stub:

SELECT
	advertiser_types.id,
	advertiser_types.name,
	advertiser_types.search_results_order,
	advertiser_types.company_name,
	advertiser_types.phone_number,
	advertiser_types.map_link,
	advertiser_types.payment_options,
	advertiser_types.website_link,
	advertiser_types.amenities,
	advertiser_types.request_more_info,
	advertiser_types.text_description,
	advertiser_types.text_description_length,
	advertiser_types.services,
	advertiser_types.multiple_pictures,
	advertiser_types.video,
	advertiser_types.home_page_ad,
	show_listing_picture,
	show_listing_services,
	show_listing_description,
	listing_full_width
FROM
	advertiser_types
	
WHERE
	advertiser_types.id= :id

pdo:

SELECT
	DISTINCT 
	    
            locations.state AS state,
            locations.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
	locations
	
LEFT JOIN
	tabmin_pages ON locations.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
	
ORDER BY
	name

pdo Stub:

SELECT
	DISTINCT 
	    
            locations.state AS state,
            locations.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
	locations
	
LEFT JOIN
	tabmin_pages ON locations.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
	
ORDER BY
	name

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
	payment_options.id,
	payment_options.name
FROM
	payment_options

pdo Stub:

SELECT
	payment_options.id,
	payment_options.name
FROM
	payment_options

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