Query problem

[adrpar]

SELECT PROG.mass, PROG.treeSnapnum, DES.mass, DES.treeSnapnum, DES.fofId, PROG.fofId, DES.lastProgId FROM MDR1.FOFMtree AS PROG, MDR1.FOFMtree AS DES WHERE DES.treeSnapnum=39 AND PROG.fofTreeId BETWEEN DES.fofTreeId AND DES.lastProgId AND PROG.mass > 1.e13 ORDER BY DES.fofId

Query fails with: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ( PROG.fofTreeId BETWEEN DES.fofTreeId AND DES.lastProgId ) LIMIT 0;' at line 1

CALL paquExec('SELECT PROG.mass AS PROG.mass,PROG.treeSnapnum AS PROG.treeSnapnum,PROG.fofId AS PROG.fofId,fofTreeId AS fofTreeId,mass AS mass FROM MDR1.FOFMtree AS PROG WHERE ( PROG.mass > 1.e13 ) ', 'aggregation_tmp_90798556'); CALL paquExec('SELECT DES.mass AS DES.mass,DES.treeSnapnum AS DES.treeSnapnum,DES.fofId AS DES.fofId,DES.lastProgId AS DES.lastProgId,PROG.PROG.mass AS PROG.mass,PROG.PROG.treeSnapnum AS PROG.treeSnapnum,PROG.PROG.fofId AS PROG.fofId FROM MDR1.FOFMtree AS DES JOIN ( SELECT PROG.mass,PROG.treeSnapnum,PROG.fofId,fofTreeId,mass FROM aggregation_tmp_90798556 ) AS PROG WHERE ( DES.treeSnapnum = 39 ) AND AND ( PROG.fofTreeId BETWEEN DES.fofTreeId AND DES.lastProgId ) ', 'aggregation_tmp_82710760'); CALL paquDropTmp('aggregation_tmp_90798556'); USE spider_tmp_shard; SET @i=0; CREATE TABLE cosmosim_user_adrian./*@GEN_RES_TABLE_HERE*/ ENGINE=MyISAM SELECT @i:=@i+1 AS row_id, DES.mass,DES.treeSnapnum,DES.fofId,DES.lastProgId,PROG.mass,PROG.treeSnapnum,PROG.fofId FROM aggregation_tmp_82710760 ORDER BY DES.fofId ASC ; CALL paquDropTmp('aggregation_tmp_82710760');

[adrpar]

fixed in da2918d619d784addccebe65fa112dc4b1bf7baf