SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: '--'
SELECT DISTINCT a.id_artista AS iIdArtist , a.artista AS sArtist , e.iIdArtistGuest AS iIdArtistGuest , guest.artista AS sArtistGuest , a.sTypeArtist AS sTypeArtist , a.bImageActive AS bImageActiveArtist , e.id_evento AS iIdEvent , CONCAT( e.dEventDate, ' ', IFNULL( e.dEventTime, '21:00:00' ) ) AS dDateTimeEvent , SUBSTR( IFNULL( e.dEventTime, '' ), 1, 5 ) AS dTimeEvent , SUBSTR( IFNULL( e.dTimeDoors, '' ), 1, 5 ) AS dTimeDoors , e.bSoldOut AS bSoldOutEvent , e.bCancelled AS bCancelled , e.bAvailable AS bAvailable , e.bShowGoogleAdsAdvice AS bShowGoogleAdsAdvice , e.dEventDate AS dDateEvent , e.dEventTime AS dEventTime , e.dEventDateOld AS dOldDateEvent , p.iso3166alpha2 AS sVenueCountryInitials , ciu.iIdCity AS iIdCity , ciu.sCity AS sCity , prv.sProvince AS sProvince , IFNULL( f.iIdFestival, '' ) AS iIdFestival , IFNULL( f.sFestival, '' ) AS sFestival , t.iIdTour AS iIdTour , TRIM( CONCAT( t.sTourName, ' ', IFNULL( t.sTourSuffix, '' ) ) ) AS sTour , t.sTourName AS sTourName , IFNULL( t.sTourSuffix, '' ) AS sTourSuffix , IFNULL( e.dEventDateOld, '0000-00-00' ) AS dDateOldEvent , IFNULL( r.iIdVenue, '' ) AS iIdVenue , CONCAT( r.sVenue , IF( r.sSurname = '', '', IF( r.sSurname IS NULL, '', CONCAT( ' (', r.sSurname, ')' ) ) ) , IF( r.sHall IS NULL, '', CONCAT( ' - ', r.sHall ) ) ) AS sVenue , CONCAT( r.sAddress, ' ', IFNULL( r.sPostalCode, '' ) ) AS sVenueAdress , r.sAddress AS sVenueAddress , r.sMaps AS sVenueMaps , r.sPostalCode AS sVenuePostalCode /* , IF( tick.bLastTickets = '1', IF( tick.bIsPurchased = '1', tick.fOfficialPrice * 2, tick.fOfficialPrice * 1.60 ) , IF( tick.bIsPurchased = '1', tick.fOfficialPrice * 1.70, tick.fOfficialPrice ) ) AS fOfficialPrice */ , tick.fOfficialPrice AS fOfficialPrice , tick.bLastTickets AS bLastTickets , tick.bIsPurchased AS bIsPurchased , tick.bSoldOut AS bSoldOutTickets , IFNULL( e.dDateTimeStartSell, '1970-01-01 00:00:00' ) AS dDateTimeStartSell , IFNULL( e.dDateTimeCreation, '1970-01-01 00:00:00' ) AS dDateTimeCreation FROM VDE__ARTISTS a INNER JOIN VDE__EVENTS e ON e.bActive = '1' AND e.id_artista = a.id_artista LEFT JOIN VDE__ARTISTS guest ON guest.id_artista = e.iIdArtistGuest AND guest.bActive = '1' LEFT JOIN VDE__TOURS t ON t.bActive = '1' AND t.iIdArtist = e.id_artista AND t.iIdTour = e.iIdTour INNER JOIN VDE__CITIES ciu ON ciu.bActive = '1' AND ciu.iIdCity = e.iIdCity INNER JOIN VDE__PROVINCES prv ON prv.bActive = '1' AND prv.iIdProvince = ciu.iIdProvince INNER JOIN VDE__VENUES r ON r.bActive = '1' AND r.iIdCity = ciu.iIdCity AND r.iIdVenue = e.iIdVenue INNER JOIN VDE__COUNTRIES p ON p.bActive = '1' AND ciu.iIdCountry = p.iIdCountry LEFT JOIN VDE__FESTIVALS f ON f.bActive = '1' AND f.iIdFestival = e.iIdFestival LEFT JOIN VDE__TICKETS tick ON ( tick.bActive = '1' ) AND ( tick.iIdEvent = e.id_evento ) AND ( tick.fOfficialPrice != 0 ) AND ( tick.bSoldOut = '0' ) LEFT JOIN VDE__ZONES z ON z.bActive = '1' AND z.iIdZone = tick.iIdZone WHERE ( a.bActive = '1' ) AND ( a.artista = :sArtist ) AND ( ciu.sCity = :sCityEvent ) AND ( e.dEventDate = :sDateEvent ) ORDER BY e.dEventTime ASC, tick.fOfficialPrice ASC LIMIT 1
SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: '--'
SELECT DISTINCT a.id_artista AS iIdArtist , a.artista AS sArtist , e.iIdArtistGuest AS iIdArtistGuest , guest.artista AS sArtistGuest , a.sTypeArtist AS sTypeArtist , a.bImageActive AS bImageActiveArtist , e.id_evento AS iIdEvent , CONCAT( e.dEventDate, ' ', IFNULL( e.dEventTime, '21:00:00' ) ) AS dDateTimeEvent , SUBSTR( IFNULL( e.dEventTime, '' ), 1, 5 ) AS dTimeEvent , SUBSTR( IFNULL( e.dTimeDoors, '' ), 1, 5 ) AS dTimeDoors , e.bSoldOut AS bSoldOutEvent , e.bCancelled AS bCancelled , e.bAvailable AS bAvailable , e.bShowGoogleAdsAdvice AS bShowGoogleAdsAdvice , e.dEventDate AS dDateEvent , e.dEventTime AS dEventTime , e.dEventDateOld AS dOldDateEvent , p.iso3166alpha2 AS sVenueCountryInitials , ciu.iIdCity AS iIdCity , ciu.sCity AS sCity , prv.sProvince AS sProvince , IFNULL( f.iIdFestival, '' ) AS iIdFestival , IFNULL( f.sFestival, '' ) AS sFestival , t.iIdTour AS iIdTour , TRIM( CONCAT( t.sTourName, ' ', IFNULL( t.sTourSuffix, '' ) ) ) AS sTour , t.sTourName AS sTourName , IFNULL( t.sTourSuffix, '' ) AS sTourSuffix , IFNULL( e.dEventDateOld, '0000-00-00' ) AS dDateOldEvent , IFNULL( r.iIdVenue, '' ) AS iIdVenue , CONCAT( r.sVenue , IF( r.sSurname = '', '', IF( r.sSurname IS NULL, '', CONCAT( ' (', r.sSurname, ')' ) ) ) , IF( r.sHall IS NULL, '', CONCAT( ' - ', r.sHall ) ) ) AS sVenue , CONCAT( r.sAddress, ' ', IFNULL( r.sPostalCode, '' ) ) AS sVenueAdress , r.sAddress AS sVenueAddress , r.sMaps AS sVenueMaps , r.sPostalCode AS sVenuePostalCode /* , IF( tick.bLastTickets = '1', IF( tick.bIsPurchased = '1', tick.fOfficialPrice * 2, tick.fOfficialPrice * 1.60 ) , IF( tick.bIsPurchased = '1', tick.fOfficialPrice * 1.70, tick.fOfficialPrice ) ) AS fOfficialPrice */ , tick.fOfficialPrice AS fOfficialPrice , tick.bLastTickets AS bLastTickets , tick.bIsPurchased AS bIsPurchased , tick.bSoldOut AS bSoldOutTickets , IFNULL( e.dDateTimeStartSell, '1970-01-01 00:00:00' ) AS dDateTimeStartSell , IFNULL( e.dDateTimeCreation, '1970-01-01 00:00:00' ) AS dDateTimeCreation FROM VDE__ARTISTS a INNER JOIN VDE__EVENTS e ON e.bActive = '1' AND e.id_artista = a.id_artista LEFT JOIN VDE__ARTISTS guest ON guest.id_artista = e.iIdArtistGuest AND guest.bActive = '1' LEFT JOIN VDE__TOURS t ON t.bActive = '1' AND t.iIdArtist = e.id_artista AND t.iIdTour = e.iIdTour INNER JOIN VDE__CITIES ciu ON ciu.bActive = '1' AND ciu.iIdCity = e.iIdCity INNER JOIN VDE__PROVINCES prv ON prv.bActive = '1' AND prv.iIdProvince = ciu.iIdProvince INNER JOIN VDE__VENUES r ON r.bActive = '1' AND r.iIdCity = ciu.iIdCity AND r.iIdVenue = e.iIdVenue INNER JOIN VDE__COUNTRIES p ON p.bActive = '1' AND ciu.iIdCountry = p.iIdCountry LEFT JOIN VDE__FESTIVALS f ON f.bActive = '1' AND f.iIdFestival = e.iIdFestival LEFT JOIN VDE__TICKETS tick ON ( tick.bActive = '1' ) AND ( tick.iIdEvent = e.id_evento ) AND ( tick.fOfficialPrice != 0 ) AND ( tick.bSoldOut = '0' ) LEFT JOIN VDE__ZONES z ON z.bActive = '1' AND z.iIdZone = tick.iIdZone WHERE ( a.bActive = '1' ) AND ( a.artista = :sArtist ) AND ( ciu.sCity = :sCityEvent ) AND ( e.dEventDateOld = :sDateEvent ) ORDER BY e.dEventTime ASC, tick.fOfficialPrice ASC LIMIT 1