2405 Connect XXXXXX@localhost on > 2405 Init DB XXXXXX > 2405 Query SELECT SECOND(DATE_ADD(NOW(),INTERVAL > TimeOffSet HOUR)) as seconds, > MINUTE(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > minutes, > HOUR(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as hours, > DAYOFMONTH(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) > as mday, > WEEKDAY(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > wday, > MONTH(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as mon, > YEAR(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as year, > DAYOFYEAR(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR))-1 > as yday, > DAYNAME(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > weekday, > MONTHNAME(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > month, > UNIX_TIMESTAMP() as '0', > Q_SURCHARGE, > TimeOffSet, > DATE_FORMAT(CURDATE(),'%Y%m%d') as Hoje, > MargemCentralAmerica, > MargemSouthAmerica, > SistemaOnline, > DATE_FORMAT(DATE_ADD(PrevisaoRetorno,INTERVAL > TimeOffSet HOUR), '%m/%d/%y - %h:%i %p') AS PrevisaoRetorno > FROM Parametros > 2405 Query SELECT CodigoUsuario, > LOWER(NomeUsuario) as NomeUsuario, > LOWER(NomeLogin) as NomeLogin, > StringAutorizacoes, > SenhaExpirada, > CodigoSuperior, > CodigoDepartamento, > DataNascimento, > DATE_FORMAT(DataUltimoAcesso,'%m/%d/%Y at %H:%i h') as > DataUltimoAcesso, > ContadorAcessos, > CodigoCargo, > LOWER(Email) as Email, > BancoDados, > StatusChat > FROM Usuarios > WHERE SUBSTRING(StringAutorizacoes,1,1)='1' > AND CodigoUsuario='XXXXXXX' > LIMIT 1 > 2405 Query SELECT COUNT(*) as Quantidade > FROM DestinatariosCirculares dc > INNER JOIN Circulares c > ON c.NumeroCircular=dc.NumeroCircular > WHERE (dc.DataLeitura IS NULL > OR dc.DataLeitura='0000-00-00 00:00:00') > AND c.DataCircular HOUR),INTERVAL - 2 DAY) > AND dc.CodigoUsuarioDestinatario=XX > AND c.CodigoStatus=2 > 2405 Query SELECT COUNT(*) as Quantidade > FROM OrdensServicoCPD > WHERE > DataSolicitacao HOUR) > AND CodigoStatus IN (4,5) > AND CodigoUsuarioExecutor=XX > 2405 Query UPDATE Usuarios > SET InicioSessao=DATE_ADD(NOW(),INTERVAL -2 HOUR) > WHERE CodigoUsuario=XX > LIMIT 1 > 2405 Query INSERT INTO RegistroAcessoUsuarios > (CodigoUsuario, > DataUltimoAcesso, > Posicao) > VALUES (14, > DATE_ADD(NOW(),INTERVAL -2 HOUR), > '11') > 2405 Query SELECT COUNT(*) as QuantidadePendentes > FROM PurchasesPendentes pp > WHERE pp.UserIDCreation=14 > AND pp.DeadLine AND pp.DepartureDate>NOW() > 2405 Query START TRANSACTION > 2405 Query SELECT IFNULL(MAX(Sequencia)+1,0) as > Sequencia > FROM PurchasesIncludesTransicao > WHERE PurchaseID=22968 > 2405 Query INSERT INTO PurchasesIncludesTransicao > (PurchaseID, > Sequencia, > IncludeDescription, > Picture, > ServiceTypeID, > OperatorOnly, > SupplierID, > PriceSingle, > PriceDouble, > DaysAfterDepartureDate) > VALUES (22968, > 41, > 'Tour to H. Stern Jewelry Museum', > '', > '2', > '', > '26', > '', > '', > '17') > 2405 Query COMMIT > 2405 Quit 2406 Connect > XXXXXX@localhost on 2406 Init DB XXXXXX > 2406 Query SELECT SECOND(DATE_ADD(NOW(),INTERVAL > TimeOffSet HOUR)) as seconds, > MINUTE(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > minutes, > HOUR(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as hours, > DAYOFMONTH(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) > as mday, > WEEKDAY(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > wday, > MONTH(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as mon, > YEAR(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as year, > DAYOFYEAR(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR))-1 > as yday, > DAYNAME(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > weekday, > MONTHNAME(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > month, > UNIX_TIMESTAMP() as '0', > Q_SURCHARGE, > TimeOffSet, > DATE_FORMAT(CURDATE(),'%Y%m%d') as Hoje, > MargemCentralAmerica, > MargemSouthAmerica, > SistemaOnline, > DATE_FORMAT(DATE_ADD(PrevisaoRetorno,INTERVAL > TimeOffSet HOUR), '%m/%d/%y - %h:%i %p') AS PrevisaoRetorno > FROM Parametros > 2406 Query SELECT CodigoUsuario, > LOWER(NomeUsuario) as NomeUsuario, > LOWER(NomeLogin) as NomeLogin, > StringAutorizacoes, > SenhaExpirada, > CodigoSuperior, > CodigoDepartamento, > DataNascimento, > DATE_FORMAT(DataUltimoAcesso,'%m/%d/%Y at %H:%i h') as > DataUltimoAcesso, > ContadorAcessos, > CodigoCargo, > LOWER(Email) as Email, > BancoDados, > StatusChat > FROM Usuarios > WHERE SUBSTRING(StringAutorizacoes,1,1)='1' > AND CodigoUsuario='0000XX' > LIMIT 1 > 2406 Query SELECT COUNT(*) as Quantidade > FROM DestinatariosCirculares dc > INNER JOIN Circulares c > ON c.NumeroCircular=dc.NumeroCircular > WHERE (dc.DataLeitura IS NULL > OR dc.DataLeitura='0000-00-00 00:00:00') > AND c.DataCircular HOUR),INTERVAL - 2 DAY) > AND dc.CodigoUsuarioDestinatario=XX > AND c.CodigoStatus=2 > 2406 Query SELECT COUNT(*) as Quantidade > FROM OrdensServicoCPD > WHERE > DataSolicitacao HOUR) > AND CodigoStatus IN (4,5) > AND CodigoUsuarioExecutor=XX > 2406 Query UPDATE Usuarios > SET InicioSessao=DATE_ADD(NOW(),INTERVAL -2 HOUR) > WHERE CodigoUsuario=XX > LIMIT 1 > 2406 Query INSERT INTO RegistroAcessoUsuarios > (CodigoUsuario, > DataUltimoAcesso, > Posicao) > VALUES (14, > DATE_ADD(NOW(),INTERVAL -2 HOUR), > '11') > 2406 Query SELECT COUNT(*) as QuantidadePendentes > FROM PurchasesPendentes pp > WHERE pp.UserIDCreation=14 > AND pp.DeadLine AND pp.DepartureDate>NOW() > 2406 Query SELECT s.SupplierName, > s.SupplierID > FROM Suppliers s > ORDER BY s.SupplierName > 2406 Query SELECT * > FROM ServiceTypes > ORDER BY ServiceTypeDescription > 2406 Query SELECT pi.Sequencia, > pi.IncludeDescription, > pi.Picture, > pi.SupplierID, > s.SupplierName, > pi.PriceSingle, > pi.PriceDouble, > pi.DaysAfterDepartureDate, > pi.ServiceTypeID, > IF(pi.OperatorOnly='1','YES','NO') as OperatorOnly > FROM PurchasesIncludesTransicao pi > LEFT JOIN Suppliers s > ON s.SupplierID=pi.SupplierID > WHERE pi.PurchaseID=22968 > ORDER BY pi.DaysAfterDepartureDate, > pi.Sequencia > 2406 Query SELECT h.HotelName, > h.HotelID > FROM Hoteis h > INNER JOIN PurchasesIncludesHoteisTransicao pih > ON pih.HotelID = h.HotelID > WHERE pih.PurchaseID=22968 > AND pih.Sequencia=2 > 2406 Query SELECT h.HotelName, > h.HotelID > FROM Hoteis h > INNER JOIN PurchasesIncludesHoteisTransicao pih > ON pih.HotelID = h.HotelID > WHERE pih.PurchaseID=22968 > AND pih.Sequencia=5 > 2406 Query SELECT h.HotelName, > h.HotelID > FROM Hoteis h > INNER JOIN PurchasesIncludesHoteisTransicao pih > ON pih.HotelID = h.HotelID > WHERE pih.PurchaseID=22968 > AND pih.Sequencia=13 > 2406 Query SELECT h.HotelName, > h.HotelID > FROM Hoteis h > INNER JOIN PurchasesIncludesHoteisTransicao pih > ON pih.HotelID = h.HotelID > WHERE pih.PurchaseID=22968 > AND pih.Sequencia=17 > 2406 Query SELECT h.HotelName, > h.HotelID > FROM Hoteis h > INNER JOIN PurchasesIncludesHoteisTransicao pih > ON pih.HotelID = h.HotelID > WHERE pih.PurchaseID=22968 > AND pih.Sequencia=19 > 2406 Query SELECT h.HotelName, > h.HotelID > FROM Hoteis h > INNER JOIN PurchasesIncludesHoteisTransicao pih > ON pih.HotelID = h.HotelID > WHERE pih.PurchaseID=22968 > AND pih.Sequencia=23 > 2406 Query SELECT h.HotelName, > h.HotelID > FROM Hoteis h > INNER JOIN PurchasesIncludesHoteisTransicao pih > ON pih.HotelID = h.HotelID > WHERE pih.PurchaseID=22968 > AND pih.Sequencia=28 > 2406 Query SELECT h.HotelName, > h.HotelID > FROM Hoteis h > INNER JOIN PurchasesIncludesHoteisTransicao pih > ON pih.HotelID = h.HotelID > WHERE pih.PurchaseID=22968 > AND pih.Sequencia=34 > 2406 Query SELECT h.HotelName, > h.HotelID > FROM Hoteis h > INNER JOIN PurchasesIncludesHoteisTransicao pih > ON pih.HotelID = h.HotelID > WHERE pih.PurchaseID=22968 > AND pih.Sequencia=38 > 2406 Query SELECT p.PackageID, > p.PackageName > FROM Packages p > WHERE p.CodigoStatus=3 > ORDER BY p.PackageName > 2406 Query SELECT SUM(pi.PriceSingle+pi.PriceDouble) > as TotalServices > FROM PurchasesIncludesTransicao pi > WHERE pi.PurchaseID=22968 > 2406 Quit 2407 Connect > XXXXXX@localhost on 2407 Init DB XXXXXX > 2407 Query SELECT SECOND(DATE_ADD(NOW(),INTERVAL > TimeOffSet HOUR)) as seconds, > MINUTE(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > minutes, > HOUR(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as hours, > DAYOFMONTH(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) > as mday, > WEEKDAY(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > wday, > MONTH(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as mon, > YEAR(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as year, > DAYOFYEAR(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR))-1 > as yday, > DAYNAME(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > weekday, > MONTHNAME(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > month, > UNIX_TIMESTAMP() as '0', > Q_SURCHARGE, > TimeOffSet, > DATE_FORMAT(CURDATE(),'%Y%m%d') as Hoje, > MargemCentralAmerica, > MargemSouthAmerica, > SistemaOnline, > DATE_FORMAT(DATE_ADD(PrevisaoRetorno,INTERVAL > TimeOffSet HOUR), '%m/%d/%y - %h:%i %p') AS PrevisaoRetorno > FROM Parametros > 2407 Query SELECT AgencyID, > LCASE(a.Email) as Email, > LoginName, > Sequencia > FROM AgenciesUsers a > WHERE a.Email<>'' > AND a.BlastEmailEnviado='0' > AND a.Inactive='0' > ORDER BY a.AgencyID > LIMIT 1 > 2407 Query SELECT a.Sequencia > FROM AgenciesUsers a > WHERE LCASE(Email)='william@valleytravelgroup.com' > AND a.BlastEmailEnviado='2' > AND a.Inactive='0' > LIMIT 1 > 2407 Query UPDATE AgenciesUsers > SET BlastEmailEnviado='2' > WHERE AgencyID=577 > AND Sequencia=0 > LIMIT 1 > 2407 Quit 2408 Connect > XXXXXX@localhost on 2409 Connect XXXXXX@localhost on > 2408 Init DB XXXXXX > 2409 Init DB XXXXXX > 2408 Query SELECT SECOND(DATE_ADD(NOW(),INTERVAL > TimeOffSet HOUR)) as seconds, > MINUTE(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > minutes, > HOUR(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as hours, > DAYOFMONTH(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) > as mday, > WEEKDAY(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > wday, > MONTH(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as mon, > YEAR(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as year, > DAYOFYEAR(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR))-1 > as yday, > DAYNAME(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > weekday, > MONTHNAME(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > month, > UNIX_TIMESTAMP() as '0', > Q_SURCHARGE, > TimeOffSet, > DATE_FORMAT(CURDATE(),'%Y%m%d') as Hoje, > MargemCentralAmerica, > MargemSouthAmerica, > SistemaOnline, > DATE_FORMAT(DATE_ADD(PrevisaoRetorno,INTERVAL > TimeOffSet HOUR), '%m/%d/%y - %h:%i %p') AS PrevisaoRetorno > FROM Parametros > 2409 Query SELECT SECOND(DATE_ADD(NOW(),INTERVAL > TimeOffSet HOUR)) as seconds, > MINUTE(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > minutes, > HOUR(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as hours, > DAYOFMONTH(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) > as mday, > WEEKDAY(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > wday, > MONTH(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as mon, > YEAR(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as year, > DAYOFYEAR(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR))-1 > as yday, > DAYNAME(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > weekday, > MONTHNAME(DATE_ADD(NOW(),INTERVAL TimeOffSet HOUR)) as > month, > UNIX_TIMESTAMP() as '0', > Q_SURCHARGE, > TimeOffSet, > DATE_FORMAT(CURDATE(),'%Y%m%d') as Hoje, > MargemCentralAmerica, > MargemSouthAmerica, > SistemaOnline, > DATE_FORMAT(DATE_ADD(PrevisaoRetorno,INTERVAL > TimeOffSet HOUR), '%m/%d/%y - %h:%i %p') AS PrevisaoRetorno > FROM Parametros > 2408 Query SELECT TimeOffSet > FROM Parametros > 2408 Query SELECT SQL_CACHE DISTINCT > p.PictureVacationDetails, > p.PackageID, > p.BookOnlineAllowed, > p.PackageName, > p.PriceStartsFrom, > p.MessagePriceStartsFrom, > p.TituloDetails > FROM Packages p > WHERE p.CodigoStatus=3 > AND p.DontShowAtWebSite<>'1' > AND p.PackageID=000149 > 2409 Query SELECT AgencyID, > LCASE(a.Email) as Email, > LoginName, > Sequencia > FROM AgenciesUsers a > WHERE a.Email<>'' > AND a.BlastEmailEnviado='0' > AND a.Inactive='0' > ORDER BY a.AgencyID > LIMIT 1 > 2408 Query SELECT c.CountryName > FROM PackagesCountries cp > LEFT JOIN Countries c > ON c.CountryID=cp.CountryID > WHERE cp.PackageID=000149 > 2409 Query SELECT a.Sequencia > FROM AgenciesUsers a > WHERE LCASE(Email)='danhowelltravel@aol.com' > AND a.BlastEmailEnviado='2' > AND a.Inactive='0' > LIMIT 1 > 2408 Query SELECT SQL_CACHE s.State, > LOWER(c.CityName) as CityName, > pgp.Price > FROM PackagesGateways pg > INNER JOIN PackagesGatewayPrices pgp > ON pg.PackageID=pgp.PackageID > AND pg.Sequencia=pgp.Sequencia > INNER JOIN Airports a > ON a.AirportID=pg.AirportID > INNER JOIN Cities c > ON c.CityID=a.CityID > INNER JOIN States s > ON s.StateID=c.StateID > INNER JOIN Packages p > ON p.PackageID=pg.PackageID > WHERE p.CodigoStatus=3 > AND p.PackageID=000149 > ORDER BY pgp.Price, > c.CityName > 2408 Query SELECT SQL_CACHE p.Description, > p.NumberOfDays, > p.NumberOfNights > FROM Packages p > WHERE p.CodigoStatus=3 > AND p.PackageID=000149 > LIMIT 1 > 2408 Query CREATE TEMPORARY TABLE PackagesTemp > SELECT p.PackageID > FROM Packages p > WHERE p.CodigoStatus=3 > AND p.PackageID=000149 > LIMIT 1 > 2408 Query SELECT SQL_CACHE pi.Sequencia, > pi.IncludeDescription, > pi.ServiceTypeID, > pi.Picture, > pih.HotelID > FROM PackagesIncludes pi > INNER JOIN PackagesTemp p > ON p.PackageID=pi.PackageID > LEFT JOIN PackagesIncludesHoteis pih > ON pih.PackageID=pi.PackageID > AnD pih.Sequencia=pi.Sequencia > WHERE p.PackageID=000149 > AND pi.OperatorOnly<>'1' > ORDER BY pi.DaysAfterDepartureDate, > pi.Sequencia > 2408 Query SELECT h.HotelID > FROM Hoteis h > WHERE h.HotelID=1292 > LIMIT 1 > 2408 Query SELECT SQL_CACHE p.Meals > FROM Packages p > WHERE p.CodigoStatus=3 > AND p.PackageID=000149 > LIMIT 1 > 2408 Query SELECT SQL_CACHE > IF(pdd.Esgotado='1',DATE_FORMAT(pdd.DepartureDate,'%a, > %b %D'),DATE_FORMAT(pdd.DepartureDate,'%a, %b %D')) as > DepartureDate, > IF(pdd.Esgotado='1',' - SOLD OUT!','') as Esgotado, > YEAR(pdd.DepartureDate) as AnoDepartureDate, > IF(pdd.Esgotado='1','',IF(pdd.Plus>0,CONCAT('(add US$ > ',pdd.Plus,')'),'')) as Plus > FROM PackagesDepartureDates pdd > INNER JOIN Packages p > ON p.PackageID=pdd.PackageID > WHERE p.CodigoStatus=3 > AND pdd.DepartureDate>DATE_ADD(DATE_ADD(NOW(),INTERVAL -2 > HOUR), INTERVAL 10 DAY) > AND p.PackageID=000149 > 2408 Query SELECT SQL_CACHE DISTINCT pi.Day, > pi.ItineraryDescription > FROM PackagesItineraries pi > INNER JOIN Packages p > ON p.PackageID=pi.PackageID > WHERE p.CodigoStatus=3 > AND p.PackageID=000149 > 2408 Query SELECT SQL_CACHE DISTINCT s.State, > LOWER(c.CityName) as CityName, > pgp.Price > FROM PackagesGateways pg > INNER JOIN PackagesGatewayPrices pgp > ON pg.PackageID=pgp.PackageID > AND pg.Sequencia=pgp.Sequencia > INNER JOIN Airports a > ON a.AirportID=pg.AirportID > INNER JOIN Cities c > ON c.CityID=a.CityID > INNER JOIN States s > ON s.StateID=c.StateID > INNER JOIN Packages p > ON p.PackageID=pg.PackageID > WHERE p.CodigoStatus=3 > AND p.PackageID=000149 > ORDER BY pgp.Price, > c.CityName > 2408 Query SELECT SQL_CACHE p.Taxes, > p.SingleSuplement > FROM Packages p > WHERE p.PackageID=000149 > 2408 Query SELECT SQL_CACHE p.Notes, > p.HintsFile > FROM Packages p > WHERE p.CodigoStatus=3 > AND p.PackageID=000149 > LIMIT 1 > 2408 Query SELECT SQL_CACHE c.CountryName > FROM PackagesCountries cp > LEFT JOIN Countries c > ON c.CountryID=cp.CountryID > WHERE cp.PackageID=000149 > 2408 Query SELECT SQL_CACHE p.PackageID, > p.PackageName > FROM Packages p > WHERE p.CodigoStatus=3 > AND p.PackageID=000149 > 2408 Query SELECT SQL_CACHE a.AirportID, > a.AirportCode, > a.AirportName, > c.CityName, > pgp.Price > FROM Airports a > INNER JOIN Cities c > ON c.CityID=a.CityID > INNER JOIN PackagesGateways pg > ON pg.AirportID=a.AirportID > INNER JOIN PackagesGatewayPrices pgp > ON pgp.PackageID=pg.PackageID > AND pgp.Sequencia=pg.Sequencia > WHERE pg.PackageID=000149 > ORDER BY c.CityName > 2408 Query SELECT SQL_CACHE > DATE_FORMAT(pdd.DepartureDate,'%m-%d-%Y') as DepartureDateMostra, > pdd.DepartureDate, > pdd.Plus, > IF(pdd.Esgotado='1','YES','NO') as Esgotado > FROM PackagesDepartureDates pdd > WHERE pdd.PackageID=000149 > AND pdd.DepartureDate>DATE_ADD(NOW(), INTERVAL 10 DAY) > AND pdd.Esgotado<>'1' > ORDER BY pdd.DepartureDate > 2408 Query SELECT c.CountryName, > c.CountryID > FROM PackagesCountries cp > LEFT JOIN Countries c > ON c.CountryID=cp.CountryID > WHERE cp.PackageID=000149 > 2409 Query UPDATE AgenciesUsers > SET BlastEmailEnviado='2' > WHERE AgencyID=578 > AND Sequencia=0 > LIMIT 1 > 2408 Quit /usr/local/libexec/mysqld, Version: > 5.0.24-log. started with: > Tcp port: 3306 Unix socket: (null)