Text Size: + -

Find Senior Care

Location:
Category:

Results

TestAdvertiser

Jacksonville, FL

Wekiva Springs Center

Jacksonville, FL

  • OurSeniorsGuide.com, Inc
  • 14286 Beach Blvd-19, Suite 335
  • Jacksonville, Florida 32250
  • Phone: 904-655-2130
  • Fax: 904-647-6038
  • Contact Us
Page requested: /radius-search/?categories_id=26
Request Method: GET
Referrer:
User Agent: CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address: 3.221.159.255
Request Time: 0.11652803421021 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-find-senior-care-ldd.php 6
#4 include("/home/ourseniorsguide/public_html/wp-content/themes/seniorsguide/page-find-senior-care-ldd.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
                (
                    [0000000054e70e13000000005f8f1ee3rewriteTitle] => 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
                (
                    [0000000054e70999000000005f8f1ee3print_marker] => Array
                        (
                            [function] => Array
                                (
                                    [0] => C_Photocrati_Resource_Manager Object
                                        (
                                            [marker] => 
                                            [buffer] => 



    
                    
    
    
    
    
    
    
    
    
    		
	 
	

	
	

		
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	        	
		
		
		
		
		
		





		
		
	














 





    
    
    
    
    
    






Text Size: + -

Find Senior Care

Location:
Category:

Results

TestAdvertiser

Jacksonville, FL

Wekiva Springs Center

Jacksonville, FL

  • 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 ( [0000000054e70e17000000005f8f1ee3adminFooter] => 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
                (
                    [0000000054e70e13000000005f8f1ee3rewriteTitle] => 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
                (
                    [0000000054e70999000000005f8f1ee3print_marker] => Array
                        (
                            [function] => Array
                                (
                                    [0] => C_Photocrati_Resource_Manager Object
                                        (
                                            [marker] => 
                                            [buffer] => 



    
                    
    
    
    
    
    
    
    
    
    		
	 
	

	
	

		
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	        	
		
		
		
		
		
		





		
		
	














 





    
    
    
    
    
    






Text Size: + -

Find Senior Care

Location:
Category:

Results

TestAdvertiser

Jacksonville, FL

Wekiva Springs Center

Jacksonville, FL

  • 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 ( [0000000054e70e17000000005f8f1ee3adminFooter] => 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-find-senior-care-ldd.php 351
#8 include("/home/ourseniorsguide/public_html/wp-content/themes/seniorsguide/page-find-senior-care-ldd.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 
	    
            services.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
	services
	
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id


pdo Stub:

SELECT
	DISTINCT 
	    
            services.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
	services
	
LEFT JOIN
	tabmin_pages ON services.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


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 SQL_CALC_FOUND_ROWS
	    
            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
	(advertiser_pages_have_categories.categories_id = 26 AND advertisers.statuses_id IN (2,3)) AND roles_id=3
ORDER BY
	advertiser_types.search_results_order DESC, RAND()
LIMIT
	0,50


pdo Stub:

SELECT
	DISTINCT SQL_CALC_FOUND_ROWS
	    
            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
	(advertiser_pages_have_categories.categories_id = :categories_id AND advertisers.statuses_id IN (:statuses_id0,:statuses_id1)) AND roles_id=3
ORDER BY
	advertiser_types.search_results_order DESC, RAND()
LIMIT
	0,50


pdo:

SELECT
	FOUND_ROWS()


pdo:

INSERT INTO statistics
            (
                advertisers_id,
                stat_type
            )
            VALUES
            
            (
                385,
                "impression"
            ),
        (
            134,
             "impression"
        )


pdo Stub:

INSERT INTO statistics
            (
                advertisers_id,
                stat_type
            )
            VALUES
            
            (
                385,
                "impression"
            ),
        (
            134,
             "impression"
        )


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