-- MySQL dump 10.10
--
-- Host: localhost    Database: V63
-- ------------------------------------------------------
-- Server version	5.0.13-rc-nt-max-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `pfrcnto`
--

DROP TABLE IF EXISTS `pfrcnto`;
CREATE TABLE `pfrcnto` (
  `RTRCTO` varchar(2) character set latin1 collate latin1_bin NOT NULL,
  `RTRCNT` varchar(40) character set latin1 collate latin1_bin default NULL,
  `RTABRN` varchar(10) character set latin1 collate latin1_bin default NULL,
  `RTDIRR` varchar(40) character set latin1 collate latin1_bin default NULL,
  `RTPOBR` varchar(25) character set latin1 collate latin1_bin default NULL,
  `RTPRVR` varchar(15) character set latin1 collate latin1_bin default NULL,
  `RTPOSR` varchar(10) character set latin1 collate latin1_bin default NULL,
  `RTTEL1` varchar(15) character set latin1 collate latin1_bin default NULL,
  `RTTEL2` varchar(15) character set latin1 collate latin1_bin default NULL,
  `RTFAXR` varchar(15) character set latin1 collate latin1_bin default NULL,
  `RTDIST` varchar(3) character set latin1 collate latin1_bin NOT NULL,
  `RTNOT1` varchar(30) character set latin1 collate latin1_bin default NULL,
  `RTNOT2` varchar(30) character set latin1 collate latin1_bin default NULL,
  `RTNOT3` varchar(30) character set latin1 collate latin1_bin default NULL,
  `RTOBS1` varchar(40) character set latin1 collate latin1_bin default NULL,
  `RTOBS2` varchar(40) character set latin1 collate latin1_bin default NULL,
  `RTPUER` int(11) default NULL,
  `RTACTD` varchar(2) character set latin1 collate latin1_bin NOT NULL,
  `RTAUTO` int(11) default NULL,
  `RTFMTR` varchar(8) character set latin1 collate latin1_bin default NULL,
  `RTPLAN` int(11) default NULL,
  `RTCUSR` int(11) default NULL,
  `RTRNUM` int(11) default NULL,
  `RTSPAC` int(11) default NULL,
  `RTDARA` int(11) default NULL,
  `RTNLCA` int(11) default NULL,
  `RTNLMT` int(11) default NULL,
  `RTZOUN` int(11) default NULL,
  `RTNUMR` int(11) default NULL,
  `RTCONF` varchar(3) character set latin1 collate latin1_bin NOT NULL,
  `RTFLG1` varchar(1) character set latin1 collate latin1_bin default NULL,
  `RTFLG2` varchar(1) character set latin1 collate latin1_bin default NULL,
  `RTFLG3` varchar(1) character set latin1 collate latin1_bin default NULL,
  `RTFLG4` varchar(1) character set latin1 collate latin1_bin default NULL,
  `RTCOCO` varchar(2) character set latin1 collate latin1_bin default NULL,
  `RTSALA` int(11) default NULL,
  `RTPIVA` int(11) default NULL,
  `RTCOPO` varchar(15) character set latin1 collate latin1_bin default NULL,
  `RTNOEM` varchar(25) character set latin1 collate latin1_bin default NULL,
  `RTREEM` varchar(15) character set latin1 collate latin1_bin default NULL,
  `RTCOSA` varchar(12) character set latin1 collate latin1_bin default NULL,
  `RTTISA` varchar(1) character set latin1 collate latin1_bin default NULL,
  `RTMULT` varchar(1) character set latin1 collate latin1_bin default NULL,
  `RTENVD` varchar(1) character set latin1 collate latin1_bin default NULL,
  `RTHATR` varchar(5) character set latin1 collate latin1_bin default '00:00',
  `RTHCTR` varchar(5) character set latin1 collate latin1_bin default '00:00',
  `RTMXAC` int(11) default '0',
  `RTHCTQ` varchar(5) character set latin1 collate latin1_bin default '00:00',
  `RTCTAF` varchar(1) character set latin1 collate latin1_bin default '0',
  `RTPAIS` varchar(4) character set latin1 collate latin1_bin default NULL,
  `RTPROV` varchar(3) character set latin1 collate latin1_bin default NULL,
  `RTPOBL` varchar(7) character set latin1 collate latin1_bin default NULL,
  `RTSIST` varchar(4) character set latin1 collate latin1_bin default '0000',
  `RTTCOB` varchar(1) character set latin1 collate latin1_bin default '0',
  `RTDESP` varchar(1) character set latin1 collate latin1_bin default NULL,
  `RTCINE` varchar(12) character set latin1 collate latin1_bin default NULL,
  `RTCONT` bigint(20) default NULL,
  `RTIDPC` varchar(2) character set latin1 collate latin1_bin default NULL,
  `RTCALND` varchar(2) character set latin1 collate latin1_bin default NULL,
  `RTCIFI` varchar(1) character set latin1 collate latin1_bin default NULL,
  PRIMARY KEY  (`RTRCTO`),
  KEY `LFPFRCNTO01` (`RTSIST`),
  KEY `PFRCNTO_FK_PFLISCA_CCALI` (`RTRCTO`,`RTFLG1`),
  KEY `PFRCNTO_FK_PFCCALENDAR_CCALND` (`RTSIST`,`RTCALND`),
  KEY `PFRCNTO_FK_PFCOCOM_CCOME` (`RTRCTO`,`RTCOCO`),
  KEY `PFRCNTO_FK_PFCCOMI_CCOMI` (`RTSIST`,`RTRCTO`,`RTIDPC`),
  KEY `PFRCNTO_FK_PFCCONF_CCONF` (`RTRCTO`,`RTCONF`),
  KEY `PFRCNTO_FK_PFPOBLA_CPOBL2` (`RTPAIS`,`RTPROV`,`RTPOBL`),
  KEY `PFRCNTO_FK_PFRDADM_CRADM` (`RTDIST`),
  CONSTRAINT `pfrcnto_ibfk_1` FOREIGN KEY (`RTRCTO`, `RTFLG1`) REFERENCES `pflisca` (`LIRCTO`, `LILIST`) ON UPDATE NO ACTION,
  CONSTRAINT `pfrcnto_ibfk_2` FOREIGN KEY (`RTSIST`, `RTCALND`) REFERENCES `pfccalendar` (`CFESIST`, `CFECODI`) ON UPDATE NO ACTION,
  CONSTRAINT `pfrcnto_ibfk_3` FOREIGN KEY (`RTRCTO`, `RTCOCO`) REFERENCES `pfcocom` (`CMRCTO`, `CMCOCO`) ON UPDATE NO ACTION,
  CONSTRAINT `pfrcnto_ibfk_4` FOREIGN KEY (`RTSIST`, `RTRCTO`, `RTIDPC`) REFERENCES `pfccomi` (`CPSIST`, `CPRCTO`, `CPIDPC`) ON UPDATE NO ACTION,
  CONSTRAINT `pfrcnto_ibfk_5` FOREIGN KEY (`RTRCTO`, `RTCONF`) REFERENCES `pfcconf` (`CFRCTO`, `CFCCFG`) ON UPDATE NO ACTION,
  CONSTRAINT `pfrcnto_ibfk_6` FOREIGN KEY (`RTPAIS`, `RTPROV`, `RTPOBL`) REFERENCES `pfpobla` (`PBPAIS`, `PBPROV`, `PBPOBL`) ON UPDATE NO ACTION,
  CONSTRAINT `pfrcnto_ibfk_7` FOREIGN KEY (`RTDIST`) REFERENCES `pfrdadm` (`RAREDA`) ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;

--
-- Dumping data for table `pfrcnto`
--


/*!40000 ALTER TABLE `pfrcnto` DISABLE KEYS */;
LOCK TABLES `pfrcnto` WRITE;
INSERT INTO `pfrcnto` VALUES ('40','ARTICULOS','MUSEO     ','Paseo Mikeletigui, 43','Miramon5 - San Sebastian','Guipúzcoa','08206','943012478','t2','f','KTX','40',' ',' ','ARTICULOS',' ',0,'GG',0,' ',0,0,0,0,0,20000,4,1,3,'999','S','R','T','E','99',1,8,'12345',' ',' ','123456',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',NULL,'99','02','R'),('50','ATHLETIC CLUB','San Mamés ','San Mamés Zelaia','Bilbao','Vizcaya',' ',' ','G-48074264',' ','BBK','50',' ',' ','ATHLETIC CLUB',' ',1,'JJ',1,' ',0,0,1,0,1,40648,4,1,3,'999','S','R','T','E','04',1,7,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'LF','02','R'),('83','Teatro Victoria Eugenia','Victoria  ','PSO.REPÚBLICA  ARGENTINA, S/N','SAN SEBASTÍAN','GUIPÚZCOA','20004','943421874','','','KTX','83',' ',' ','Teatro Victoria Eugenia',' ',0,'BB',1,' ',0,0,1,1,1,1235,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','02','R'),('84','Quincena Musical','QUINCENA  ','C/REINA REGENTE,9','SAN SEBASTIÁN ','GUIPÚZCOA','20003','943481238','','','ALB','84',' ',' ','Quincena Musical',' ',0,'KK',1,' ',0,0,1,1,1,1279,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',NULL,'99','02','R'),('91','Teatro Principal de Vitoria','PRINCIPAL ','Plaza de Isabel II, s/n','Vitoria','Vitoria','00001','945 16 10 45','','','ICS','91',' ',' ','Teatro Principal Antzokia',' ',0,'JJ',1,' ',0,0,1,1,1,1054,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,'01 ',NULL,'2095',NULL,'0','',NULL,'04','02','P'),('A1','Bilbondo Sala 1','Sala1     ','ZALABANDI, S/N','BASAURI','VIZCAYA','48970','944407401','F-76543210',' ','BBK','A1',' ',' ','Bilbondo Sala 1 ',' ',0,'II',1,' ',0,0,1,1,1,167,4,0,3,'999','C','N','T','E','99',1,8,' ',' ',' ','502862',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',100,'22','02','P'),('A2','Bilbondo Sala 2','Sala2     ','BARRIO ZALABANDI, S/N','BASAURI','VIZCAYA','48970','944407401','F-76543210',' ','BBK','A2',' ',' ','BILBONDO SALA 2 ',' ',0,'II',1,' ',0,0,1,1,1,212,4,0,3,'999','S','N','T','E','99',2,8,' ',' ',' ','502876',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',100,'99','02','R'),('A3','Bilbondo Sala 3','Sala3     ','BARRIO ZALABANDI, S/N','BASAURI','VIZCAYA','48970','944407401','F-76543210',' ','BBK','A3',' ',' ','BILBONDO SALA 3 ',' ',0,'II',1,' ',0,0,1,1,1,136,4,0,3,'999','S','N','T','E','99',3,8,' ',' ',' ','502880',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',100,'99','02','R'),('A4','Bilbondo Sala 4','Sala4     ','BARRIO ZALABANDI, S/N','BASAURI','VIZCAYA','48970',' 944407401','F-76543210',' ','BBK','A4',' ',' ','BILBONDO SALA 4 ',' ',0,'II',1,' ',0,0,1,1,1,134,4,0,3,'999','S','N','T','E','99',4,8,' ',' ',' ','502894',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',100,'99','01','R'),('A5','Bilbondo Sala 5','Sala5     ','BARRIO ZALABANDI, S/N','BASAURI','VIZCAYA','48970','944407401','F-76543210',' ','BBK','A5',' ',' ','BILBONDO SALA 5 ',' ',0,'II',1,' ',0,0,1,1,1,150,4,0,3,'999','S','N','T','E','99',5,8,' ',' ',' ','502901',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',100,'99','02','R'),('A6','Bilbondo Sala 6','Sala6     ','BARRIO ZALABANDI, S/N','BASAURI','VIZCAYA','48970','944407401','F-76543210',' ','BBK','A6',' ',' ','BILBONDO SALA 6 ',' ',0,'II',1,' ',0,0,1,1,1,137,4,0,3,'999','S','N','T','E','99',6,8,' ',' ',' ','502915',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',100,'99','02','R'),('A7','Bilbondo Sala 7','Sala7     ','BARRIO ZALABANDI, S/N','BASAURI','VIZCAYA','48970','944407401','F-76543210',' ','BBK','A7',' ',' ','BILBONDO SALA7 ',' ',0,'II',1,' ',0,0,1,1,1,350,4,0,3,'999','S','N','T','E','99',7,8,' ',' ',' ','502920',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',100,'99','00','R'),('A8','Bilbondo Sala 8','Sala8     ','BARRIO ZALABANDI, S/N','BASAURI','VIZCAYA',' 48970','944407401 ','F-76543210',' ','BBK','A8',' ',' ','BILBONDO SALA 8 ',' ',0,'II',1,' ',0,0,1,1,1,398,4,0,3,'999','S','N','T','E','99',8,8,' ',' ',' ','502933',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',100,'99','00','R'),('AB','Auditorio Euskalduna ABAO','AUDITORIO ','AVDA.ABANDOIBARRA, 4','BILBAO','VIZCAYA','48011','944035000','','','BBK','AB',' ',' ','Auditorio Euskalduna ABAO ',' ',1,'AA',1,' ',1,0,1,1,1,2164,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('AC','Auditorio Santa Cruz de Tenerife','Audit. Te.','dir','pob','pro','CP','t1','t2','f','ICS','AC','AC',' ','Auditorio Sta. Cruz Tenerife ',' ',1,'AA',1,' ',1,0,1,1,1,1567,4,0,3,'999','S','N','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0','',NULL,'99','99','R'),('AE','Auditorio Euskalduna','AUDITORIO ','AVDA.ABANDOIBARRA, 4','BILBAO','BIZKAIA','48011','944035000','A-123456789','','ICS','AE',' ',' ','Auditorio Euskalduna',' ',1,'AA',1,' ',1,0,1,1,1,2164,20,0,3,'999','S','R','T','E','01',1,8,'48 ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','48000',613,'99','99','P'),('AG','AYUNTAMIENTO DE AGÜIMES','Agüimes   ','dirección','Las Palmas Gran Canaria','Gran Canaria','xxxxx','tel1','tel2','fax','CIC',' ',' ',' ','AYUNTAMIENTO DE AGÜIMES',' ',0,'FF',1,' ',0,0,0,0,0,500,4,1,3,'999','S','R',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2052','0','0','',0,'99','99','R'),('AP','Auditorio y Palacio Congresos Castellón','Auditorio ','C/ Lopez Fernandez 23','Castellón','Castellón','CP','953256256','68568542','f','ICS','{PC30;0230,0620,1,1,17,00,B|}',' ',' ','Auditorio y Palacio Congresos Castellón',' ',0,'AA',1,' ',1,0,1,1,1,1285,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',NULL,'99','99','R'),('AR','Teatro Arriaga - BOS','ARRIAGA   ','PZA.ARRIAGA, S/N','BILBAO','VIZCAYA','','944163244','48005','','BBK','AR',' ',' ','Teatro Arriaga - BOS ',' ',0,'BB',1,' ',0,0,0,1,1,1602,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,612,'99','99','R'),('AT','Teatro Arriaga','ARRIAGA   ','PZA. ARRIAGA,S/N','  BILBAO','VIZCAYA','48005','944163244','45127845-H','','BBK','AT',' ',' ','Teatro Arriaga ',' ',0,'BB',1,' ',1,0,1,1,1,50,50,0,4,'999','S','R','T','E','99',1,8,' ','ARRIAGA S.A.',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',612,'D4','00','R'),('AU','AMAIA UDAL ANTZOKIA(ARRASATE)','AMAIA UDAL','Dirección','Población','Provincia','xxxxx','tel1','tel2','fax','KTX',' ',' ',' ','AMAIA UDAL ANTZOKIA',' ',0,'AA',1,' ',1,0,1,1,1,789,4,0,3,'999','S','R',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2101','0','0','',0,'99','99','R'),('AX','Air-GeneralTickets MD-83','MD-83     ',' ',' ',' ',' ',' ',' ',' ','ICS',' ',' ',' ','Air-GeneralTickets MD-83',' ',1,'AA',1,' ',0,0,1,1,1,162,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,NULL,NULL,NULL,NULL,NULL,NULL),('AZ','Auditorio Palacio de Congresos','AUDITORIO ','dir','pob','pro','50020','t1','454693215-H','f','CAI','AZ',' ',' ','Auditorio Palacio de Congresos ',' ',1,'FF',1,' ',1,0,1,1,1,1992,4,0,3,'ANG','C','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',NULL,'TE','99','R'),('B1','Cine Basauri Social','Social    ','Dirección','Población','Provincia',' ',' ',' ',' ','ICS','B1',' ',' ','Cine Basauri Social',' ',0,'II',1,' ',0,0,1,1,1,756,4,0,3,'001','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,91,'99','99','R'),('BA','BASTERO KULTURGUNEA','TEATRO    ','Dirección','Población','Provincia','xxxxx','tel1','tel2','fax','KTX',' ',' ',' ','BASTERO KULTURGUNEA',' ',0,'AA',1,' ',1,0,1,1,1,500,4,0,3,'999','S','R',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',0,'99','99','R'),('BE','Auditorio Euskalduna B.O.S.','B.O.S.    ','AVDA.ABANDOIBARRA, 4','BILBAO','VIZCAYA','48011','944035000','','fax','VT2','BE',' ',' ','Auditorio Euskalduna B.O.S.',' ',1,'KK',1,' ',1,0,1,1,1,2164,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',1211,'99','99','R'),('BM','Club Baloncesto Málaga','Málaga    ','Paseo Del Palacio ','Málaga','Málaga','XXXXX','tel1','tel2','fax','UCJ','BM',' ',' ','Palacio de Deportes de Málaga',' ',1,'HH',1,' ',1,0,1,1,1,8511,4,0,3,'996','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0','',NULL,'99','99','R'),('BR','Breton','Breton    ','dir','pob','pro','cp','t1','t2','f','ICS',' ',' ',' ','Breton',' ',0,'AA',0,' ',0,0,1,1,1,988,4,0,3,'999','S','N','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'0005','0','0',NULL,NULL,'99','99','R'),('BS','Teatro Social','SOCIAL    ','Dirección','Población','Provincia','XXXXX','tel1','tel2','fax','BBK','BS',' ',' ','Teatro Social',' ',0,'BB',1,' ',0,0,1,1,1,756,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,620,'99','99','R'),('BT','Teatro Euskalduna B.O.S.','TEATRO    ','AVDA.ABANDOIBARRA, 4','BILBAO','VIZCAYA','48011','944035000','','','BBK','BT',' ',' ','Teatro Euskalduna',' ',0,'BB',1,' ',1,0,1,1,1,613,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,1211,'99','99','R'),('C1','CAPITOL 1','CAPITOL1  ','C/VILLARÍAS, 10','BILBAO','VIZCAYA','48001','944232752','','','BBK','C1',' ',' ','CAPITOL 1',' ',0,'II',1,' ',0,0,1,1,1,739,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,92,'99','99','R'),('C2','CAPITOL 2','CAPITOL2  ','dir','pob','pro','cp','t1','t2','f','BBK','C2',' ',' ','CAPITOL 2',' ',0,'II',1,' ',0,0,1,1,1,217,4,1,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,92,'99','99','R'),('C3','CAPITOL 3','CAPITOL3  ','dir','pob','pro','CP','t1','t2','f','BBK',' ',' ',' ','CAPITOL 3',' ',0,'EE',1,' ',0,0,1,1,1,217,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0','',92,'99','99','R'),('C4','CAPITOL 4','CAPITOL4  ','dir','pob','pro','cp','t1','t2','f','BBK','C4',' ',' ','CAPITOL 4',' ',0,'II',1,' ',0,0,1,1,1,217,4,1,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,92,'99','99','R'),('C9','Centro Cultural de la CICA','CICA      ','Dir.','Las Palmas','Las Palmas',' ',' ',' ',' ','ICS','C9',' ',' ','Centro Cultural de la CICA',' ',0,'AA',0,' ',0,0,1,1,1,383,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'R'),('CB','Centro Insular de Deportes','DEPORTES  ','Jose Alcalde Ramirez Bethencourt, s/n','Las Palmas Gran Canaria','Provincia','35003','tel1','87652194-U','fax','ICS',' ',' ',' ','Centro Insular de Deportes',' ',0,'AA',0,' ',0,0,1,1,1,5955,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','1','0','',0,'99','99','R'),('CC','GRAN CIRCO NACIONAL CHINO','G.C. CHINO','Dirección','Población','Provincia','XXXXX','tel1','444555666','fax','ICS',' ',' ',' ','GRAN CIRCO NACIONAL CHINO',' ',0,'FF',1,' ',1,0,1,1,1,1432,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',0,'99','99','R'),('CD','Alfredo Kraus (Sala de Cámara)','MOZART    ','PSO.DE LAS CANTERAS, S/N','LAS PALMAS','LAS PALMAS','35010','928491770','','','CIC','CD',' ',' ','Alfredo Kraus (Sala de Cámara)',' ',0,'DD',1,' ',0,0,1,1,1,326,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('CE','3 Zonas 50000 localidades (Insular)','GENERICO  ','dir','pob','pro','CP','t1','t2','f','CIC','CE',' ',' ','3 Zonas 50000 localidades (Insular)',' ',0,'AA',1,' ',0,0,0,0,0,50000,4,0,3,'999','S','N','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('CF','Teatro Victor Jara','V. Jara   ','San Antonio 24','Las Palmas','Gran Canaria',' ',' ','14257486Y',' ','ICS','CF',' ',' ','TEATRO VICTOR JARA',' ',1,'AA',1,' ',1,0,1,1,1,1000,4,0,3,'002','S','R','T','E','99',8,7,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',NULL,'99','99','R'),('CG','TEATRO CUYÁS (Nuevo)','CUYÁS     ','dir','Las Palmas','Las Palmas','CP','t1','t2','f','ICS','CG',' ',' ','TEATRO CUYÁS (Nuevo)',' ',0,'AA',0,' ',0,0,1,1,1,943,4,0,3,'001','S','R','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2052',NULL,'0','',NULL,NULL,NULL,'R'),('CI','San Fernando de Maspalomas','SANFER    ','dir','Las Palmas','Las Palmas','CP','t1','t2','f','CIC','CI',' ',' ','San Fernando de Maspalomas',' ',0,'AA',1,' ',0,0,1,1,1,7818,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('CJ','Recinto generico Caja Insular','GENER     ','dir','Las Palmas','Las Palmas','CP','t1','t2','f','CIC','CJ',' ',' ','Recinto generico Caja Insular',' ',0,'AA',1,' ',0,0,0,0,1,35,4,1,3,'999','S','N','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('CM','Auditorio Casa municipal de Cultura','A.C.M.C   ','Dirección','Población','Provincia','xxxxx','TEL1','TEL2','fax','ICS','CM',' ',' ','Auditorio Casa municipal de Cultura',' ',0,'BB',1,' ',1,0,1,1,1,714,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,NULL,NULL,NULL,NULL,'99','R'),('CO','GRAN TEATRO DE CÓRDOBA','GRANTEATRO','dir','Córdoba','Córdoba','cp','t1','t2','f','ICS','CO',' ',' ','GRAN TEATRO DE CÓRDOBA',' ',0,'AA',0,' ',0,0,1,1,1,1461,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0',NULL,NULL,NULL,NULL,'99','R'),('CR','Recinto sin numerar CR','          ','dir','pob','pro','CP','t1','t2','f','CJR','CR',' ',' ','Recinto sin numerar CR',' ',0,'AA',1,' ',0,0,0,0,1,50000,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('D1','CINES ANTIGUO BERRI SALA 1','BERRI 1   ','dir','pob','pro','cp','t1','t2','f','ICS',' ',' ',' ','CINES ANTIGUO BERRI',' ',0,'II',1,' ',1,0,1,1,1,99,4,1,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','565110',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2101','0','0','',0,'99','99','R'),('D2','CINES ANTIGUO BERRI SALA 2','BERRI 2   ','dir','pob','pro','cp','t1','t2','f','ICS',' ',' ',' ','CINES ANTIGUO BERRI',' ',0,'II',1,' ',1,0,1,1,1,135,4,1,3,'999','S',' ',' ',' ','99',2,8,' ',' ',' ','565120',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2101','0','0','',0,'99','99','R'),('D3','CINES ANTIGUO BERRI SALA 3','BERRI 3   ','dir','pob','pro','cp','t1','t2','f','ICS',' ',' ',' ','CINES ANTIGUO BERRI',' ',0,'II',1,' ',1,0,1,1,1,101,4,1,3,'999','S',' ',' ',' ','99',3,8,' ',' ',' ','565130',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2101','0','0','',0,'99','99','R'),('D4','CINES ANTIGUO BERRI SALA 4','BERRI 4   ','dir','pob','pro','cp','t1','t2','f','ICS',' ',' ',' ','CINES ANTIGUO BERRI',' ',0,'II',1,' ',1,0,1,1,1,72,4,1,3,'999','S',' ',' ',' ','99',4,8,' ',' ',' ','565140',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2101','0','0','',0,'99','99','R'),('D5','CINES ANTIGUO BERRI SALA 5','BERRI 5   ','dir','pob','pro','cp','t1','t2','f','ICS',' ',' ',' ','CINES ANTIGUO BERRI',' ',0,'II',1,' ',1,0,1,1,1,64,4,1,3,'999','S',' ',' ',' ','99',5,8,' ',' ',' ','565150',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2101','0','0','',0,'99','99','R'),('D6','CINES ANTIGUO BERRI SALA 6','BERRI 6   ','dir','pob','pro','cp','t1','t2','f','ICS',' ',' ',' ','CINES ANTIGUO BERRI',' ',0,'II',1,' ',1,0,1,1,1,100,4,1,3,'999','S',' ',' ',' ','99',6,8,' ',' ',' ','565160',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2101','0','0','',0,'99','99','R'),('D7','CINES ANTIGUO BERRI SALA 7','BERRI 7   ','dir','pob','pro','cp','t1','t2','f','ICS',' ',' ',' ','CINES ANTIGUO BERRI',' ',0,'II',1,' ',1,0,1,1,1,58,4,1,3,'999','S',' ',' ',' ','99',7,8,' ',' ',' ','565170',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2101','0','0','',0,'99','99','R'),('D8','CINES ANTIGUO BERRI SALA 8','BERRI 8   ','dir','pob','pro','cp','t1','t2','f','ICS',' ',' ',' ','CINES ANTIGUO BERRI',' ',0,'II',1,' ',1,0,1,1,1,75,4,1,3,'999','S',' ',' ',' ','99',8,8,' ',' ',' ','565180',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2101','0','0','',0,'99','99','R'),('E1','Cinema Ideal Sala 1','Sala1     ','C/EGAÑA,1','BILBAO','VIZCAYA',' 48010','944210561',' ',' ','BBK','E1',' ',' ','Cinema Ideal Sala 1',' ',0,'II',1,' ',0,0,1,1,1,405,4,0,3,'999','S','R','T','E','99',1,7,' ',' ',' ','502317',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,102,'04','99','R'),('E2','Cinema Ideal Sala 2','Sala2     ','C/EGAÑA,1','BILBAO','VIZCAYA',' 48010','944210561',' ',' ','BBK','E2',' ',' ','Cinema Ideal Sala 2',' ',0,'II',1,' ',0,0,1,1,1,397,4,0,3,'999','S','R','T','E','99',2,7,' ',' ',' ','502321',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,102,'04','99','R'),('E3','Cinema Ideal Sala 3','Sala3     ','C/EGAÑA, 1','BILBAO','VIZCAYA','48010','944210561',' ',' ','BBK','E3',' ',' ','Cinema Ideal Sala 3',' ',0,'II',1,' ',0,0,1,1,1,150,4,0,3,'999','S','R','T','E','99',3,7,' ',' ',' ','502335',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,102,'04','99','R'),('E4','Cinema Ideal Sala 4','Sala4     ','C/EGAÑA,1','BILBAO','VIZCAYA','48010','944210561',' ',' ','BBK','E4',' ',' ','Cinema Ideal Sala 4',' ',0,'II',1,' ',0,0,1,1,1,69,4,0,3,'999','S','R','T','E','99',4,7,' ',' ',' ','502340',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,102,'04','99','R'),('E5','Cinema Ideal Sala 5','Sala5     ','C/EGAÑA,1','BILBAO','VIZCAYA','48010','944210561',' ',' ','BBK','E5',' ',' ','Cinema Ideal Sala 5',' ',0,'II',1,' ',0,0,1,1,1,215,4,0,3,'999','S','R','T','E','99',5,7,' ',' ',' ','502353',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,102,'04','99','R'),('E6','Cinema Ideal Sala 6','Sala6     ','C/EGAÑA,1','BILBAO','VIZCAYA','48010','944210561',' ',' ','BBK','E6',' ',' ','Cinema Ideal Sala 6',' ',0,'II',1,' ',0,0,1,1,1,177,4,0,3,'999','S','R','T','E','99',6,7,' ',' ',' ','502367',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,102,'04','99','R'),('E7','Cinema Ideal Sala 7','Sala7     ','C/EGAÑA, 1','BILBAO','VIZCAYA','48010','944210561',' ',' ','BBK','E7',' ',' ','Cinema Ideal Sala 7',' ',0,'II',1,' ',0,0,1,1,1,149,4,0,3,'999','S','R','T','E','99',7,7,' ',' ',' ','502371',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,102,'04','99','R'),('E8','Cinema Ideal Sala 8','Sala8     ','C/EGAÑA, 1','BILBAO','VIZCAYA','48010',' 944210561',' ',' ','BBK','E8',' ',' ','Cinema Ideal Sala 8',' ',0,'II',1,' ',0,0,1,1,1,70,4,0,3,'999','S','R','T','E','99',8,7,' ',' ',' ','502385',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,102,'04','01','R'),('EE','Auditorio Euskalduna - O.S.E.','O.S.E.    ','AVDA.ABANDOIBARRA, 4','BILBAO','VIZCAYA','48011','944035000','','fax','BBK','EE',' ',' ','Auditorio Euskalduna',' ',1,'BB',1,' ',1,0,1,1,1,2164,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,1403,'99','01','R'),('F1','Multicines 8 Sala 1','Sala1     ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK','F1',' ',' ','Multicines 8 Sala 1',' ',0,'II',1,' ',0,0,1,1,1,94,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,101,'99','01','R'),('F2','Multicines 8 Sala 2','Sala2     ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK','F2',' ',' ','Multicines 8 Sala 2',' ',0,'II',1,' ',0,0,1,1,1,94,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,101,'99','01','R'),('F3','Multicines 8 Sala 3','Sala3     ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK','F3',' ',' ','Multicines 8 Sala 3',' ',0,'II',1,' ',0,0,1,1,1,104,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,101,'99','01','R'),('F4','Multicines 8 Sala 4','Sala4     ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK','F4',' ',' ','Multicines 8 Sala 4',' ',0,'II',1,' ',0,0,1,1,1,104,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,101,'99','01','R'),('F5','Multicines 8 Sala 5','Sala5     ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK','F5',' ',' ','Multicines 8 Sala 5',' ',0,'II',1,' ',0,0,1,1,1,110,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,101,'99','01','R'),('F6','Multicines 8 Sala 6','Sala6     ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK','F6',' ',' ','Multicines 8 Sala 6',' ',0,'II',1,' ',0,0,1,1,1,110,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,101,'99','99','R'),('F7','Multicines 8 Sala 7','Sala7     ','C/JOSE Mª ESCUZA, 13-15','BILBAO','VIZCAYA','48013','944421876',' ',' ','BBK','F7',' ',' ','Multicines 8 Sala 7',' ',0,'II',1,' ',0,0,1,1,1,130,4,0,3,'999','S','R','T','E','99',7,8,' ',' ',' ','502130',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,101,'99','99','R'),('F8','Multicines 8 (Sala 8)','Sala8     ','C/JOSE Mª ESCUZA, 13-15','BILBAO','VIZCAYA','48013','944421876',' ',' ','BBK','F8',' ',' ','Multicines 8 (Sala 8)',' ',0,'II',1,' ',0,0,1,1,1,130,4,0,3,'999','S','R','T','E','99',8,8,' ',' ',' ','502143',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,101,'99','99','R'),('FE','Teatro Euskalduna Sala A3','TEATRO    ','Dirección','Población','Provincia','xxxxx','tel1','tel2','fax','ICS','FE',' ',' ','Teatro Euskalduna Sala A3',' ',0,'BB',1,' ',1,0,1,1,1,548,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',0,'99','99','R'),('FI','Zelaieta Aretoa','          ','Dirección','Población','Provincia','CODPOST','Teléfono 1',' ','Fax','BBK','FI',' ',' ','Zelaieta Aretoa',' ',0,'FF',1,' ',0,0,0,0,0,4000,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ','N','N','00:00','00:00',1,'00:00','0','E   ','48 ',NULL,'2095','0','0',NULL,NULL,'99','99','R'),('FJ','Festival de Jazz de Santander','F. JAZZ   ','dir','pob','pro','CP','t1','t2','f','CCA','FJ',' ',' ','Festival de Jazz de Santander','',0,'CC',1,' ',0,0,0,0,0,1300,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,NULL,'99','99','R'),('FL','TEATRO FLETA','FLETA     ','dir','pob','pro','CP','t1','t2','f','CAI','FL',' ',' ','TEATRO FLETA',' ',0,'BB',1,' ',0,0,1,1,1,1718,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'TE','99','R'),('FU','La FuNdicIOn Aretoa','F.Aretoa  ','Francesc Maciá 1-3','Deusto','Bilbao','','944753327','B48512396','944759115','BBK','FU',' ',' ','La FuNdicIOn Aretoa',' ',0,'BB',1,' ',0,0,0,0,0,90,4,1,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('G1','Arriola Kultur Aretoa','ARRIOLA   ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK','G1',' ',' ','Arriola Kultur Aretoa',' ',0,'II',1,' ',1,0,1,1,1,400,4,1,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','501838',' ',' ','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,81,'99','99','R'),('GA','Auditorio Manuel de Falla','Auditorio ','PSO. DE LOS MÁRTIRES, S/N','Granada','Granada','18009','958222188','        ','           ','OCG','GA',' ',' ','AUDITORIO MANUEL DE FALLA',' ',0,'KK',1,' ',1,0,1,1,1,1303,7,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('GB','Palacio de Exposiciones y Congresos','Congresos ','Granada','Granada','Granada','AS','351 00 03','A-354687-78','','OCG','GB',' ',' ','PALACIO DE EXPOSICIONES Y CONGRESOS',' ',0,'FF',1,' ',1,0,1,1,1,1654,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('GC','Monasterio de San Jerónimo','JERONIMO  ','Dirección','Granada','Granada',' ',' ',' ',' ','OCG','GC',' ',' ','Monasterio de San Jerónimo',' ',0,'FF',1,' ',0,0,0,0,0,1000,0,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('GD','Monasterio de la Concepción','CONCEPCION','********','Granada','Granada','08051 ',' ',' ',' ','OCG','GD',' ',' ','Monasterio de la Concepción',' ',0,'AA',1,' ',0,0,0,0,0,1000,0,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('GE','Teatro Alhambra','ALHAMBRA  ','Dirección','GRANADA','GRANADA',' ',' ',' ',' ','OCG','GE',' ',' ','Teatro Alhambra',' ',0,'BB',1,' ',0,0,1,1,1,296,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('GR','Sala Gabriel Rodó','G.RODO    ','dir','Las Palmas Gran Canaria','pro','CP','t1','t2','f','ICS',' ',' ',' ','Sala Gabriel Rodó',' ',0,'AA',1,' ',0,0,0,0,1,700,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,NULL,NULL,'0','',NULL,NULL,NULL,'R'),('GT','GRAN TEATRO DE CÓRDOBA','TEATRO COR','AVDA.GRAN CAPITÁN','Córdoba','Córdoba','','957480237','38457845-Y','','UCJ','GT',' ',' ','GRAN TEATRO DE CORDOBA',' ',0,'BB',1,' ',0,0,1,1,1,946,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',NULL,'99','99','R'),('H1','Cine Zornotza Aretoa','ZORNOTZA  ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK','H1',' ',' ','Cine Zornotza Aretoa',' ',1,'II',1,' ',1,0,1,1,1,363,4,1,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,96,'99','99','R'),('H2','Heliopuerto','HELIC.    ',' ',' ',' ',' ',' ',' ',' ','ICS','H2',' ',' ','Heliopuerto',' ',1,'AA',1,' ',0,0,1,1,1,12,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('HA','Teatro Zornotza Aretoa','ZORNOTZA  ','C/URBANO LARRUCEA, S/N','AMORREIBIETA','VIZCAYA','48340',' 946300168',' ',' ','BBK','HA',' ',' ','Teatro Zornotza Aretoa',' ',1,'BB',1,' ',1,0,1,1,1,368,4,0,3,'999','S','R','T','E','99',1,7,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,96,'99','99','R'),('I1','Cine Barakaldo Antzoquia','BARAKALDO ','C/ JUAN SEBASTIÁN ELKANO,4','BARAKALDO','VIZCAYA','48901','944780600',' ',' ','BBK','I1',' ',' ',' ',' ',0,'II',1,' ',1,0,1,1,1,697,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','502500',' ',' ','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,90,'99','99','R'),('IB','Teatro Barakaldo','BARAKALDO ','C/JUAN SEBASTIÁN EL KANO, 4','BARAKALDO','VIZCAYA',' 48901','944780600',' ',' ','BBK','IB',' ',' ','Teatro Barakaldo',' ',0,'BB',1,' ',1,0,1,1,1,697,4,0,3,'999','S','R','T','E','99',1,7,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,611,'99','99','R'),('IC','Teatro Isabel la Católica','T.IsabelC ','dir','pob','GRANADA','********','tel1','','fax','OCG','IC',' ',' ','Teatro Isabel la Católica',' ',0,'BB',1,' ',0,0,1,1,1,638,4,0,3,'999','S','N','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,611,'99','99','R'),('J1','Cine Elai-Alai Aretoa','Elai Alai ','C/FORU PLAZA, 4','GERNIKA ','VIZCAYA',' 48300','946250934',' ',' ','BBK','J1',' ',' ','Cine Elai-Alai Aretoa',' ',0,'II',1,' ',0,0,1,1,1,222,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','537940',' ',' ','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('JA','KURSAAL AUDITORIO 2','AUDITORIO ','AVDA. ZURIOLA,1','SAN SEBASTIÁN','GUIPÚZCOA','CP','','','','KTX','JA',' ',' ','KURSAAL AUDITORIO 2',' ',0,'AA',1,' ',1,0,1,1,1,1804,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('JB','SALA DE CAMARA 2','CAMARA    ','dir','pob','pro','CP','t1','t2','f','KTX','JB',' ',' ','SALA DE CAMARA 2',' ',0,'AA',1,' ',1,0,1,1,1,624,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('JC','KURSAAL AUDITORIO','AUDITORIO ','AVDA.DE ZURIOLA,1','SAN SEBASTIÁN ','GUIPÚZCOA','20002','','47253687-G','943000300','KTX','JC',' ',' ','KURSAAL AUDITORIO',' ',0,'AA',1,' ',1,0,1,1,1,1806,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',NULL,'99','99','R'),('JK','Kursaal Jazz Band Ball','Kursaal   ','**********','*********','**************','CP','************','','','KTX','JK',' ',' ','Kursaal Jazz Band Ball',' ',0,'KK',1,' ',0,0,0,0,1,8000,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('K1','Cine Nestor Bosterretxea Aretoa','Nestor    ','C/SAN FRANCISCO, S/N','BERMEO','VIZCAYA',' 48370',' 946188310',' ',' ','BBK','K1',' ',' ','Nestor Bosterretxea Aretoa',' ',0,'II',1,' ',0,0,1,1,1,139,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','536060',' ',' ','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('K2','Salón de Plenos','S.PLENOS  ','*****','*******','********','*********','**********','','','KTX','K2',' ',' ','Salón de Plenos',' ',0,'FF',1,' ',0,0,0,0,1,250,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('K3','Estadio de Anoeta','ESTADIO   ','dir','pob','pro','CP','t1','t2','f','KTX','K3',' ',' ','Estadio de Anoeta',' ',0,'HH',1,' ',0,0,0,0,1,13800,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('K4','Salón de Actos de Kutxa','          ','dir','pob','pro','CP','t1','t2','f','KTX','K4',' ',' ','Salón de Actos de Kutxa',' ',0,'FF',1,' ',0,0,0,0,1,250,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('K5','GAZTESZENA - EGIAKO KULTUR ETXEA','          ','dir','pob','pro','CP','t1','t2','f','KTX','K5',' ',' ','GAZTESZENA - EGIAKO KULTUR ETXEA',' ',0,'FF',1,' ',0,0,0,0,1,500,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('K6','Convento de Sta.Teresa','CONVENTO  ','dir','pob','pro','CP','t1','t2','f','KTX','K6',' ',' ','Convento de Sta.Teresa',' ',0,'FF',1,' ',0,0,0,0,1,500,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('K7','WARNER 10 FIC','          ','dir','pob','pro','CP','t1','t2','f','KTX','K7',' ',' ','WARNER 10 FIC',' ',0,'FF',1,' ',0,0,0,0,1,1000,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('K8','LUGARITZ KULTUR ETXEA','          ','dir','pob','pro','CP','t1','t2','f','KTX','K8',' ',' ','LUGARITZ KULTUR ETXEA',' ',0,'AA',1,' ',0,0,0,0,1,1000,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('K9','Sala Rock Star','Rock Star ','dir','pob','pro','CP','t1','t2','f','KTX','K9',' ',' ','Sala Rock Star',' ',0,'FF',1,' ',0,0,0,0,1,1000,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KA','Polideportivo de Anoeta','POLIDEPORT','dir','pob','pro','CP','t1','t2','f','KTX','KA',' ',' ','Polideportivo de Anoeta',' ',0,'HH',1,' ',0,0,0,0,1,2500,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KC','TEATRO PRINCIPAL','PRINCIPAL ','C/MAYOR,1','SAN SEBASTIÁN','GUIPÚZCOA','20003','943421874','','','KTX','KC',' ',' ','TEATRO PRINCIPAL',' ',0,'BB',1,' ',0,0,0,1,1,550,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KD','PRINCIPE (sala 1)','PRINCIPE  ','C/ALDAMAR,7','SAN SEBASTIÁN','GUIPÚZCOA','CP','943421247','20003','','KTX','KD',' ',' ','PRINCIPE (sala 1)',' ',0,'II',1,' ',0,0,0,1,1,130,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KE','PRINCIPE (sala 2)','PRINCIPE  ','C/ALDAMAR,7','SAN SEBASTIÁN','GUIPÚZCOA','20003','943421247','','','KTX','KE',' ',' ','PRINCIPE (sala 2)',' ',0,'II',1,' ',0,0,0,1,1,290,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KF','PRINCIPE (sala 3)','PRINCIPE  ','C/ALDAMAR, 7','SAN SEBASTIÁN','GUIPÚZCOA','20003','943421247','','','KTX','KF',' ',' ','PRINCIPE (sala 3)',' ',0,'II',1,' ',0,0,0,1,1,190,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KG','PRINCIPE (sala 4)','PRINCIPE  ','C/ALDAMAR, 7','SAN SEBATIÁN','GUIPÚZCOA','20003','943421247','','','KTX','KG',' ',' ','PRINCIPE (sala 4)',' ',0,'II',1,' ',0,0,0,1,1,300,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KH','PRINCIPE (sala 5)','PRINCIPE  ','C/ALDAMAR, 7','SAN SEBASTIÁN','GUIPÚZCOA','20003','943421247','','','KTX','KH',' ',' ','PRINCIPE (sala 5)',' ',0,'II',1,' ',0,0,0,1,1,235,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KI','PRINCIPE (sala 6)','PRINCIPE  ','C/ALDAMAR, 7','SAN SEBASTIÁN','GUIPÚZCOA','20003','943421247','','','KTX','KI',' ',' ','PRINCIPE (sala 6)',' ',0,'II',1,' ',0,0,0,1,1,120,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KJ','ASTORIA (Sala 1)','ASTORIA   ','PZA. PIO XII, 1','SAN SEBASTIÁN','GUIPÚZCOA','','943455506','20010','','KTX','KJ',' ',' ','ASTORIA (Sala 1)',' ',0,'II',1,' ',0,0,1,1,1,460,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KK','ASTORIA (Sala 2)','PRINCIPE  ','PZA.PIO XII,1','SAN SEBASTIÁN','GUIPÚZCOA','20010','943455506','','','KTX','KK',' ',' ','ASTORIA (Sala 2)',' ',0,'II',1,' ',0,0,0,1,1,170,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KL','ASTORIA (Sala 3)','PRINCIPE  ','PZA.PIO XII, 1','SAN SEBASTIÁN ','GUIPÚZCOA','20010','943455506','','','KTX','KL',' ',' ','ASTORIA (Sala 3)',' ',0,'II',1,' ',0,0,0,1,1,600,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,613,'99','99','R'),('KM','ASTORIA (Sala 4)','PRINCIPE  ','PZA.PIO XII,1','SAN SEBASTIÁN','GUIPÚZCOA','20010','943455506','','','KTX','KM',' ',' ','ASTORIA (Sala 4)',' ',0,'II',1,' ',0,0,0,1,1,170,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KN','ASTORIA (Sala 5)','PRINCIPE  ','PZA.PIO XII,1','SAN SEBASTIÁN','GUIPÚZCOA','','943455506','20010','','KTX','KN',' ',' ','ASTORIA (Sala 5)',' ',0,'II',1,' ',0,0,0,1,1,100,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KO','ASTORIA (Sala 6)',' PRINCIPE ','PZA.PIO XII,1','SAN SEBASTIÁN','GUIPÚZCOA','20010','943455506','','','KTX','KO',' ',' ','ASTORIA (Sala 6)',' ',0,'II',1,' ',0,0,0,1,1,250,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KP','ASTORIA (Sala 7)',' PRINCIPE ','PZA.PIO XII, 1','SAN SEBASTIÁN','GUIPÚZCOA','20010','943455506','','','KTX','KP',' ',' ','ASTORIA (Sala 7)',' ',0,'II',1,' ',0,0,0,1,1,110,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KQ','Casino Municipal-Theatre','CASINO    ','AVDA.EDUARD, 7','BIARRITZ','FRANCIA','64200','0033559222021','','','KTX','KQ',' ',' ','Casino Municipal-Theatre',' ',0,'FF',1,' ',1,0,1,1,1,200,4,0,3,'999','S','N','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KR','GARE DU MIDI SALLE ATALAYA','GARE      ','AVDA.FOCH, S/N','BIARRITZ','FRANCIA','64200','0033559222021','','','KTX','KR',' ',' ','GARE DU MIDI SALLE ATALAYA',' ',0,'AA',1,' ',1,0,1,1,1,300,4,0,3,'999','S','N','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KS','Campo fútbol San Roque','SAN ROQUE ','Portugalete',' ','Bizkaia',' ','','','','BBK','KS',' ',' ','Campo fútbol San Roque',' ',0,'KK',1,' ',0,0,0,0,0,47000,15,0,3,'999','S','N','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',NULL,'99','99',' '),('KT','SALA DE CAMARA','CAMARA    ','dir','pob','pro','CP','t1','t2','f','KTX','KT',' ',' ','SALA DE CAMARA',' ',0,'AA',1,' ',1,0,1,1,1,624,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KU','SALA KUTXA','          ','C/ ANDIA','pob','pro','CP','t1','t2','f','KTX','KU',' ',' ','SALA KUTXA',' ',0,'AA',1,' ',0,0,0,0,1,400,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KV','PLAZA DE TOROS VISTA ALEGRE - BILBAO','VELDRÓMO  ','PSO.DE ANOETA, 4','SAN SEBASTIÁN','GUIPÚZCOA','20014','943481850','','','KTX','KV',' ',' ','PLAZA DE TOROS VISTA ALEGRE - BILBAO',' ',0,'HH',1,' ',0,0,1,1,1,21086,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KW','Velódromo de Anoeta BIS','VELÓDROMO ','PSO.DE ANOETA, 4','SAN SEBASTIÁN','GUIPÚZCOA','20014','943481850','','','KTX','KW',' ',' ','Velódromo de Anoeta BIS',' ',0,'HH',1,' ',0,0,0,0,0,20000,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KX','SALA POLIVALENTE','SALA POLIV','Direccion','pob','pro','CP','t1','t2','f','KTX','KX',' ',' ','SALA POLIVALENTE',' ',0,'AA',1,' ',0,0,0,0,1,560,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KY','KURSAAL AUDITORIO','AUDITORIO ','dir','pob','pro','CP','t1','t2','f','KTX','KY',' ',' ','KURSAAL AUDITORIO',' ',0,'AA',1,' ',1,0,1,1,1,1806,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('KZ','Velódromo de Anoeta','VELODROMO ','PSO. DE ANOETA, 4','SAN SEBASTIÁN ','GUIPÚZCOA','20014','943481850','','','KTX','KZ',' ',' ','Velódromo de Anoeta',' ',0,'HH',1,' ',1,0,1,1,1,8323,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('L1','Zinemak Lauren Getxo (SALA1)','LGETXO    ','AVDA.BASGOITI,77','GETXO','VIZCAYA','48990','944607380','A-01234567',' ','BBK','L1',' ',' ','Zinemak Lauren Getxo (SALA1)',' ',0,'II',1,' ',1,0,1,1,1,181,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','502862',' ','S',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,99,'99','99','R'),('L2','Zinemak Lauren Getxo (SALA 2)','LGETXO    ','AVDA.BASAGOITI, 77','GETXO','VIZCAYA',' 48990','944607380','A-01234567',' ','BBK','L2',' ',' ','Zinemak Lauren Getxo (SALA 2)',' ',0,'II',1,' ',1,0,1,1,1,115,4,1,3,'999','S','R','T','E','99',2,7,' ',' ',' ','502862',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,99,'99','99','R'),('L3','Zinemak Lauren Getxo (SALA 3)','LGETXO    ','AVDA.BASAGOITI, 77','GETXO','VIZCAYA','48990',' ','A-01234567',' ','BBK','L3',' ',' ','Zinemak Lauren Getxo (SALA 3)',' ',0,'II',1,' ',1,0,1,1,1,101,4,1,3,'999','S','R','T','E','99',3,7,' ',' ',' ','502862',' ','S',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,99,'99','99','R'),('L4','Zinemak Lauren Getxo (SALA 4)','LGETXO    ','AVDA.BASGOITI, 77','GETXO','VIZCAYA','48990',' 944607380','A-01234567',' ','BBK','L4',' ',' ','Zinemak Lauren Getxo (SALA 4)',' ',0,'II',1,' ',1,0,1,1,1,130,4,1,3,'999','S','R','T','E','99',4,7,' ',' ',' ','502862',' ','S',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,99,'99','99','R'),('L5','Zinemak Lauren Getxo (SALA 5)','LGETXO    ','AVDA.BASAGOITI, 77','GETXO','VIZCAYA',' 48990','944607380','A-01234567',' ','BBK','L5',' ',' ','Zinemak Lauren Getxo (SALA5)',' ',0,'II',1,' ',1,0,1,1,1,76,4,1,3,'999','S','R','T','E','99',5,7,' ',' ',' ','502862',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,99,'99','99','R'),('L6','Zinemak Lauren Getxo (SALA 6)','LGETXO    ','AVDA.BASAGOITI, 77','GETXO','VIZCAYA',' 48990','944607380','A-01234567',' ','BBK','L6',' ',' ','Zinemak Lauren Getxo (SALA 6)',' ',0,'II',1,' ',1,0,1,1,1,108,4,1,3,'999','S','R','T','E','99',6,7,' ',' ',' ','502862',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,99,'99','99','R'),('L7','Zinemak Lauren Getxo (SALA 7)','LGETXO    ','AVDA.BASGOITI, 77','GETXO','VIZCAYA',' 48990','944607380','A-01234567',' ','BBK','L7',' ',' ','Zinemak Lauren Getxo (SALA 7)',' ',0,'II',1,' ',1,0,1,1,1,157,4,1,3,'999','S','R','T','E','99',7,7,' ',' ',' ','502862',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,99,'99','99','R'),('L8','Zinemak Lauren Getxo (SALA 8)','LGETXO    ','AVDA.BASGOITI, 77','GETXO','VIZCAYA','48990',' 944607380','A-01234567',' ','BBK','L8',' ',' ','Zinemak Lauren Getxo (SALA 8)',' ',0,'II',1,' ',1,0,1,1,1,202,4,1,3,'999','S','R','T','E','99',8,7,' ',' ',' ','502862',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,99,'99','99','R'),('L9','Zinemak Lauren Getxo (SALA 9)','LGETXO    ','AVDA.BASAGOITI, 77','GETXO','VIZCAYA',' 48990','944607380','A-01234567',' ','BBK','L9',' ',' ','Zinemak Lauren Getxo (SALA 9)',' ',0,'II',1,' ',1,0,1,1,1,261,4,1,3,'999','S','R','T','E','99',9,7,' ',' ',' ','502862',' ','S',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,99,'99','99','R'),('LA','Zinemak Lauren Getxo (SALA 10)','LGETXO    ','AVDA.BASAGOITI, 77','GETXO','VIZCAYA',' 48990','944607380','A-01234567',' ','BBK','LA',' ',' ','Zinemak Lauren Getxo (SALA10)',' ',0,'II',1,' ',1,0,1,1,1,341,4,1,3,'999','S','R','T','E','99',10,7,' ',' ',' ','502862',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,99,'99','99','R'),('LB','Zinemak Lauren Getxo (SALA 11)','LGETXO    ','AVDA. BASAGIOTI, 77','GETXO','VIZCAYA',' 48990','944607380','A-01234567',' ','BBK','LB',' ',' ','Zinemak Lauren Getxo (SALA11)',' ',0,'II',1,' ',1,0,1,1,1,219,4,1,3,'999','S','R','T','E','99',11,7,' ',' ',' ','502862',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,99,'99','99','R'),('LC','Zinemak Lauren Getxo (SALA 12)','LGETXO    ','AVDA.BASAGOITI,77','GETXO ','VIZCAYA',' 48990','944607380','A-01234567',' ','BBK','LC',' ',' ','Zinemak Lauren Getxo (SALA12)',' ',0,'II',1,' ',1,0,1,1,1,220,4,1,3,'999','S','R','T','E','99',12,7,' ',' ',' ','502862',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,99,'99','99','R'),('LO','Lombo Aretoa','L. Aretoa ','dir','pob','pro','CP','tel1','tel2','fax','BBK','LO',' ',' ','Lombo Aretoa',' ',0,'BB',1,' ',0,0,1,1,1,229,4,0,3,'999','S','N','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,1593,'99','99','R'),('LV','Teatro Lope de Vega','Teatro    ',' ','SEVILLA','pro',' ','telf','45781245-J',' ','ICS',' ',' ',' ','Teatro Lope de Vega',' ',0,'BB',1,' ',1,0,1,1,1,1858,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,NULL,'0','0','',NULL,NULL,NULL,'R'),('M0','Teatro Real','REAL      ','Plaza de Isabel II, s/n','Madrid','Madrid','28013','(91)516 06 00','45783698','(91)516 06 51','CDM','M0',' ',' ','Teatro Real',' ',1,'BB',1,' ',0,0,1,1,1,1860,4,0,3,'999','S','R','T','E','01',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',NULL,'22','99','R'),('M1','Cines Mikeldi Sala 1','Sala1     ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK','M1',' ',' ','Cines Mikeldi Sala 1',' ',0,'II',1,' ',0,0,1,1,1,583,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,NULL,'99','99','R'),('M2','Cines Mikeldi Sala 2','Sala2     ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK','M2',' ',' ','Cines Mikeldi Sala 2',' ',0,'II',1,' ',0,0,1,1,1,296,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,NULL,'99','99','R'),('M3','Cines Mikeldi Sala 3','Sala3     ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK','M3',' ',' ','Cines Mikeldi Sala 3',' ',0,'II',1,' ',0,0,1,1,1,124,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,NULL,'99','99','R'),('M4','Cines Mikeldi Sala 4','Sala4     ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK','M4',' ',' ','Cines Mikeldi Sala 4',' ',0,'II',1,' ',0,0,1,1,1,300,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,NULL,'99','99','R'),('MA','Maestranza','Maestranza','dir','pob','pro','cp','t1','t2','f','ICS',' ',' ',' ','Maestranza',' ',0,'AA',0,' ',0,0,1,1,1,1000,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',0,'99','99',NULL),('MB','Museo de Bellas Artes Bilbao','BELLAS ART','PLAZA DEL MUSEO,2','BILBAO','VIZCAYA','48011','944396134',' ','','BBK','MB',' ',' ','Museo de Bellas Artes Bilbao',' ',0,'GG',1,' ',0,0,0,1,0,2000,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ','N','N','00:00','00:00',1,'00:00','0','E   ','48 ',NULL,'2095','0','0',NULL,NULL,'99','99','R'),('MG','Guggenheim Bilbao Museoa','Guggenheim','AVDA.ABANDOIBARRA, 2','BILBAO','VIZCAYA','48001','944359000',' ','','BBK','MG',' ',' ','Guggenheim Bilbao Museoa',' ',0,'GG',1,' ',0,0,0,0,0,5000,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ','N','N','00:00','00:00',1,'00:00','0','E   ','48 ',NULL,'2095','0','0','',NULL,'04','99','R'),('MZ','Recinto Test','          ','Dirección','Población','Provincia','CODPOST','Teléfono 1',' ','Fax','BBK','MZ',' ',' ','Descripción',' ',0,'GG',1,' ',0,0,1,0,0,2000,4,1,3,'996','S','R','T','E','99',1,8,' ',' ',' ',' ',' ','N','N','00:00','00:00',1,'00:00','0','E   ','48 ',NULL,'2095','0','0','',NULL,'99','99','R'),('N1','Cine Mungia','MUNGIA    ','dir','pob','pro','CP','tel1','tel2','fax','BBK','N1',' ',' ','Cine Mungia',' ',0,'II',1,' ',0,0,0,1,1,122,4,0,3,'999','S','N','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('NY','Recinto No Numerado 1 (50.000) BBK','          ','Dirección','Población','Provincia','CODPOST','Teléfono 1',' ','Fax','BBK','NY',' ',' ','Recinto No Numerado 1 (50.000) BBK',' ',0,'FF',1,' ',0,0,0,0,0,50000,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ','N','N','00:00','00:00',1,'00:00','0','E   ','48 ',NULL,'2095','0','0',NULL,NULL,'99','99','R'),('NZ','Recinto No Numerado 2 (10.000) BBK','          ','Dirección','Población','Provincia','CODPOST','Teléfono 1',' ','Fax','BBK','NZ',' ',' ','Recinto No Numerado 2 (10.000) BBK',' ',0,'FF',1,' ',0,0,0,0,0,10000,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ','N','N','00:00','00:00',1,'00:00','0','E   ','48 ',NULL,'2095','0','0',NULL,613,'99','99','R'),('P1','TEATRO PRINCIPAL','PRINCIPAL ','dir','pob','pro','cp','t1','t2','f','KTX','P1',' ',' ','TEATRO PRINCIPAL',' ',0,'AA',1,' ',0,0,1,1,1,576,4,1,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,98,'99','99','R'),('PA','AUDITORIO DE LA RIOJA','AUDITORIO ','Dirección','Población','Provincia','xxxxx','tel1','tel2','fax','ICS',' ',' ',' ','AUDITORIO DE LA RIOJA',' ',0,'FF',1,' ',1,0,1,1,1,1223,4,0,3,'999','S','R',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',0,'99','99','R'),('PC','PALACIO DE CONGRESOS DE LA RIOJA','PCONGRESOS','Dirección','Población','Provincia','CP','tel1','tel2','fax','ICS',' ',' ',' ','PALACIO DE CONGRESOS DE LA RIOJA',' ',0,'FF',1,' ',1,0,1,1,1,418,4,0,3,'999','S','N','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2037','0','0','',0,'99','99','R'),('PF','PABELLON PRINCIPE FELIPE','PR. FELIPE','Avenida Cesareo Alierta','Zaragoza','pro','CP','t1','t2','f','ICS','PF',' ',' ','PABELLON PRINCIPE FELIPE',' ',0,'AA',1,' ',1,0,1,1,1,10667,4,0,3,'002','S','R','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2086',NULL,'0','',98,NULL,NULL,'R'),('PG','Plaza de Toros de Granada','Plza toros','Dirección','Población','Provincia','xxxxx','TEL1','TEL2','fax','ICS','PG',' ',' ','Plaza de Toros de Granada',' ',0,'AA',1,' ',1,0,1,1,1,2376,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,98,'99','99','R'),('PH','Pabellón de Huesca','HUESCA    ','Dirección','Población','Provincia','xxxxx','tel1','tel2','fax','CAI',' ',' ',' ','Pabellón de Huesca',' ',0,'AA',1,' ',1,0,0,0,1,4908,4,0,3,'999','S','R',' ',' ','99',1,8,' ',' ',' ',' ',' ','N','N','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2086','0','0','',0,'99','99','R'),('PI','PABELLON INSULAR DE TENERIFE','P. INSULAR','C/ Mercedes s/n','Santa Cruz de Tenerfie','Tenerife','38108','t1','45725686-B','f','ICS','PI',' ',' ','PABELLON INSULAR DE TENERIFE',' ',0,'AA',1,' ',1,0,1,1,1,5852,4,0,3,'001','S','R','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,NULL,'0','0','',NULL,'99','99','R'),('PN','Pab. Príncipe Felipe sin num.','Pr. Felipe','Dirección','Población','Provincia','CodPost','Teléfono 1',' ','Fax','ICS',' ',' ',' ','Pabellón Príncipe Felipe',' ',0,'AA',1,' ',0,0,0,0,0,10667,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ',' ',' ','N','N','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2086','0','0','',0,'99','99','R'),('PP','PRINCIPE FELIPE (PISTA)','PISTA     ','dir','pob','pro','cp','t1','t2','f','CAI','PP',' ',' ','PRINCIPE FELIPE (PISTA)',' ',0,'AA',1,' ',0,0,1,0,1,320,4,1,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2086',NULL,NULL,NULL,NULL,NULL,NULL,'R'),('PQ','PRINCIPE FELIPE (ESCENARIO)','ESCENARIO ','dir','pob','pro','cp','t1','t2','f','CAI','PQ',' ',' ','PRINCIPE FELIPE (ESCENARIO)',' ',0,'AA',1,' ',0,0,1,0,1,1284,4,1,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,NULL,'0','0',NULL,NULL,'99','99','R'),('PS','Palacio Deportes Santander','P.Dep.    ','Dirección','Población','Provincia','xxxxx','tel1','tel2','fax','ICS','PS',' ',' ','Palacio Deportes Santander',' ',0,'AA',1,' ',1,0,1,1,1,5876,4,0,3,'001','S',' ',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',0,'99','99','R'),('PV','Teatro Palacio Valdés','P.VALDÉS  ','Dirección','Población','Provincia','xxxxx','TEL1','TEL2','fax','ICS','PV',' ',' ','Teatro Palacio Valdés',' ',0,'AA',1,' ',1,0,1,1,1,747,4,0,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,NULL,'99','99','R'),('R1','Cine Zugaza','ZUGAZA    ','Durango','Durango','Provincia',' ',' ',' ',' ','BBK',' ',' ',' ','Cine Zugaza',' ',0,'II',1,' ',1,0,1,1,1,408,4,1,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','0123456',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,NULL,NULL,NULL,NULL,NULL,NULL),('RA','MARC ANTHONY','ANTHONY   ','Avenida de La Feria, s/n','Las Palmas Gran Canaria','Gran Canaria','xxxxx','tel1','tel2','fax','CIC',' ',' ',' ','MARC ANTHONY',' ',0,'FF',1,' ',0,0,0,0,0,30000,4,1,3,'999','S','R',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2052','0','0','',0,'99','99','R'),('RE','Sala Romero Esteo','ROMESTEO  ','dir','pob','pro','cp','t1','t2','f','ICS','RE',' ',' ','Sala Romero Esteo',' ',0,'AA',1,' ',0,0,1,1,1,472,4,1,3,'999','S',' ',' ',' ','99',1,7,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,NULL,'99','99','R'),('S1','SERANTES (Sala 1)','SERANTES1 ','dir','pob','pro','CP','t1','t2','f','BBK','S1',' ',' ','SERANTES (Sala 1)',' ',0,'II',1,' ',0,0,1,1,1,665,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,103,'99','99','R'),('S2','SERANTES (Sala 2)','SERANTES2 ','dir','pob','pro','CP','t1','t2','f','BBK','S2',' ',' ','SERANTES (Sala 2)',' ',0,'II',1,' ',0,0,1,1,1,194,4,1,3,'999','S','R','T','E','99',2,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,103,'99','99','R'),('S3','SERANTES (Sala 3)','SERANTES3 ','dir','pob','pro','CP','t1','t2','f','BBK','S3',' ',' ','SERANTES (Sala 3)',' ',0,'II',1,' ',0,0,1,1,1,190,4,1,3,'999','S','R','T','E','99',3,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,103,'99','99','R'),('SC','SALA ROMERO ESTEO','Sala Danza','Málaga','Málaga','Málaga','cp','952','952','952','ICS',' ',' ',' ','SALA ROMERO ESTEO',' ',1,'AA',1,' ',1,0,1,1,1,264,4,0,3,'999','S','R',' ',' ','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2103',NULL,NULL,NULL,NULL,NULL,NULL,NULL),('SE','Auditório da Fundaçâo Serralves','AUDITORIO ','Rua de Serralves','OPORTO','OPORTO','20125',' ','457845125-L',' ','ICS',' ',' ',' ','Auditório da Fundaçâo Serralves',' ',0,'AA',0,' ',0,0,1,1,1,262,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',0,'99','99','R'),('SK','Remontes Esqui','          ','Dirección','Población','Provincia','CODPOST','Teléfono 1',' ','Fax','BBK','SK',' ',' ','Remontes Esqui',' ',0,'FF',1,' ',0,0,0,0,0,4000,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ','N','N','00:00','00:00',1,'00:00','0','E   ','48 ',NULL,'2095','0','0',NULL,NULL,'99','99','R'),('SM','ESTADIO SAN MAMES','SAM MAMES ','Ibaigane, Alameda Mazarredo 23','BILBAO','BILBAO','48009','944240877','45786936-K','fax','ICS','SM','SM','','SAN MAMES','',1,'FF',1,'',0,0,1,0,0,38456,4,0,3,'999','S','N','T','E','99',1,8,' ','','','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0','',NULL,'99','99','R'),('T1','CINE TRUEBA 1','TRUEBA 1  ','dir','pob','pro','cp','W1','t2','f','ICS','T1',' ',' ','CINE TRUEBA 1',' ',0,'II',1,' ',1,0,1,1,1,221,4,1,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','000000',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,95,'99','99','R'),('T2','CINE TRUEBA 2','TRUEBA 2  ','dir','pob','pro','cp','W1','t2','f','ICS','T2',' ',' ','CINE TRUEBA 2',' ',0,'II',1,' ',1,0,1,1,1,131,4,1,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','000000',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('TC','Teatro Cervantes','TEATRO    ','Dirección','Población','Provincia','XXXXX','tel1','A-1234567890123','fax','ICS','TC',' ',' ','Teatro Cervantes',' ',0,'AA',1,' ',1,0,1,1,1,472,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',0,'99','99','R'),('TE','Teatro Euskalduna','EUSKALDUN ','AVDA.ABANDOIBARRA, 4','BILBAO','VIZCAYA','48011','944035000','','','BBK','TE',' ',' ','Teatro Euskalduna',' ',0,'BB',1,' ',1,0,1,1,1,613,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,613,'99','99','R'),('TM','Teatre Principal de Maó','MAO       ','dir','pob','pro','07001','telf','45674558-Y',' ','BBK','TM',' ',' ','Teatre Principal de Maó',' ',0,'BB',1,' ',0,0,1,1,1,847,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',NULL,'99','99','R'),('TO','Teatro Torrezabal','TORREZABAL','PSO.LENHANDAKARI AGUIRRE, S/N','GALDAKAO','VIZCAYA','48960','944560500','','','BBK','TO',' ',' ','Teatro Torrezabal',' ',0,'BB',1,' ',0,0,1,1,1,416,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,95,'99','99','R'),('TP','Teatro Principal de Zaragoza','Principal ','Calle del COSO','Candasnos','Zaragaroza',' ','telf','12515485Y',' ','ICS','TP',' ',' ','TREATRO PRINCIPAL',' ',0,'BB',1,' ',1,0,1,1,1,1112,4,0,3,'001','S','R','T','E','99',1,8,'50201',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',NULL,'99','99','R'),('U1','Cines Renoir Deusto Sala 1','Renoir 1  ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK',' ',' ',' ','Cines Renoir Deusto Sala 1',' ',0,'II',1,' ',1,0,1,1,1,78,8,1,3,'999','S','N','T','E','99',1,7,'48',' ',' ','502246','C','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',0,'99','99','R'),('U2','Cines Renoir Deusto Sala 2','Renoir 2  ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK',' ',' ',' ','Cines Renoir Deusto Sala 2',' ',0,'II',1,' ',1,0,1,1,1,160,4,1,3,'999','S','N','T','E','99',1,8,'48',' ',' ','502250','C','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',0,'99','99','R'),('U3','Cines Renoir Deusto Sala 3','Renoir 3  ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK',' ',' ',' ','Cines Renoir Deusto Sala 3',' ',0,'II',1,' ',1,0,1,1,1,130,4,1,3,'999','S','N','T','E','99',1,8,'48',' ',' ','502264','C','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',0,'99','99','R'),('U4','Cines Renoir Deusto Sala 4','Renoir 4  ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK',' ',' ',' ','Cines Renoir Deusto Sala 4',' ',0,'II',1,' ',1,0,1,1,1,74,4,1,3,'999','S','N','T','E','99',1,8,'48',' ',' ','502278','C','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',0,'99','99','R'),('U5','Cines Renoir Deusto Sala 5','Renoir 5  ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK',' ',' ',' ','Cines Renoir Deusto Sala 5',' ',0,'II',1,' ',1,0,1,1,1,158,4,1,3,'999','S','N','T','E','99',1,8,'48',' ',' ','502282','C','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',0,'99','99','R'),('U6','Cines Renoir Deusto Sala 6','Renoir 6  ','Dirección','Población','Provincia',' ',' ',' ',' ','BBK',' ',' ',' ','Cines Renoir Deusto Sala 6',' ',0,'II',1,' ',1,0,1,1,1,74,4,1,3,'999','S','N','T','E','99',1,8,'48',' ',' ','502296','C','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',0,'99','99','R'),('UP','Universidad de las Palmas Gran Canaria','UniCICCA  ','Dirección','Población','Provínica','00000','telf1','telf2','fax','CIC','UP',' ',' ','Universidad de las Palmas Gran Canaria',' ',0,'FF',1,' ',1,0,1,1,1,563,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('V1','Cines Avenida SALA 1','Sala 1    ','Dirección','Población','Provincia','XXXXX','TEL1','TEL2','fax','ALB','V1',' ',' ','Cines Avenida',' ',0,'II',1,' ',1,1,1,1,1,87,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','502246',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0','',97,'99','99','R'),('V2','Cines Avenida  SALA 2','Sala 2    ','Dirección','Población','Provincia','XXXXX','TEL1','TEL2','fax','BBK','V2',' ',' ','Cines Avenida',' ',0,'II',1,' ',1,1,1,1,1,192,4,0,3,'999','S','R','T','E','99',2,8,' ',' ',' ','502250',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,97,'99','99','R'),('V3','Cines Avenida SALA 3','Sala 3    ','Dirección','Población','Provincia','XXXXX','TEL1','TEL2','fax','BBK','V3',' ',' ','Cines Avenida',' ',0,'II',1,' ',1,1,1,1,1,142,4,0,3,'999','S','R','T','E','99',3,8,' ',' ',' ','502264',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,97,'99','99','R'),('V4','Cines Avenida SALA 4','Sala 4    ','Dirección','Población','Provincia','XXXXX','TEL1','TEL2','fax','BBK','V4',' ',' ','Cines Avenida',' ',0,'II',1,' ',1,1,1,1,1,92,4,0,3,'999','S','R','T','E','99',4,8,' ',' ',' ','502278',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,97,'99','99','R'),('V5','Cines Avenida SALA 5','Sala 5    ','Dirección','Población','Provincia','XXXXX','TEL1','TEL2','fax','BBK','V5',' ',' ','Cines Avenida',' ',0,'II',1,' ',1,1,1,1,1,201,4,0,3,'999','S','R','T','E','99',5,8,' ',' ',' ','502282',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,97,'99','99','R'),('V6','Cines Avenida SALA 6','Sala 6    ','Dirección','Población','Provincia','XXXXX','TEL1','TEL2','fax','BBK','V6',' ',' ','Cines Avenida',' ',0,'II',1,' ',1,1,1,1,1,93,4,0,3,'999','S','R','T','E','99',6,8,' ',' ',' ','502296',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,97,'99','99','R'),('VB','Palau de la Música (Sala B)','PALAU     ','dir','pob','pro','CP','963548246','12378457','f','ICS',' ',' ',' ','Palau de la Música (Sala B)',' ',1,'AA',0,' ',0,0,1,1,1,420,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',0,'99','99','R'),('VG','Fòrum de les Cultures','          ','Direcció','Població','Provincia','CodPost','Telèfon 1',' ','Fax','ICS','VG',' ',' ','Fòrum de les Cultures',' ',0,'GG',1,' ',0,0,0,0,0,49900,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ',' ',' ','N','N','00:00','00:00',1,'00:00','0','E   ','48 ',NULL,'2095','0','0',NULL,NULL,'99','99','R'),('VL','CIRCIUT DE LA COMUNITAT VALENCIANA','CHESTE    ','Nacional III km 21','Cheste','VALENCIA','45255','94258756','95784575-M','f','ICS',' ',' ',' ','CIRCIUT DE LA COMUNITAT VALENCIANA',' ',0,'AA',0,' ',0,0,1,1,1,154738,4,0,3,'001','S','R','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',0,'99','99','R'),('W1','Cine Mungia','Mendibil  ','Av. Iparralde 7','IRUN','pro','CP','W1','t2','f','ICS','W1',' ',' ','Cines Mendibil',' ',0,'AA',0,' ',0,0,1,1,1,163,4,0,3,'999','S','R','T','E','99',1,7,' ',' ',' ','560380',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',94,'99','99','R'),('W2','Cines Mendibil 2','Mendibil  ','Av.Iparralde, 7','IRUN','pro','CP','t1','46468585-L','f','ICS','W2',' ',' ','Cines Mendibil',' ',0,'AA',0,' ',0,0,1,1,1,113,4,0,3,'999','S','R','T','E','99',2,7,' ',' ',' ','560390',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',NULL,'99','99','R'),('W3','Cines Mendibil 3','Mendibil  ','Av.Iparralde, 7','IRUN','pro','cp','t1','t2','f','ICS','W3',' ',' ','Cines Mendibil',' ',0,'AA',0,' ',0,0,1,1,1,249,4,0,3,'999','S',' ',' ',' ','99',3,7,' ',' ',' ','560400',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('W4','Cines Mendibil 4','Mendibil  ','dir','pob','pro','cp','t1','t2','f','ICS','W4',' ',' ','Cines Mendibil 4',' ',0,'AA',0,' ',0,0,1,1,1,270,4,0,3,'999','S',' ',' ',' ','99',4,7,' ',' ',' ','560410',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('W5','Cines Mendibil 5','Mendibil  ','dir','pob','pro','cp','t1','t2','f','ICS','W5',' ',' ','Cines Mendibil 5',' ',0,'AA',0,' ',0,0,1,1,1,127,4,0,3,'999','S',' ',' ',' ','99',5,7,' ',' ',' ','560420',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('W6','Cines Mendibil 6','Mendibil  ','dir','pob','pro','cp','t1','t2','f','ICS','W6',' ',' ','Cines Mendibil 6',' ',0,'AA',0,' ',0,0,1,1,1,127,4,0,3,'999','S',' ',' ',' ','99',6,7,' ',' ',' ','560430',' ','S','S','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('X1','T/C Getxo Antxokia','GETXO     ','C/URGULL, S/N','ALGORTA','VIZACAYA','48990','944914080','','','BBK','X1',' ',' ','T/C Getxo Antxokia',' ',0,'BB',1,' ',1,0,1,1,1,489,4,0,3,'999','S','R','T','E','99',1,8,' ',' ',' ','123456',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095',NULL,'0',NULL,1597,'99','99','R'),('XA','Plaza Trinidad Getxo','TRINIDAD  ','dir','pob','pro','CP','t1','t2','f','BBK','XA',' ',' ','Plaza Trinidad Getxo',' ',0,'FF',1,' ',0,0,0,0,1,2000,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('XB','Sin Numerar Getxo','GETXO     ','dir','pob','pro','CP','t1','t2','f','BBK','XB',' ',' ','Sin Numerar Getxo',' ',0,'FF',1,' ',0,0,0,0,1,2000,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('Y1','Cine Ayala','C.Ayala   ','C/MANUEL ALLENDE, 18','BILBAO','VIZCAYA','48010','944104454','','','BBK','Y1',' ',' ','Cine Ayala',' ',0,'II',1,' ',0,0,1,1,1,924,4,0,3,'999','S','N','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,1592,'99','99','R'),('YA','Teatro Ayala','T.Ayala   ','C/MANUEL ALLENDE,18','BILBAO','VIZCAYA','48010','944104454','','fax','BBK','YA',' ',' ','Teatro Ayala',' ',0,'BB',1,' ',0,0,1,1,1,924,4,0,3,'999','S','N','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,1592,'25','99','R'),('YY','Museo Test YY','          ','Dirección','Población','Provincia','CODPOST','Teléfono 1',' ','Fax','BBK','YY',' ',' ','Descripción',' ',0,'GG',1,' ',0,0,1,0,0,2472,4,1,3,'999','S','R','U','E','99',1,8,' ',' ',' ',' ',' ','N','N','00:00','00:00',1,'00:00','0','E   ','48 ',NULL,'2095','0','0','',NULL,'99','99','R'),('Z1','Recinto de cines para pruebas','prueba    ','dir','pob','pro','cp','t1','t2','f','CAI',' ',' ',' ','Recinto de cines para pruebas',' ',0,'II',1,' ',0,0,1,0,1,200,4,1,3,'999','S',' ',' ',' ','99',1,8,' ',' ',' ','999999',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2086',NULL,NULL,NULL,NULL,NULL,NULL,'R'),('ZA','Recinto 1 Sin Numerar','          ','dir','pob','pro','CP','t1','t2','f','CAI','ZA',' ',' ','Recinto 1 Sin Numerar',' ',0,'GG',1,' ',0,0,1,0,1,15000,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'TE','99','R'),('ZB','Recinto 2 Sin Numerar','          ','dir','pob','pro','CP','t1','t2','f','CAI','ZB',' ',' ','Recinto 2 Sin Numerar',' ',0,'FF',1,' ',0,0,1,0,1,50000,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'aa','99','R'),('ZD','Centro Cultural CAI','CULTURAL  ','Paseo Damas, 18','ZARAGOZA','ZARAGOZA',' 50008','------',' ',' ','CAI','ZD',' ',' ','Centro Cultural CAI',' ',0,'FF',1,' ',1,0,1,1,1,408,4,1,3,'999','S','R','T','E','99',1,7,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('ZE','CAI (Recinto sin numerar ZE)','          ','dir','pob','pro','CP','t1','t2','f','CAI','ZE',' ',' ','CAI (Recinto sin numerar ZE)',' ',0,'AA',1,' ',0,0,0,0,1,500,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'aa','99','R'),('ZF','CAI (Recinto sin numerar ZF)','          ','dir','pob','pro','CP','t1','t2','f','CAI','ZF',' ',' ','CAI (Recinto sin numerar ZF)',' ',0,'AA',1,' ',0,0,0,0,1,500,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ','',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0',NULL,NULL,'99','99','R'),('ZY','MUSEO PICASSO EXPOSICIÓN TEMPORAL','TEMPORAL  ','dir','pob','pro','CP','t1','45862147Y','f','ICS','ZY',' ',' ','MUSEO PICASSO EXPOSICIÓN TEMPORAL',' ',0,'AA',1,' ',0,0,0,0,0,500,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',NULL,'99','99','R'),('ZZ','MUSEO PICASSO EXPOSICIÓN PERMANENTE','PERMANENTE','dir','pob','pro','CP','t1','45268745Y','f','ALB','ZZ',' ',' ','MUSEO PICASSO EXPOSICIÓN PERMANENTE',' ',0,'AA',1,' ',0,0,0,0,0,500,4,1,3,'999','S','R','T','E','99',1,8,' ',' ',' ',' ',' ',' ',' ','00:00','00:00',1,'00:00','0',NULL,NULL,NULL,'2095','0','0','',NULL,'99','99','R');
UNLOCK TABLES;
/*!40000 ALTER TABLE `pfrcnto` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;