-

SELECT DISTINCT products_extra_fields_value FROM products_to_products_extra_fields p2pef, products_to_categories p2c WHERE products_extra_fields_id='615' and products_extra_fields_value<>'' and products_extra_fields_value is not null and p2pef.products_id=p2c.products_id and p2c.categories_id in(,1,2,3,13,46,227,226,225,224,295,303,304,305,306,357,643,4,215,354,5,8,20,35,36,42,48,51,231,230,229,228,293,311,312,313,314,315,316,360,6,7,16,29,44,221,220,219,218,217,216,294,296,355,9,10,11,12,21,22,31,32,40,49,52,317,318,319,320,321,322,323,324,361,421,422,423,14,53,307,308,309,310,359,15,17,18,19,41,54,223,222,297,298,299,300,301,302,356,23,233,332,358,24,25,480,481,482,483,484,485,486,487,26,27,28,30,33,34,37,38,39,45,47,50,55,232,353,419,420,43,82,214,213,211,209,352,89,267,331,415,416,417,418,56,57,58,62,63,64,72,74,75,76,326,59,60,70,329,373,429,430,431,432,433,61,65,66,67,68,69,257,256,244,413,414,71,84,281,287,343,259,199,288,328,344,401,402,403,73,266,250,251,389,375,390,391,392,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,249,424,425,436,437,469,470,471,438,439,77,78,81,264,262,254,253,248,245,243,240,238,210,207,205,201,350,79,80,252,200,351,265,202,260,212,203,349,348,378,412,83,284,283,279,276,275,206,286,341,498,406,500,509,508,514,520,518,517,507,505,504,510,519,506,502,522,523,525,526,528,530,531,533,535,538,539,612,613,614,615,616,634,541,545,546,549,550,551,552,553,554,558,560,561,562,563,564,566,567,569,572,577,579,580,582,583,626,627,628,629,633,585,588,590,592,594,598,599,600,601,603,604,605,607,610,521,512,503,513,597,516,511,515,501,524,527,529,532,534,537,542,543,544,547,548,555,556,557,559,565,568,570,571,573,574,575,576,578,581,584,586,587,589,591,593,595,596,602,606,608,609,620,611,618,617,619,621,622,623,624,625,630,635,636,637,638,642,644,645,646,632,540,631,639,536,641,499,497,496,488,85,91,273,271,269,272,270,362,363,364,365,368,369,370,472,263,473,474,475,86,87,88,92,204,327,347,371,426,427,428,90,247,386,387,434,435,93,94,261,258,255,239,383,489,490,491,492,493,234,237,235,278,274,268,236,325,476,477,478,479,346,372,393,407,408,409,410,411,394,395,396,397,398,399,400,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679)

[TEP STOP]