SELECT * 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 AND declong IS NOT NULL AND declat IS NOT NULL