select a., b. from multidark_test.FOF as a, multidark_test.FOF as b where a.x=0.998373 or (a.y=sin(0.998373) and b.z=0.998373) and b.z=43 or ((a.z=23 and a.z=4) or a.x=1) or a.y=34 and a.x between 1 and 2 or b.z=1+5*87.2134
Probably I need to redo the whole WHERE with JOIN and distribution logic.
adrpar
commented
11 years ago
A query like this is horribly broken:
select a., b. from
multidark_test.FOFas a,multidark_test.FOFas b where a.x=0.998373 or (a.y=sin(0.998373) and b.z=0.998373) and b.z=43 or ((a.z=23 and a.z=4) or a.x=1) or a.y=34 and a.x between 1 and 2 or b.z=1+5*87.2134Probably I need to redo the whole WHERE with JOIN and distribution logic.