SELECT * FROM TYK_v_pag_lana WHERE id_filato=42  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><a href='index.asp?fil=14'>Classic Record</a></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><b>Drops Merino extrafine</b></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>Drops Merino extrafine</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>grigio</td><td>04MD</td><td>137</td><td><a href='index.asp?mag=1&fil=42&op=1&id=196'>+</a></td><td><a href='index.asp?mag=1fil=42&op=2&id=196'>-</a></td><td>26</td><td><a href='index.asp?mag=2&fil=42&op=1&id=196'>+</a></td><td><a href='index.asp?mag=2&fil=42&op=2&id=196'>-</a></td></tr>
<tr>
<td>mauve</td><td>22MD</td><td>135</td><td><a href='index.asp?mag=1&fil=42&op=1&id=170'>+</a></td><td><a href='index.asp?mag=1fil=42&op=2&id=170'>-</a></td><td><font color='red'>-1</font></td><td><a href='index.asp?mag=2&fil=42&op=1&id=170'>+</a></td><td><a href='index.asp?mag=2&fil=42&op=2&id=170'>-</a></td></tr>
<tr>
<td>olive green</td><td>18MD</td><td>146</td><td><a href='index.asp?mag=1&fil=42&op=1&id=169'>+</a></td><td><a href='index.asp?mag=1fil=42&op=2&id=169'>-</a></td><td>8</td><td><a href='index.asp?mag=2&fil=42&op=1&id=169'>+</a></td><td><a href='index.asp?mag=2&fil=42&op=2&id=169'>-</a></td></tr>
<tr>
<td>purple</td><td>21MD</td><td>122</td><td><a href='index.asp?mag=1&fil=42&op=1&id=171'>+</a></td><td><a href='index.asp?mag=1fil=42&op=2&id=171'>-</a></td><td>1</td><td><a href='index.asp?mag=2&fil=42&op=1&id=171'>+</a></td><td><a href='index.asp?mag=2&fil=42&op=2&id=171'>-</a></td></tr>
<tr>
<td>senape</td><td>30MD</td><td>122</td><td><a href='index.asp?mag=1&fil=42&op=1&id=197'>+</a></td><td><a href='index.asp?mag=1fil=42&op=2&id=197'>-</a></td><td>40</td><td><a href='index.asp?mag=2&fil=42&op=1&id=197'>+</a></td><td><a href='index.asp?mag=2&fil=42&op=2&id=197'>-</a></td></tr>
</table>