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 27 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `pages`24245
2DESCRIBE `media`16163
3DESCRIBE `fireplaces`24244
4DESCRIBE `slips`994
5DESCRIBE `grates`223
6DESCRIBE `grate_images`773
7DESCRIBE `bullnoses`17174
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 1110
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 001