SELECT * FROM TYK_v_pag_lana WHERE id_filato=14  ORDER BY [Colore *]<br><div class='menu'><ul><li><a href='index.asp?fil=32'>Alpaca</a></li><li><a href='index.asp?fil=24'>Ardelaine</a></li><li><a href='index.asp?fil=29'>Baby alpaca silk</a></li><li><a href='index.asp?fil=22'>Bamboo Lux</a></li><li><a href='index.asp?fil=4'>California</a></li><li><a href='index.asp?fil=16'>Canada</a></li><li><a href='index.asp?fil=35'>Casba</a></li><li><a href='index.asp?fil=23'>Cashmere</a></li><li><b>Classic Record</b></li><li><a href='index.asp?fil=10'>Cotone Egitto</a></li><li><a href='index.asp?fil=45'>Cotton mixed</a></li><li><a href='index.asp?fil=36'>Cotton special</a></li><li><a href='index.asp?fil=31'>Cotton viscose</a></li><li><a href='index.asp?fil=38'>Cuerda Sacocharte</a></li><li><a href='index.asp?fil=43'>Drops Alaska</a></li><li><a href='index.asp?fil=44'>Drops Alpaca</a></li><li><a href='index.asp?fil=25'>Drops Andes</a></li><li><a href='index.asp?fil=28'>Drops Big Delight</a></li><li><a href='index.asp?fil=40'>Drops Eskimo</a></li><li><a href='index.asp?fil=34'>Drops Love you</a></li><li><a href='index.asp?fil=51'>Drops Merino Big</a></li><li><a href='index.asp?fil=42'>Drops Merino extrafine</a></li><li><a href='index.asp?fil=26'>Drops Nepal</a></li><li><a href='index.asp?fil=27'>Drops Paris</a></li><li><a href='index.asp?fil=41'>Drops Safran</a></li><li><a href='index.asp?fil=21'>Eco chic</a></li><li><a href='index.asp?fil=11'>Full</a></li><li><a href='index.asp?fil=1'>Lovely Jeans</a></li><li><a href='index.asp?fil=33'>Manos</a></li><li><a href='index.asp?fil=18'>Merino Plus</a></li><li><a href='index.asp?fil=5'>Millefili Fine</a></li><li><a href='index.asp?fil=7'>Natur</a></li><li><a href='index.asp?fil=37'>Noro</a></li><li><a href='index.asp?fil=20'>Pampas</a></li><li><a href='index.asp?fil=3'>Petra</a></li><li><a href='index.asp?fil=46'>Socks</a></li><li><a href='index.asp?fil=9'>Solare</a></li><li><a href='index.asp?fil=2'>Thema</a></li><li><a href='index.asp?fil=50'>Vollknoll Horstia Iceland</a></li><li><a href='index.asp?fil=49'>Vollknoll Wickyarn</a></li><li><a href='index.asp?fil=17'>Zara Plus</a></li><li><a href='index.asp?fil=19'>Zarina</a></li></ul></div><h1>Classic Record</h1>
<table>
<tr>
<td>Colore</td>
<td>Codice</td>
<td>Stella</td>
<td></td>
<td></td>
<td>Stefania</td>
<td></td>
<td></td>
</tr>
<tr>
<td>beige</td><td>6823</td><td>170</td><td><a href='index.asp?mag=1&fil=14&op=1&id=101'>+</a></td><td><a href='index.asp?mag=1fil=14&op=2&id=101'>-</a></td><td>18</td><td><a href='index.asp?mag=2&fil=14&op=1&id=101'>+</a></td><td><a href='index.asp?mag=2&fil=14&op=2&id=101'>-</a></td></tr>
<tr>
<td>china blue</td><td>8964</td><td>159</td><td><a href='index.asp?mag=1&fil=14&op=1&id=100'>+</a></td><td><a href='index.asp?mag=1fil=14&op=2&id=100'>-</a></td><td>11</td><td><a href='index.asp?mag=2&fil=14&op=1&id=100'>+</a></td><td><a href='index.asp?mag=2&fil=14&op=2&id=100'>-</a></td></tr>
<tr>
<td>melanzana</td><td>705</td><td>170</td><td><a href='index.asp?mag=1&fil=14&op=1&id=97'>+</a></td><td><a href='index.asp?mag=1fil=14&op=2&id=97'>-</a></td><td>7</td><td><a href='index.asp?mag=2&fil=14&op=1&id=97'>+</a></td><td><a href='index.asp?mag=2&fil=14&op=2&id=97'>-</a></td></tr>
<tr>
<td>rosa chiaro</td><td>86276</td><td>186</td><td><a href='index.asp?mag=1&fil=14&op=1&id=99'>+</a></td><td><a href='index.asp?mag=1fil=14&op=2&id=99'>-</a></td><td>16</td><td><a href='index.asp?mag=2&fil=14&op=1&id=99'>+</a></td><td><a href='index.asp?mag=2&fil=14&op=2&id=99'>-</a></td></tr>
<tr>
<td>Rosa corallo</td><td>6416</td><td>161</td><td><a href='index.asp?mag=1&fil=14&op=1&id=96'>+</a></td><td><a href='index.asp?mag=1fil=14&op=2&id=96'>-</a></td><td><font color='red'>-10</font></td><td><a href='index.asp?mag=2&fil=14&op=1&id=96'>+</a></td><td><a href='index.asp?mag=2&fil=14&op=2&id=96'>-</a></td></tr>
<tr>
<td>viola</td><td>0701</td><td>186</td><td><a href='index.asp?mag=1&fil=14&op=1&id=98'>+</a></td><td><a href='index.asp?mag=1fil=14&op=2&id=98'>-</a></td><td>25</td><td><a href='index.asp?mag=2&fil=14&op=1&id=98'>+</a></td><td><a href='index.asp?mag=2&fil=14&op=2&id=98'>-</a></td></tr>
</table>