NO SE ENCONTRARON TÍTULOS
0 (Err # 1 )Error Code=-2147467259
Message =Unable to connect to any of the specified MySQL hosts.
Source=
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at YapoMysqlTool.ySQLE.OpenReader() in C:\Users\berna\Documents\onedrive\Documents\personal\Visual Studio 2015\Projects\YapoMysqlTool\Class1.cs:line 904MySql.Data
SQL Command :
SELECT
libro.Id,libro.ideditorial,
libro.Titulo,libro.idpublicaciontipo,
libro.titulo2,
GROUP_CONCAT( DISTINCT CONCAT(autores.Nombre,' ', autores.Apellidos) SEPARATOR '|' ) as nombreautores,
GROUP_CONCAT( DISTINCT autores.id SEPARATOR '|' ) as idautores,editorial.nombre as editorialnombre,
pdf.activo as pdfactivo, pdf.preciodolar as pdfdolar,
pdf.precioeuro as pdfeuro, pdf.paginas as pdfpaginas, pdf.isbn as pdfisbn,
epub.activo as epubactivo, epub.preciodolar as epubdolar,
epub.precioeuro as epubeuro, epub.paginas as epubpaginas, epub.isbn as epubisbn,
iap.activo as iapactivo, iap.preciodolar as iapdolar,
iap.precioeuro as iapeuro, iap.paginas as iappaginas, iap.isbn as iapisbn
FROM
libro
inner JOIN usuario as autores ON autores.ID = libro.idautor
inner JOIN usuario as editorial ON editorial.ID = libro.ideditorial
left join (select * from librodocumento where idtipo=1) as pdf on pdf.idlibro= libro.id
left join (select * from librodocumento where idtipo=4) as epub on epub.idlibro= libro.id
left join (select * from librodocumento where idtipo=100) as iap on iap.idlibro= libro.id
where ((libro.validacion=1) and (libro.Id in (9999999999))) GROUP BY libro.id Order by libro.novedad
Paramerters:
name =?pid , value=0