Pine Shadows Motel

Specials

Condo at Pine Shadows Motel, West Yellowstone

Cabin at Pine Shadows Motel, West Yellowstone

Current Specials

Looking to come snowmobiling this winter? Ask us about stay and play packages. please see hicountry www.hicountrysnowmobiles.com for sled options

Our rates vary by time of the year. Call (800) 624-5291 between 9 am and 8 pm Mountain time, or fill out an Information Request Form and we will email you a quote.

(default) 8 queries took 17 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `contents`	10	10	2
2	DESCRIBE `callouts`	5	5	3
3	SELECT `Content`.`id`, `Content`.`title`, `Content`.`introText`, `Content`.`bodyText`, `Content`.`keywords`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`created`, `Content`.`modified`, `Content`.`ranking`, `Parentpage`.`id`, `Parentpage`.`title`, `Parentpage`.`introText`, `Parentpage`.`bodyText`, `Parentpage`.`keywords`, `Parentpage`.`slug`, `Parentpage`.`parent_id`, `Parentpage`.`created`, `Parentpage`.`modified`, `Parentpage`.`ranking` FROM `contents` AS `Content` LEFT JOIN `contents` AS `Parentpage` ON (`Content`.`parent_id` = `Parentpage`.`id`) WHERE `Content`.`id` = 18 LIMIT 1	1	1	2
4	SELECT `Childpage`.`id`, `Childpage`.`title`, `Childpage`.`introText`, `Childpage`.`bodyText`, `Childpage`.`keywords`, `Childpage`.`slug`, `Childpage`.`parent_id`, `Childpage`.`created`, `Childpage`.`modified`, `Childpage`.`ranking` FROM `contents` AS `Childpage` WHERE `Childpage`.`parent_id` = (18)	0	0	2
5	SELECT `Callout`.`id`, `Callout`.`content_id`, `Callout`.`title`, `Callout`.`content`, `Callout`.`image` FROM `callouts` AS `Callout` WHERE `Callout`.`content_id` = (18)	0	0	2
6	SELECT `Content`.`id`, `Content`.`title`, `Content`.`introText`, `Content`.`bodyText`, `Content`.`keywords`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`created`, `Content`.`modified`, `Content`.`ranking`, `Parentpage`.`id`, `Parentpage`.`title`, `Parentpage`.`introText`, `Parentpage`.`bodyText`, `Parentpage`.`keywords`, `Parentpage`.`slug`, `Parentpage`.`parent_id`, `Parentpage`.`created`, `Parentpage`.`modified`, `Parentpage`.`ranking` FROM `contents` AS `Content` LEFT JOIN `contents` AS `Parentpage` ON (`Content`.`parent_id` = `Parentpage`.`id`) WHERE `Content`.`parent_id` IS NULL ORDER BY `Content`.`ranking` ASC	7	7	4
7	SELECT `Childpage`.`id`, `Childpage`.`title`, `Childpage`.`introText`, `Childpage`.`bodyText`, `Childpage`.`keywords`, `Childpage`.`slug`, `Childpage`.`parent_id`, `Childpage`.`created`, `Childpage`.`modified`, `Childpage`.`ranking` FROM `contents` AS `Childpage` WHERE `Childpage`.`parent_id` IN (1, 15, 17, 21, 19, 20, 18)	0	0	1
8	SELECT `Callout`.`id`, `Callout`.`content_id`, `Callout`.`title`, `Callout`.`content`, `Callout`.`image` FROM `callouts` AS `Callout` WHERE `Callout`.`content_id` IN (1, 15, 17, 21, 19, 20, 18)	1	1	1

(default) 8 queries took 17 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `contents`

DESCRIBE `callouts`

SELECT `Content`.`id`, `Content`.`title`, `Content`.`introText`, `Content`.`bodyText`, `Content`.`keywords`, `Content`.`slug`, `Content`.`parent_id`, `Content`.`created`, `Content`.`modified`, `Content`.`ranking`, `Parentpage`.`id`, `Parentpage`.`title`, `Parentpage`.`introText`, `Parentpage`.`bodyText`, `Parentpage`.`keywords`, `Parentpage`.`slug`, `Parentpage`.`parent_id`, `Parentpage`.`created`, `Parentpage`.`modified`, `Parentpage`.`ranking` FROM `contents` AS `Content` LEFT JOIN `contents` AS `Parentpage` ON (`Content`.`parent_id` = `Parentpage`.`id`) WHERE `Content`.`id` = 18 LIMIT 1

SELECT `Childpage`.`id`, `Childpage`.`title`, `Childpage`.`introText`, `Childpage`.`bodyText`, `Childpage`.`keywords`, `Childpage`.`slug`, `Childpage`.`parent_id`, `Childpage`.`created`, `Childpage`.`modified`, `Childpage`.`ranking` FROM `contents` AS `Childpage` WHERE `Childpage`.`parent_id` = (18)

SELECT `Callout`.`id`, `Callout`.`content_id`, `Callout`.`title`, `Callout`.`content`, `Callout`.`image` FROM `callouts` AS `Callout` WHERE `Callout`.`content_id` = (18)

SELECT `Callout`.`id`, `Callout`.`content_id`, `Callout`.`title`, `Callout`.`content`, `Callout`.`image` FROM `callouts` AS `Callout` WHERE `Callout`.`content_id` IN (1, 15, 17, 21, 19, 20, 18)