Find Care: Agency Caregivers

Select Region»Minnesota

Available Agency Caregivers

There were no listings found

(default) 18 queries took 123 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `pages`772
2SELECT `Page`.`id`, `Page`.`name`, `Page`.`slug`, `Page`.`title`, `Page`.`body`, `Page`.`created`, `Page`.`modified` FROM `pages` AS `Page` WHERE 1 = 1 12122
3DESCRIBE `msa`442
4DESCRIBE `caregivers_fresh`54543
5DESCRIBE `agencies`363614
6DESCRIBE `agency_jobs`28283
7DESCRIBE `private_jobs`57578
8DESCRIBE `states`3370
9DESCRIBE `counties`446
10DESCRIBE `settings`442
11DESCRIBE `track`11112
12SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`group` FROM `settings` AS `Setting` WHERE 1 = 1 15150
13SELECT `State`.`name`, `State`.`id`, `State`.`slug` FROM `states` AS `State` WHERE `State`.`slug` = 'minnesota' LIMIT 1115
14SELECT COUNT(*) AS `count` FROM `agencies` AS `Agency` WHERE `state` = 'MN' AND `inquiry` = 0 AND `Agency`.`hidden` != 1 AND `inquiry` != 1 AND `Agency`.`renewal` != "" AND `Agency`.`renewal` > "2010-03-19" 111
15DESCRIBE `zipcodes`16162
16SELECT `Agency`.`id`, `Agency`.`inquiry`, `Agency`.`name`, `Agency`.`contact_firstname`, `Agency`.`contact_lastname`, `Agency`.`address`, `Agency`.`city`, `Agency`.`state`, `Agency`.`zip`, `Agency`.`region`, `Agency`.`county`, `Agency`.`contact_phone`, `Agency`.`business_phone`, `Agency`.`alternate_business_phone`, `Agency`.`email`, `Agency`.`referrer`, `Agency`.`website`, `Agency`.`type_of_business`, `Agency`.`start_year`, `Agency`.`number_of_staff`, `Agency`.`conditions`, `Agency`.`care_provided`, `Agency`.`certifications`, `Agency`.`board`, `Agency`.`languages`, `Agency`.`payments_accepted`, `Agency`.`summary`, `Agency`.`copy`, `Agency`.`logo`, `Agency`.`created`, `Agency`.`modified`, `Agency`.`renewed`, `Agency`.`renewal`, `Agency`.`status`, `Agency`.`posted`, `Agency`.`hidden` FROM `agencies` AS `Agency` WHERE `state` = 'MN' AND `inquiry` = 0 AND `Agency`.`hidden` != 1 AND `inquiry` != 1 AND `Agency`.`renewal` != "" AND `Agency`.`renewal` > "2010-03-19" ORDER BY `Agency`.`created` DESC LIMIT 20001
17SELECT `State`.`name`, `State`.`id`, `State`.`slug` FROM `states` AS `State` WHERE 1 = 1 53530
18SELECT `State`.`id`, `State`.`name` FROM `states` AS `State` WHERE 1 = 1 53530