Text Size: + -

Find Senior Care

Location:
Category:

Results

Beach House Assisted Living & Memory Care

Jacksonville Beach, FL

Beach House offers Assisted Living and Memory Care residences in a full-service, resort-like setting. Giving seniors with Alzheimer’s and other memory impairing dementia the care, respect, dignity and quality of life they deserve. Respite care is a temporary stay at a senior living community. Respite services can be offered for a variety of care levels, including assisted living and memory care. Located in Jacksonville Beach, FL

Amenities/Services: Off-Site Trips,Off-Site Outings,Transportation to Physicians,Medication Management,Private Apartments/ Rooms,One Bedroom Apartments,On-Site Laundry,Salon,Pets Allowed

San Jose Gardens

Jacksonville, FL

San Jose Gardens is a Alzheimer's special care center that provides a homelike residential option for seniors seeking elder care solutions. Offering Compassionate memory care or respite care. We engage in activities designed to the individuals interest. Our team is dedicated to our residents creating a happy and healthy environment for all residents.
CALL TODAY FOR A TOUR!!!!

Amenities/Services: Private Apartments/ Rooms,Semi-Private Apartments/ Rooms

Taylor Residences

Jacksonville, FL

Taylor Residences is an Active Retirement Community with services ranging from Independent Living, Assisted Living, Rehabilitation, Skilled Nursing and Memory Care. Taylor provides quality housing to seniors with a moderate income. Each level of care is based on the individual needs of every Senior.

Our Mission Statement:
“The Mission of Taylor Residences is to provide seniors age 62 and older with affordable housing in a community that values independence, privacy and dignity. We encourage residents to live up to their physical, social and spiritual potential through quality housing and services that include independent living, assisted living and skilled nursing.”


Amenities/Services: Limited Transportation,On-Site Special Events,Transportation to Physicians,Medication Management,In-Room Emergency Alert System,Private Apartments/ Rooms,Semi-Private Apartments/ Rooms,One Bedroom Apartments,Two Bedroom Apartments,Dining,On-Site Laundry,One Story Building,Studio/ Efficiency Apartments,Complimentary Consultation/ Assessment,Salon,Water Views,Veteran's Benefits,Assistance for the Disabled,Pets Allowed,Hospice Support

Ortega Gardens

Jacksonville, FL

Ortega Gardens specializes in Alzheimer's Care and understands that those living with memory loss are still able to lead fulfilling lives. We work with each resident to develop an individualized plan. Respite Stays can be provided for short/long term care. Activities uniquely designed for the residents of our community, where family and friends are encouraged to participate.


Amenities/Services:

Lanier Rehabilitation Center

Jacksonville, FL

Lanier Rehabilitation Center - Provides a home-like setting with professional staff. We have a program designed to fit your individual needs, including in house dialysis. Subacute care, long term, respite, hospice or dementia care.

Amenities/Services: On-Site Special Events,Medication Management,Private Apartments/ Rooms,Semi-Private Apartments/ Rooms,Dining,On-Site Laundry,One Story Building,Salon,Wound Vac Care,Advance Directives,Medicaid Planning,Hospice Support

A Care Connection Home Health

Jacksonville Beach, FL

Your Registered Nurse Patient Advocate - Home Care & Private Personalized Care for seniors. Services offered include: Skilled Nursing, Physical Therapy, Occupational Therapy, Speech Therapy, Medical Social Services , Home Health Aide & Private non-medical assistance.

Amenities/Services: Transportation to Physicians,Medication Management,Complimentary Consultation/ Assessment,Tracheotomy Care,Wound Vac Care,Assistance for the Disabled

Ponte Vedra Gardens

Ponte Vedra Beach, FL

Ponte Vedra Gardens is a Alzheimer's special care center that provides a homelike residential option for seniors seeking elder care solutions. Offering Compassionate memory care or respite care. We engage in activities designed to the individuals interest. Our team is dedicated to our residents creating a happy and healthy environment for all residents.

Amenities/Services: Private Apartments/ Rooms,Semi-Private Apartments/ Rooms

Silver Creek at St. Augustine

St. Augustine, FL

Silver Creek Is St. Augustine Florida's newest assisted living, memory care and short-term respite care community.

Silver Creek features 120 beautifully appointed residences: 72 assisted living and 48 memory care apartments. Residents enjoy a wide range of services, amenities and programs designed with a focus on whole-person wellness and life fulfillment. The amenities include neighborhood living rooms and lounge areas, library with computer center, multi-media center and movie theater, a variety of dining venues featuring chef-prepared, restaurant-style meals, fitness and physical therapy center, beauty salon and barber shop, card and game room, solarium, community education center, creative arts studio, and beautiful courtyard gardens with walking paths and covered seating.

