SELECT insc_basic.*, inscr_details.*,findspots.*,SUBSTRING( findspots.declong, 1, 4 ) AS lng, SUBSTRING( findspots.declat, 1, 4 ) AS lat FROM ((insc_basic LEFT JOIN slides ON insc_basic.coin_num = slides.coin_num) LEFT JOIN findspots ON insc_basic.coin_num = findspots.coin_num) LEFT JOIN inscr_details ON inscr_details.coin_num = insc_basic.coin_num WHERE