SELECT * FROM TYK_v_pag_lana WHERE id_filato=27  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><b>Drops Paris</b></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 Paris</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>Ballerina pink</td><td>33</td><td>154</td><td><a href='index.asp?mag=1&fil=27&op=1&id=41'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=41'>-</a></td><td>19</td><td><a href='index.asp?mag=2&fil=27&op=1&id=41'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=41'>-</a></td></tr>
<tr>
<td>Black</td><td>15</td><td>197</td><td><a href='index.asp?mag=1&fil=27&op=1&id=36'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=36'>-</a></td><td>8</td><td><a href='index.asp?mag=2&fil=27&op=1&id=36'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=36'>-</a></td></tr>
<tr>
<td>blue viola chiaro</td><td>32P</td><td>152</td><td><a href='index.asp?mag=1&fil=27&op=1&id=163'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=163'>-</a></td><td><font color='red'>0</font></td><td><a href='index.asp?mag=2&fil=27&op=1&id=163'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=163'>-</a></td></tr>
<tr>
<td>brown</td><td>44P</td><td>157</td><td><a href='index.asp?mag=1&fil=27&op=1&id=160'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=160'>-</a></td><td>10</td><td><a href='index.asp?mag=2&fil=27&op=1&id=160'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=160'>-</a></td></tr>
<tr>
<td>Denim blue</td><td>30</td><td>153</td><td><a href='index.asp?mag=1&fil=27&op=1&id=45'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=45'>-</a></td><td><font color='red'>-1</font></td><td><a href='index.asp?mag=2&fil=27&op=1&id=45'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=45'>-</a></td></tr>
<tr>
<td>Dusty old pink</td><td>59</td><td>148</td><td><a href='index.asp?mag=1&fil=27&op=1&id=43'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=43'>-</a></td><td>4</td><td><a href='index.asp?mag=2&fil=27&op=1&id=43'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=43'>-</a></td></tr>
<tr>
<td>Dusty orange</td><td>45</td><td>151</td><td><a href='index.asp?mag=1&fil=27&op=1&id=39'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=39'>-</a></td><td><font color='red'>-9</font></td><td><a href='index.asp?mag=2&fil=27&op=1&id=39'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=39'>-</a></td></tr>
<tr>
<td>Green</td><td>43</td><td>166</td><td><a href='index.asp?mag=1&fil=27&op=1&id=48'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=48'>-</a></td><td><font color='red'>-6</font></td><td><a href='index.asp?mag=2&fil=27&op=1&id=48'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=48'>-</a></td></tr>
<tr>
<td>Light gray</td><td>23</td><td>152</td><td><a href='index.asp?mag=1&fil=27&op=1&id=35'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=35'>-</a></td><td><font color='red'>0</font></td><td><a href='index.asp?mag=2&fil=27&op=1&id=35'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=35'>-</a></td></tr>
<tr>
<td>Light purple</td><td>05</td><td>149</td><td><a href='index.asp?mag=1&fil=27&op=1&id=44'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=44'>-</a></td><td><font color='red'>-6</font></td><td><a href='index.asp?mag=2&fil=27&op=1&id=44'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=44'>-</a></td></tr>
<tr>
<td>Mauve pink</td><td>60</td><td>148</td><td><a href='index.asp?mag=1&fil=27&op=1&id=42'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=42'>-</a></td><td><font color='red'>-5</font></td><td><a href='index.asp?mag=2&fil=27&op=1&id=42'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=42'>-</a></td></tr>
<tr>
<td>Mint green</td><td>21</td><td>149</td><td><a href='index.asp?mag=1&fil=27&op=1&id=47'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=47'>-</a></td><td><font color='red'>-18</font></td><td><a href='index.asp?mag=2&fil=27&op=1&id=47'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=47'>-</a></td></tr>
<tr>
<td>Offwhite</td><td>17</td><td>152</td><td><a href='index.asp?mag=1&fil=27&op=1&id=34'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=34'>-</a></td><td><font color='red'>-6</font></td><td><a href='index.asp?mag=2&fil=27&op=1&id=34'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=34'>-</a></td></tr>
<tr>
<td>Peach</td><td>27</td><td>151</td><td><a href='index.asp?mag=1&fil=27&op=1&id=38'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=38'>-</a></td><td>12</td><td><a href='index.asp?mag=2&fil=27&op=1&id=38'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=38'>-</a></td></tr>
<tr>
<td>Raspberry</td><td>38</td><td>152</td><td><a href='index.asp?mag=1&fil=27&op=1&id=40'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=40'>-</a></td><td><font color='red'>-6</font></td><td><a href='index.asp?mag=2&fil=27&op=1&id=40'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=40'>-</a></td></tr>
<tr>
<td>red</td><td>12P</td><td>167</td><td><a href='index.asp?mag=1&fil=27&op=1&id=161'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=161'>-</a></td><td><font color='red'>0</font></td><td><a href='index.asp?mag=2&fil=27&op=1&id=161'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=161'>-</a></td></tr>
<tr>
<td>Sunflower yellow</td><td>14</td><td>166</td><td><a href='index.asp?mag=1&fil=27&op=1&id=37'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=37'>-</a></td><td>23</td><td><a href='index.asp?mag=2&fil=27&op=1&id=37'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=37'>-</a></td></tr>
<tr>
<td>turchese chiaro</td><td>02P</td><td>144</td><td><a href='index.asp?mag=1&fil=27&op=1&id=155'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=155'>-</a></td><td>5</td><td><a href='index.asp?mag=2&fil=27&op=1&id=155'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=155'>-</a></td></tr>
<tr>
<td>Turquoise</td><td>10</td><td>152</td><td><a href='index.asp?mag=1&fil=27&op=1&id=46'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=46'>-</a></td><td>1</td><td><a href='index.asp?mag=2&fil=27&op=1&id=46'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=46'>-</a></td></tr>
<tr>
<td>Verde militare</td><td>42P</td><td>178</td><td><a href='index.asp?mag=1&fil=27&op=1&id=162'>+</a></td><td><a href='index.asp?mag=1fil=27&op=2&id=162'>-</a></td><td><font color='red'>-119</font></td><td><a href='index.asp?mag=2&fil=27&op=1&id=162'>+</a></td><td><a href='index.asp?mag=2&fil=27&op=2&id=162'>-</a></td></tr>
</table>