SELECT * FROM TYK_v_pag_lana WHERE id_filato=25  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><b>Drops Andes</b></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>Drops Andes</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>Amethist</td><td>3410</td><td>145</td><td><a href='index.asp?mag=1&fil=25&op=1&id=210'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=210'>-</a></td><td>21</td><td><a href='index.asp?mag=2&fil=25&op=1&id=210'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=210'>-</a></td></tr>
<tr>
<td>Beige</td><td>0619m</td><td>139</td><td><a href='index.asp?mag=1&fil=25&op=1&id=66'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=66'>-</a></td><td>1</td><td><a href='index.asp?mag=2&fil=25&op=1&id=66'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=66'>-</a></td></tr>
<tr>
<td>Black</td><td>8903</td><td>154</td><td><a href='index.asp?mag=1&fil=25&op=1&id=54'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=54'>-</a></td><td><font color='red'>-2</font></td><td><a href='index.asp?mag=2&fil=25&op=1&id=54'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=54'>-</a></td></tr>
<tr>
<td>Blue denim</td><td>6295</td><td>147</td><td><a href='index.asp?mag=1&fil=25&op=1&id=55'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=55'>-</a></td><td>12</td><td><a href='index.asp?mag=2&fil=25&op=1&id=55'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=55'>-</a></td></tr>
<tr>
<td>Blue navy</td><td>6990</td><td>148</td><td><a href='index.asp?mag=1&fil=25&op=1&id=57'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=57'>-</a></td><td>11</td><td><a href='index.asp?mag=2&fil=25&op=1&id=57'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=57'>-</a></td></tr>
<tr>
<td>Blue royal</td><td>6928</td><td>132</td><td><a href='index.asp?mag=1&fil=25&op=1&id=56'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=56'>-</a></td><td><font color='red'>-3</font></td><td><a href='index.asp?mag=2&fil=25&op=1&id=56'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=56'>-</a></td></tr>
<tr>
<td>blue/purple</td><td>4301</td><td>144</td><td><a href='index.asp?mag=1&fil=25&op=1&id=61'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=61'>-</a></td><td>5</td><td><a href='index.asp?mag=2&fil=25&op=1&id=61'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=61'>-</a></td></tr>
<tr>
<td>brown</td><td>5610</td><td>161</td><td><a href='index.asp?mag=1&fil=25&op=1&id=59'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=59'>-</a></td><td><font color='red'>-1</font></td><td><a href='index.asp?mag=2&fil=25&op=1&id=59'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=59'>-</a></td></tr>
<tr>
<td>cherry red</td><td>3755</td><td>139</td><td><a href='index.asp?mag=1&fil=25&op=1&id=67'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=67'>-</a></td><td><font color='red'>-10</font></td><td><a href='index.asp?mag=2&fil=25&op=1&id=67'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=67'>-</a></td></tr>
<tr>
<td>Christmas red</td><td>3620</td><td>161</td><td><a href='index.asp?mag=1&fil=25&op=1&id=53'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=53'>-</a></td><td>23</td><td><a href='index.asp?mag=2&fil=25&op=1&id=53'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=53'>-</a></td></tr>
<tr>
<td>dark gray mix</td><td>0519m</td><td>137</td><td><a href='index.asp?mag=1&fil=25&op=1&id=72'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=72'>-</a></td><td><font color='red'>-32</font></td><td><a href='index.asp?mag=2&fil=25&op=1&id=72'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=72'>-</a></td></tr>
<tr>
<td>gray mix</td><td>9015m</td><td>136</td><td><a href='index.asp?mag=1&fil=25&op=1&id=71'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=71'>-</a></td><td>5</td><td><a href='index.asp?mag=2&fil=25&op=1&id=71'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=71'>-</a></td></tr>
<tr>
<td>heather</td><td>4090</td><td>137</td><td><a href='index.asp?mag=1&fil=25&op=1&id=68'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=68'>-</a></td><td><font color='red'>-8</font></td><td><a href='index.asp?mag=2&fil=25&op=1&id=68'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=68'>-</a></td></tr>
<tr>
<td>Ice blue</td><td>8112</td><td>160</td><td><a href='index.asp?mag=1&fil=25&op=1&id=50'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=50'>-</a></td><td><font color='red'>-17</font></td><td><a href='index.asp?mag=2&fil=25&op=1&id=50'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=50'>-</a></td></tr>
<tr>
<td>light beige</td><td>0206m</td><td>152</td><td><a href='index.asp?mag=1&fil=25&op=1&id=64'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=64'>-</a></td><td>15</td><td><a href='index.asp?mag=2&fil=25&op=1&id=64'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=64'>-</a></td></tr>
<tr>
<td>Light brown</td><td>5310</td><td>160</td><td><a href='index.asp?mag=1&fil=25&op=1&id=58'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=58'>-</a></td><td>9</td><td><a href='index.asp?mag=2&fil=25&op=1&id=58'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=58'>-</a></td></tr>
<tr>
<td>Light grey green</td><td>7120</td><td>145</td><td><a href='index.asp?mag=1&fil=25&op=1&id=52'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=52'>-</a></td><td><font color='red'>-43</font></td><td><a href='index.asp?mag=2&fil=25&op=1&id=52'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=52'>-</a></td></tr>
<tr>
<td>medium gray</td><td>8465</td><td>141</td><td><a href='index.asp?mag=1&fil=25&op=1&id=70'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=70'>-</a></td><td><font color='red'>-20</font></td><td><a href='index.asp?mag=2&fil=25&op=1&id=70'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=70'>-</a></td></tr>
<tr>
<td>Moss green</td><td>7810</td><td>142</td><td><a href='index.asp?mag=1&fil=25&op=1&id=51'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=51'>-</a></td><td>7</td><td><a href='index.asp?mag=2&fil=25&op=1&id=51'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=51'>-</a></td></tr>
<tr>
<td>off white</td><td>0100</td><td>139</td><td><a href='index.asp?mag=1&fil=25&op=1&id=63'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=63'>-</a></td><td><font color='red'>0</font></td><td><a href='index.asp?mag=2&fil=25&op=1&id=63'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=63'>-</a></td></tr>
<tr>
<td>Old pink</td><td>4300</td><td>137</td><td><a href='index.asp?mag=1&fil=25&op=1&id=60'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=60'>-</a></td><td><font color='red'>-3</font></td><td><a href='index.asp?mag=2&fil=25&op=1&id=60'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=60'>-</a></td></tr>
<tr>
<td>pearl gray</td><td>4010</td><td>143</td><td><a href='index.asp?mag=1&fil=25&op=1&id=73'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=73'>-</a></td><td>5</td><td><a href='index.asp?mag=2&fil=25&op=1&id=73'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=73'>-</a></td></tr>
<tr>
<td>powder pink</td><td>3145</td><td>142</td><td><a href='index.asp?mag=1&fil=25&op=1&id=69'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=69'>-</a></td><td><font color='red'>-6</font></td><td><a href='index.asp?mag=2&fil=25&op=1&id=69'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=69'>-</a></td></tr>
<tr>
<td>purple</td><td>4066</td><td>138</td><td><a href='index.asp?mag=1&fil=25&op=1&id=62'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=62'>-</a></td><td>25</td><td><a href='index.asp?mag=2&fil=25&op=1&id=62'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=62'>-</a></td></tr>
<tr>
<td>Turquoise</td><td>6420</td><td>161</td><td><a href='index.asp?mag=1&fil=25&op=1&id=49'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=49'>-</a></td><td>4</td><td><a href='index.asp?mag=2&fil=25&op=1&id=49'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=49'>-</a></td></tr>
<tr>
<td>Twilight Blue</td><td>6343</td><td>144</td><td><a href='index.asp?mag=1&fil=25&op=1&id=211'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=211'>-</a></td><td><font color='red'>-6</font></td><td><a href='index.asp?mag=2&fil=25&op=1&id=211'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=211'>-</a></td></tr>
<tr>
<td>White</td><td>0101</td><td>141</td><td><a href='index.asp?mag=1&fil=25&op=1&id=65'>+</a></td><td><a href='index.asp?mag=1fil=25&op=2&id=65'>-</a></td><td><font color='red'>-16</font></td><td><a href='index.asp?mag=2&fil=25&op=1&id=65'>+</a></td><td><a href='index.asp?mag=2&fil=25&op=2&id=65'>-</a></td></tr>
</table>