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, 0, 0, 0 FROM tblPlans, tblDesigners, tblStyles WHERE tblPlans.designer = 92 AND tblPlans.designer = tblDesigners.id and tblPlans.style = tblStyles.id and upper(tblPlans.designer_plan_num) in ('A9401-A','A9401-B','A9401-3S') and tblPlans.approved = 'Y' and tblDesigners.approved = 'Y' and tblPlans.deleted <> 'Y' ORDER BY tblPlans.id