{supertable/ query} {supertable source/}{name findlay}{database findlay_products}{driver mysqli}{host localhost}{user findlayfoods}{password Beb0pdab0p}{/source}{supertable class test}{query/} select sku, description, pack, msds, brand, extdesc, case when msds = '' then concat('') else concat(' ') end as msds_link , case when extdesc = '' then concat(replace(replace(description,'"',''),'#','')) else concat('',replace(replace(description,'"',''),'#',''),' ') end as desc_link From findlay_inv where msds = "Y" order by sku asc{/query}{bodywidth 12 auto 25 15}{rowheight 1 30px}{rowheight * 30px}{highlight rows}{headrows 2}{thead/}{cell/}{style text-align: left;text-indent:5px; white-space: nowrap;text-transform: uppercase; font-size: 16px;}FINDLAY FOODS - ALL Available MSDS Sheets by Product Code{/cell}{cell/}{/cell}{cell/}{/cell}{cell/}{/cell}{/thead}{thead/}{cell/}{class info_link}{style text-align: center;text-indent:5px; background-color: black;border: 1px solid black;}Code{/cell}{cell/}{class info_link}{style text-align: center;text-indent:5px; background-color: black;border: 1px solid black;}Description{/cell}{cell/}{style text-align: center; background-color: black;border: 1px solid black;}DOWNLOAD MSDS PDF{/cell}{cell/}{style text-align: center; background-color: black; border: 1px solid black;}Pack Size{/cell}{/thead}{tbody/}{cell/}{style text-align: center; font-size: 120%; vertical-align: middle; }{text.data sku}{/cell}{cell/}{style text-align: left;text-indent:5px;text-transform: uppercase;vertical-align: middle;}{text.data desc_link}{subtext.data brand sprintf.Brand: %s}{/cell}{cell/}{style text-align: center;vertical-align: middle;}{text.data msds_link}{/cell}{cell/}{style text-align: center;vertical-align: middle;}{text.data pack}{/cell} {/tbody}{/supertable}