“Silver Creek is a beautiful, innovative and unique community unlike anything else in St. Augustine,” said Sharon Benjamin, executive director at Silver Creek. “The campus itself is designed to support and empower residents physically, intellectually and socially. We offer a variety of activities, programs and events for our residents to ensure peace of mind for them, and their families.”

Silver Creek is located off Highway 207 on 21 acres and surrounded by a natural, wooded preserve. It’s exterior features Spanish architecture and is designed to withstand a Category 5 hurricane. The interior spaces include floor-to-ceiling windows for lots of natural light, wide corridors, vaulted ceilings and beautiful finishes throughout.

Silver Creek is owned and developed by Montgomery Land Company based in Jacksonville, and is currently accepting new residents. To learn more, visit www.SilverCreekRetirement.com.

Amenities/Services: Transportation to Physicians,Medication Management,One Bedroom Apartments,Two Bedroom Apartments,Dining,Salon,Pets Allowed

Westminster St.Augustine

St. Augustine, FL

Starling at Nocatee - Retirement Living

Ponte Vedra Beach, FL

Starling at Nocatee Assisted & Memory Care

Ponte Vedra Beach, FL

Starling At San Jose

Jacksonville, FL

American In-Home Care

Jacksonville, FL

Grand Living at Tamaya

Jacksonville, FL

The Windsor at San Pablo

Jacksonville, FL

Brooks Bartram Lakes

Jacksonville, FL

Griswold Home Care

Jacksonville, FL

Cypress Village Assisted Living

Jacksonville, FL

The Nancy House

Atlantic Beach, FL

Westminster Woods Retirement Living on Julington Creek

Jacksonville, FL

The Windsor at Ortega

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=44
Request Method: GET
Referrer:
User Agent: CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address: 18.214.23.30
Request Time: 0.11046195030212 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

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 = 44 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
            
            (
                66,
                "impression"
            ),
            (
                372,
                "impression"
            ),
            (
                366,
                "impression"
            ),
            (
                371,
                "impression"
            ),
            (
                356,
                "impression"
            ),
            (
                194,
                "impression"
            ),
            (
                373,
                "impression"
            ),
            (
                227,
                "impression"
            ),
            (
                352,
                "impression"
            ),
            (
                313,
                "impression"
            ),
            (
                260,
                "impression"
            ),
            (
                295,
                "impression"
            ),
            (
                240,
                "impression"
            ),
            (
                311,
                "impression"
            ),
            (
                165,
                "impression"
            ),
            (
                346,
                "impression"
            ),
            (
                103,
                "impression"
            ),
            (
                168,
                "impression"
            ),
            (
                84,
                "impression"
            ),
            (
                99,
                "impression"
            ),
        (
            176,
             "impression"
        )


pdo Stub:

INSERT INTO statistics
            (
                advertisers_id,
                stat_type
            )
            VALUES
            
            (
                66,
                "impression"
            ),
            (
                372,
                "impression"
            ),
            (
                366,
                "impression"
            ),
            (
                371,
                "impression"
            ),
            (
                356,
                "impression"
            ),
            (
                194,
                "impression"
            ),
            (
                373,
                "impression"
            ),
            (
                227,
                "impression"
            ),
            (
                352,
                "impression"
            ),
            (
                313,
                "impression"
            ),
            (
                260,
                "impression"
            ),
            (
                295,
                "impression"
            ),
            (
                240,
                "impression"
            ),
            (
                311,
                "impression"
            ),
            (
                165,
                "impression"
            ),
            (
                346,
                "impression"
            ),
            (
                103,
                "impression"
            ),
            (
                168,
                "impression"
            ),
            (
                84,
                "impression"
            ),
            (
                99,
                "impression"
            ),
        (
            176,
             "impression"
        )


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
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = 97


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
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = :advertiser_pages_id


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
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = 496


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
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = :advertiser_pages_id


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
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = 490


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
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = :advertiser_pages_id


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
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = 495


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
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = :advertiser_pages_id


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
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = 478


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
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = :advertiser_pages_id


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
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = 260


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
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = :advertiser_pages_id


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
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = 498


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
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = :advertiser_pages_id


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
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.advertiser_pages_id = 314


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
	advertiser_pages_have_services ON advertiser_pages_have_services.services_id = services.id
LEFT JOIN
	tabmin_pages ON services.tabmin_pages_id = tabmin_pages.id
LEFT JOIN
	pictures ON tabmin_pages.pictures_id = pictures.id
WHERE
	advertiser_pages_have_services.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