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 7 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `pages`24241
2DESCRIBE `media`16161
3DESCRIBE `fireplaces`24241
4DESCRIBE `slips`990
5DESCRIBE `grates`220
6DESCRIBE `grate_images`770
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