Disclaimer

Thistle & Rose products are hand-crafted, using original techniques and materials from sustainable sources. Some allowance should be made for possible shrinkage and slight size differentials. Extreme changes in humidity levels or exposure to dampness should be avoided.

Marble is also a unique natural material, no two pieces being the same. Samples should be understood to be a guide rather than a precise image of what could be supplied.

 

(default) 11 queries took 12 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `pages`24242
2DESCRIBE `media`16161
3DESCRIBE `fireplaces`24241
4DESCRIBE `slips`991
5DESCRIBE `grates`221
6DESCRIBE `grate_images`772
7DESCRIBE `bullnoses`17171
8SELECT `Page`.`id`, `Page`.`title`, `Page`.`short_title`, `Page`.`parent_id`, `Page`.`type`, `Page`.`slug`, `Page`.`is_published`, (COUNT(`ParentPage`.`id`)-1) AS depth FROM `pages` AS `Page` INNER JOIN pages AS `ParentPage` ON (`Page`.`lft` BETWEEN `ParentPage`.`lft` AND `ParentPage`.`rght`) WHERE 1 = 1 GROUP BY `Page`.`id` ORDER BY `Page`.`lft` ASC 4324320
9SELECT `Page`.`type`, `Page`.`foreign_key` FROM `pages` AS `Page` WHERE id = 41 LIMIT 1110
10SELECT `Page`.`id`, `Page`.`parent_id`, `Page`.`lft`, `Page`.`rght`, `Page`.`ordering`, `Page`.`type`, `Page`.`foreign_key`, `Page`.`slug`, `Page`.`title`, `Page`.`short_title`, `Page`.`content`, `Page`.`description`, `Page`.`main_image_id`, `Page`.`thumb_image_id`, `Page`.`thumb_text`, `Page`.`is_published`, `Page`.`is_locked`, `Page`.`is_for_sale`, `Page`.`is_sold`, `Page`.`show_thumbs`, `Page`.`created`, `Page`.`updated`, `Page`.`created_by`, `Page`.`updated_by`, `MainImage`.`id`, `MainImage`.`model`, `MainImage`.`foreign_key`, `MainImage`.`filename`, `MainImage`.`ext`, `MainImage`.`mimetype`, `MainImage`.`filesize`, `MainImage`.`checksum`, `MainImage`.`dir`, `MainImage`.`height`, `MainImage`.`width`, `MainImage`.`description`, `MainImage`.`version`, `MainImage`.`ordering`, `MainImage`.`created`, `MainImage`.`updated`, `ThumbImage`.`id`, `ThumbImage`.`model`, `ThumbImage`.`foreign_key`, `ThumbImage`.`filename`, `ThumbImage`.`ext`, `ThumbImage`.`mimetype`, `ThumbImage`.`filesize`, `ThumbImage`.`checksum`, `ThumbImage`.`dir`, `ThumbImage`.`height`, `ThumbImage`.`width`, `ThumbImage`.`description`, `ThumbImage`.`version`, `ThumbImage`.`ordering`, `ThumbImage`.`created`, `ThumbImage`.`updated` FROM `pages` AS `Page` LEFT JOIN `media` AS `MainImage` ON (`Page`.`main_image_id` = `MainImage`.`id`) LEFT JOIN `media` AS `ThumbImage` ON (`Page`.`thumb_image_id` = `ThumbImage`.`id`) WHERE `Page`.`id` = 41 LIMIT 1111
11SELECT `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`filename`, `Image`.`ext`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`checksum`, `Image`.`dir`, `Image`.`height`, `Image`.`width`, `Image`.`description`, `Image`.`version`, `Image`.`ordering`, `Image`.`created`, `Image`.`updated` FROM `media` AS `Image` WHERE model = "Page" AND `Image`.`foreign_key` = (41) ORDER BY `Image`.`ordering` ASC 002