select distinct CO.comiket_num, CO.comike_house, CO.comike_col, CD.col_num, CO.comike_row, CO.comike_table, CO.circle_name, CO.comike_day, date_format(CO.comike_day,"%m/%d") comike_day_j from COMIKET_DATA CO ,COL_DATA CD where CO.comiket_num= and CO.comike_day='' and CD.col_num= AND CO.comike_col = CD.col_name order by CO.comike_day,CO.comike_house,CO.comike_col,CO.comike_row,CO.comike_table
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 CO.comike_day='' and CD.col_num= AND CO.comike_col = CD.col_name order b' at line 1