SELECT insc_basic.coin_num, DATE_FORMAT(insc_basic.created_on, '%a, %d %b %Y:%k:%i:%s GMT') AS  created,insc_basic.denomination FROM (insc_basic LEFT JOIN inscr_details ON insc_basic.coin_num = inscr_details.coin_num) LEFT JOIN findspots ON insc_basic.coin_num = findspots.coin_num WHERE