Furniture Restoration

We have been restoring antiques since the late 1970s, working on pieces that have required us to master a wide range of skills and processes. It is endlessly fascinating work and gives first hand appreciation of the quality of design and craftmanship that is our heritage.

(default) 13 queries took 9 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `pages`24241
2DESCRIBE `media`16160
3DESCRIBE `fireplaces`24241
4DESCRIBE `slips`990
5DESCRIBE `grates`220
6DESCRIBE `grate_images`770
7DESCRIBE `bullnoses`17170
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 = 23 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` = 23 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` = (23) ORDER BY `Image`.`ordering` ASC 002
12SELECT `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
13SELECT Page.id, Page.title, Page.short_title, Page.thumb_text, Page.is_for_sale, Page.is_sold, MainImage.filename, MainImage.model, MainImage.foreign_key, MainImage.ext, ThumbImage.filename, ThumbImage.model, ThumbImage.foreign_key, ThumbImage.ext, FireplaceImage.filename, FireplaceImage.model, FireplaceImage.foreign_key, FireplaceImage.ext, `MainImage`.`id`, `ThumbImage`.`id` FROM `pages` AS `Page` LEFT JOIN fireplaces AS `Fireplace` ON (`Page`.`foreign_key` = `Fireplace`.`id` AND `Page`.`type` = "Fireplace") LEFT JOIN media AS `FireplaceImage` ON (`FireplaceImage`.`id` = `Fireplace`.`unpainted_image_id`) 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` IN (345,87,88,89,94,95) ORDER BY `Page`.`ordering` ASC 664