select distinct wr_parent from g5_write_event where ca_name = 'Other' and (wr_num between -40 and (-40 + 10000)) ORDER BY COALESCE( STR_TO_DATE(NULLIF(TRIM(wr_3), ''), '%Y-%m-%d'), STR_TO_DATE(NULLIF(TRIM(wr_3), ''), '%Y/%m/%d'), STR_TO_DATE(NULLIF(TRIM(wr_3), ''), '%Y.%m.%d'), STR_TO_DATE(NULLIF(TRIM(wr_3), ''), '%M %d, %Y'), STR_TO_DATE(NULLIF(TRIM(wr_3), ''), '%b %d, %Y'), wr_datetime ) DESC, wr_num, wr_reply limit 0, 20

3065 : Expression #1 of ORDER BY clause is not in SELECT list, references column 'horizon.g5_write_event.wr_3' which is not in SELECT list; this is incompatible with DISTINCT

error file : /bbs/board.php