select distinct `dates`.programID,programtour.program_types from dates,programtour where dates.daynote like '%พรรษา%' and (dates.shows = '0') and dates.daynote like '%พรรษา%' and dates.noteday NOT LIKE '%เต็ม%' and dates.programID = programtour.programID and programtour.shows = '1' and (programtour.country = 'ญี่ปุ่น' ) ORDER BY `dates`.`programID` DESC