SELECT insc_basic.coin_num, insc_basic.updated_on, insc_basic.tribe, slides.filename, insc_basic.denomination,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 AND findspots.declong IS NOT NULL AND findspots.declat IS NOT NULL LIMIT 0,40