SELECT * FROM TYK_v_pag_lana WHERE id_filato=1  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><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><b>Lovely Jeans</b></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>Lovely Jeans</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></td><td>80</td><td>163</td><td><a href='index.asp?mag=1&fil=1&op=1&id=120'>+</a></td><td><a href='index.asp?mag=1fil=1&op=2&id=120'>-</a></td><td>4</td><td><a href='index.asp?mag=2&fil=1&op=1&id=120'>+</a></td><td><a href='index.asp?mag=2&fil=1&op=2&id=120'>-</a></td></tr>
<tr>
<td></td><td>74</td><td>161</td><td><a href='index.asp?mag=1&fil=1&op=1&id=122'>+</a></td><td><a href='index.asp?mag=1fil=1&op=2&id=122'>-</a></td><td>8</td><td><a href='index.asp?mag=2&fil=1&op=1&id=122'>+</a></td><td><a href='index.asp?mag=2&fil=1&op=2&id=122'>-</a></td></tr>
<tr>
<td>Azzurro jeans</td><td>73</td><td>159</td><td><a href='index.asp?mag=1&fil=1&op=1&id=118'>+</a></td><td><a href='index.asp?mag=1fil=1&op=2&id=118'>-</a></td><td><font color='red'>-23</font></td><td><a href='index.asp?mag=2&fil=1&op=1&id=118'>+</a></td><td><a href='index.asp?mag=2&fil=1&op=2&id=118'>-</a></td></tr>
<tr>
<td>bianco crema</td><td>79</td><td>163</td><td><a href='index.asp?mag=1&fil=1&op=1&id=117'>+</a></td><td><a href='index.asp?mag=1fil=1&op=2&id=117'>-</a></td><td><font color='red'>-5</font></td><td><a href='index.asp?mag=2&fil=1&op=1&id=117'>+</a></td><td><a href='index.asp?mag=2&fil=1&op=2&id=117'>-</a></td></tr>
<tr>
<td>Gray mix</td><td>90</td><td>163</td><td><a href='index.asp?mag=1&fil=1&op=1&id=121'>+</a></td><td><a href='index.asp?mag=1fil=1&op=2&id=121'>-</a></td><td>5</td><td><a href='index.asp?mag=2&fil=1&op=1&id=121'>+</a></td><td><a href='index.asp?mag=2&fil=1&op=2&id=121'>-</a></td></tr>
<tr>
<td>Lilac</td><td>88</td><td>165</td><td><a href='index.asp?mag=1&fil=1&op=1&id=119'>+</a></td><td><a href='index.asp?mag=1fil=1&op=2&id=119'>-</a></td><td><font color='red'>-8</font></td><td><a href='index.asp?mag=2&fil=1&op=1&id=119'>+</a></td><td><a href='index.asp?mag=2&fil=1&op=2&id=119'>-</a></td></tr>
</table>