select *, date_format( dictionary_cdate, '%Y.%m.%d' ) as cdate, left ( dictionary_furigana, 3 ) as furigana from dictionary_table where dictionary_title = 'ホールド・ツゥ・ラン制御装置.html' and dictionary_ddate is null