Le jaune, c’est le soleil qui a décidé de rester un peu sur Terre.
?
\pb in make_colorit_choice : SELECT /* colorit */ distinct(node2) FROM `Relations` WHERE
node1 = 21461
and type not in (4, 12, 18, 36)
and node2 not in (239128, 232492)
and node2 in (SELECT distinct(node1) FROM Relations WHERE node2 = 171870 AND type=4)
and node1 not in (219883, 143431, 18746, 54413, 244274, 146777, 46879, 151684, 188804, 129665, 219884, 56532, 249924, 37315, 6011, 71520, 221261, 222258, 28103, 190785, 104993, 120157, 145283, 98300, 160701, 118873, 102976, 244502, 14563, 99188, 35238, 86627, 16956, 13701, 71240, 16289, 151706, 87409, 60694, 58020, 59678, 107120, 189265, 235564, 190262, 187502, 42896, 64862, 260120, 103322, 88331, 221283, 146381, 165179, 7780, 28044, 259994, 223651, 247239, 96312, 140233, 152179, 17301, 82827, 52971, 93357, 140195, 113875, 188601, 56518, 36989, 78845, 103311, 250491, 128855, 12869, 110316, 123408, 119233, 145500, 30369, 116345, 114056, 141018, 26584, 20631, 26201, 15823, 91711, 91908, 82552, 80698, 19492, 91081, 3233, 9518, 6291, 77315, 5173, 75577)
and w >= 25
and R.node2 in (SELECT distinct(node1) FROM Relations WHERE node2=191741 AND type=36 AND w >= 10)
and node2 not in (0)
LIMIT 100
;