All content is copyright © 2012 by The Southern Designer, LLC .
ALL SALES FINAL

SELECT viewed, tblPlans.id, concat('SD-',substring('000000',1,4-length(CAST(tblPlans.id as char(60)))),CAST(tblPlans.id as char(60)),'-',CAST(tblDesigners.id as char(60))) AS Expr1, tblPlans.title, tblStyles.name, tblPlans.ft_total, tblPlans.beds, tblPlans.baths, tblPlans.width, tblPlans.depth, tblPlans.width_in, tblPlans.depth_in, tblPlans.plan_type, tblPlans.ft_heated, tblPlans.beds2, tblPlans.baths2, tblSpecialDesigns.name FROM tblDesigners, tblPlans, tblStyles, tblSpecialDesigns WHERE tblPlans.designer = tblDesigners.id and tblPlans.style = tblStyles.id and (tblPlans.plan_type = 1 or tblPlans.plan_type = 4 or tblPlans.plan_type = 2) and tblPlans.approved = 'Y' and tblDesigners.approved = 'Y' and tblPlans.deleted != 'Y' and tblPlans.special_design = tblSpecialDesigns.id and ft_heated between 3000 and 3500 ORDER BY tblPlans.rank desc, tblDesigners.rank desc, ft_heated