TV Stand

TV Stand

#11320 TV Stand - 48 Wide shown


Click Here for Wood & Stain Samples


ERROR - SELECT DISTINCT product_characteristics.CharacteristicsModifierID, tblcharacteristicsmod.CharacteristicsModDes, product_characteristics.ProductCharacteristicsNum, type.type, products.collection, product_characteristics.CharacteristicID, tblcharacteristicsmod.CharacteristicsMod, type.type AS itemTypeName, CASE ProductCharacteristicsNum WHEN 0 then 'on' WHEN 1 THEN '1.00 unit' ELSE concat(FORMAT(ProductCharacteristicsNum,2) , ' units') END AS NumMod FROM ((product_characteristics INNER JOIN tblcharacteristicsmod ON product_characteristics.CharacteristicsModifierID = tblcharacteristicsmod.CharacteristicsModID) INNER JOIN type ON product_characteristics.CharacteristicID = type.ID) INNER JOIN products ON product_characteristics.ProductCharacteristicsProID = products.id WHERE CharacteristicsModifierID = 4 AND () ORDER BY type.type, product_characteristics.ProductCharacteristicsNum