Hola:
Tengo un problema con consultas mysql en un sitio mounstruoso
Las consultas mysql gigantes y se generan a partir de 10 o mas archivos php en una forma caotica.
Necesito algun programa que me muestre si la consulta mysql esta bien hecha o tiene algun error de sintaxis para no desperdiciar tiempo.
No lo puedo probar directamente en mysql ya que la consulta consume todos lso recursos de mysql dandome el error 28
Si es que alguien es capo para ver el error dejo una de las consultas para que la vean, ojala me puedan recomendar algun programa
saludos
Código PHP:
select u.userid , ((( ((( ( ( CASE ( IF (instr( u.gender, 'Male' ) , 0,IF (instr( u.gender, 'C2M' ) , 0,IF (instr( u.gender, 'Female' ) , 0,IF (instr( u.gender, 'C2W' ) , 0,IF (instr( u.gender, 'C' ) , 0, 0 ))))) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + if(((year(now())-year(u.date_of_birth)>=0) and (year(now())-year(u.date_of_birth)<=0)),0,0) + if( (m.mwm_seek_age_from>=0 and (m.mwm_seek_age_to<=0) ),0,0) + ( ( ( CASE ( IF (instr( u.zip, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + ( ( ( CASE ( IF (instr( u.ethnicity, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + ( ( ( CASE ( IF (instr( u.rel_status, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + ( ( ( CASE ( IF (instr( u.num_child, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + ( ( ( CASE ( IF (instr( u.occupation, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + ( ( ( CASE ( IF (instr( u.education, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + ( ( ( CASE ( IF (instr( u.religion, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + ( ( ( CASE ( IF (instr( u.income, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + ( ( ( CASE ( IF (instr( u.body, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + ( ( ( CASE ( IF (instr( u.eye_color, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + ( ( ( CASE ( IF (instr( u.hair_color, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + ( ( ( CASE ( IF (instr( u.hair_type, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + ( ( ( CASE ( IF (instr( u.height, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + ( ( ( CASE ( IF (instr( u.drink, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + ( ( ( CASE ( IF (instr( u.smoke, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + ( ( ( CASE ( IF (instr( u.zodiac, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + ( ( ( CASE ( IF (instr( u.orient, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) + ( ( ( CASE ( IF (instr( u.community, '' ) , 0, 0 ) )
WHEN 0
THEN 0
ELSE
0
END
) ) ) )*100/0))+ ((round( (( ( (CASE ( IF (instr( u.mwm_food, ',,' ) ,0,0) + 0 )
WHEN 0
THEN 0
WHEN 1
THEN
0
WHEN 2
THEN 0
ELSE
0
END
) ) )*100/0) + (( ( (CASE ( IF (instr( u.mwm_music, ',,' ) ,0,0) + 0 )
WHEN 0
THEN 0
WHEN 1
THEN
0
WHEN 2
THEN 0
ELSE
0
END
) ) )*100/0) + (( ( (CASE ( IF (instr( u.mwm_movie, ',,' ) ,0,0) + 0 )
WHEN 0
THEN 0
WHEN 1
THEN
0
WHEN 2
THEN 0
ELSE
0
END
) ) )*100/0) + (( ( (CASE ( IF (instr( u.mwm_interest, ',,' ) ,0,0) + 0 )
WHEN 0
THEN 0
WHEN 1
THEN
0
WHEN 2
THEN 0
ELSE
0
END
) ) )*100/0) + (( ( (CASE ( IF (instr( u.mwm_language, ',,' ) ,0,0) + 0 )
WHEN 0
THEN 0
WHEN 1
THEN
0
WHEN 2
THEN 0
ELSE
0
END
) ) )*100/0) + (( ( (CASE ( IF (instr( u.sports, ',,' ) ,0,0) + 0 )
WHEN 0
THEN 0
WHEN 1
THEN
0
WHEN 2
THEN 0
ELSE
0
END
) ) )*100/0) + (( ( (CASE ( IF (instr( u.purpose, ',,' ) ,0,0) + 0 )
WHEN 0
THEN 0
WHEN 1
THEN
0
WHEN 2
THEN 0
ELSE
0
END
) ) )*100/0) ))/7))/2) AS cpoints from hs_users as u,hs_match as m inner join `hs_user_photos` as p on p.userid=u.userid and p.main=1 and p.approved=1 and ( ((u.mwm_seeking_for like '%,Male,%' or u.mwm_seeking like 'Male') and u.gender='Female') and date_of_birth between DATE('1966-01-01') and DATE('1985-12-31')) and u.userid!='remsankar' and u.suspend=0 and u.hide=0 and mwm_regflag='ok' order by cpoints desc ,mwm_plan desc