DELIMITER$$DROPPROCEDUREIFEXISTSeventsNearMe$$CREATEPROCEDUREeventsNearMe(INinIPVARCHAR(16))BEGINDECLAREipLATFLOAT;DECLAREipLONGFLOAT;SELECTiplocationdb_location.latitude,iplocationdb_location.longitudeINTOipLAT,ipLONGFROM`iplocationdb_ip`LEFTJOINiplocationdb_locationONiplocationdb_location.id=i