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 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 = 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 001
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 661