Error Number: 1054
Unknown column 'MALE' in 'where clause'
SELECT (SELECT DOG_KINDS_MANAGEMENT_IDX FROM ( SELECT @RNUM:=@RNUM+1 AS ROWNUM , a.* FROM (SELECT @RNUM:=0) R, dog_kinds_management a order by SHOW_LEVEL asc ) B WHERE ROWNUM = ( SELECT ROWNUM FROM ( SELECT @RNUM:=@RNUM+1 AS ROWNUM , a.* FROM (SELECT @RNUM:=0) R, dog_kinds_management a order by SHOW_LEVEL asc ) A WHERE DOG_KINDS_MANAGEMENT_IDX = MALE )-1 ) AS PRE_VAL, (SELECT DOG_KINDS_MANAGEMENT_IDX FROM ( SELECT @RNUM:=@RNUM+1 AS ROWNUM , a.* FROM (SELECT @RNUM:=0) R, dog_kinds_management a order by SHOW_LEVEL asc ) B WHERE ROWNUM = ( SELECT ROWNUM FROM ( SELECT @RNUM:=@RNUM+1 AS ROWNUM , a.* FROM (SELECT @RNUM:=0) R, dog_kinds_management a order by SHOW_LEVEL asc ) A WHERE DOG_KINDS_MANAGEMENT_IDX = MALE )+1 ) AS NEXT_VAL FROM DUAL
Filename: models/Db_m.php
Line Number: 38