[MYSQL] pb requete

Logiciel & apps Programmation
1

j ai une requete qui doit en fonction d un formulaire( numero du poste, jour de debut, jour de fin, mois de debut, mois de fin) me donner le contenu de la table

SELECT * FROM ticket WHERE date_format( CONCAT( 2005, ‘-’, recordMonth, ‘-’, recordDay ) , ‘%Y-%m-%d’ ) >= ‘$date_deb’ AND date_format( CONCAT( 2005, ‘-’, recordMonth, ‘-’, recordDay ) , ‘%Y-%m-%d’ ) <= ‘$date_fin’ AND date_format( CONCAT( recordHour, ‘-’, recordMin ) , ‘%k-%i’ ) >= ‘$heure_deb’ AND date_format( CONCAT( recordHour, ‘-’, recordMin ) , ‘%k-%i’ ) <= ‘$heure_fin’ AND (called =’$poste’ OR caller =’$poste’)

les type called et caller sont du cas possible pour le poste.
recordday est la date du jour, recordmonth le mois

cette requete ne marche pas du tout, ca me fait absolument rien…

si qq1 a une idee pour me decoincer?

merci d avance

2

tu demandes recorday supérieur ou égal à 1 ET strictement inférieur à 1 c’est pas compatible ca je pense.

pourquoi pas faire un BETWEEN X AND Y ?

3

ouep,

start tu m’as coupé l’herbe sous le pied :smiley:

4

Et au passage, les types dates existent en mySQL…

5

oups pardon effectivement je me suis trompe

mais avec inferieur ou egal ca change rien :frowning:

j ai vu le between mais la vu que je n ai pas de format date …correct on va dire (yyyy-mm-jj) mais dans un champ le jour et dans un autre le mois, ca marche qd meme?
parce que je vois pas trop la…

6

pour te repondre sans-nom, je dirais que le script qui alimente cette table est très special (JAVA) , il se connecte sur un serveur distant et recupere des infos au fil de l eau . Sachant que les trames en question sont dans un format tres particulier repris par chacun des champs present de la table voila c pour ca qu il n 'a pas de champ date.

7

erf. Essaye de mettre des entiers, et pas des chaînes tout de même.

8

oui ce sont type INT!

et pour ma requete…?

9

Ce sont des types INT et tu mets sciamment ‘01’ ?

10

Ca existe le || en mysql ? c’est pas OR ? je dois certainement me tromper mais bon ^^

Pourquoi ne pas concaténer ces valeurs que tu as pour les mettre dans un champ date, ca me semble plus logique, plus propre et plus économique en espace dans la base non ?

11

|| c’est l’opérateur de concaténation en SQL
en mySQL, c’est OR.

(mais vaut mieux préférer OR pour des raisons de standard)

En fait, c’est normal que la requête foire : il fait à chaque fois des cas impossibles (si x >= y, alors x < y n’est pas possible).

12

meme en corigeant la requete ca fait un peu mieux de choses mais c est pas complet

13

Est ce qu’il y a un truc qui correspond à ca dans ta base ?

14

oui il y a en tout 4 enregistrements qui doivent correspondre

or j en ai 3

on dirait que la partie apres le OR n est pas prise en compte…

par contre si je met la date de debut au 1/8 et la date de fin au 1/9…j ai les meme que si je mettais du 1/9 au 1/9 et la c vraiment pas normal du tout

15

Fais un dump de tes enregistrements, de la structure de ta table que l’on puisse tester :slight_smile: Et aussi dit bien lesquels devraient être bons ou pas :smiley:

16

voila:

CREATE TABLE ticket (
recordNum int(10) unsigned NOT NULL default ‘0’,
recordDay int(10) unsigned default ‘0’,
recordMonth int(10) unsigned default ‘0’,
recordHour int(10) unsigned default ‘0’,
recordMin int(10) unsigned default ‘0’,
caller varchar(4) default NULL,
serviceClass int(10) unsigned default ‘0’,
typeOfService int(10) unsigned NOT NULL default ‘0’,
callGroup char(2) default NULL,
number varchar(18) default NULL,
lapsHour int(10) unsigned default ‘0’,
lapsMin int(10) unsigned default ‘0’,
lapsSec int(10) unsigned default ‘0’,
ringHour int(10) unsigned default ‘0’,
ringMin int(10) unsigned default ‘0’,
ringSec int(10) unsigned default ‘0’,
ddi int(10) unsigned default ‘0’,
called varchar(4) default NULL,
cause int(10) unsigned default ‘0’,
channel int(10) unsigned default ‘0’,
route int(10) unsigned default ‘0’,
callIndex int(10) unsigned default ‘0’,
numberSent varchar(18) default NULL,
cost varchar(9) default NULL,
typeOfCall int(10) unsigned default ‘0’,
PRIMARY KEY (recordNum)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO ticket VALUES (3047, 29, 8, 13, 52, ‘48’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 9, 0, 0, 0, 3, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3048, 29, 8, 13, 52, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 22, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3049, 29, 8, 13, 52, ‘48’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 2, 0, 0, 0, 3, ‘B002’, 0, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3050, 29, 8, 13, 53, ‘48’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 13, 0, 0, 0, 3, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3051, 29, 8, 13, 53, ‘48’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 3, 0, 0, 0, 3, ‘B042’, 0, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3052, 29, 8, 13, 55, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 1, 17, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3053, 29, 8, 14, 5, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 21, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3054, 29, 8, 14, 29, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 43, 0, 0, 0, 2020, ‘869’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3055, 29, 8, 14, 29, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 48, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3056, 29, 8, 14, 36, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 59, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3057, 29, 8, 14, 38, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 3, 12, 0, 0, 0, 2, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3058, 29, 8, 14, 42, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 3, 17, 0, 0, 0, 2020, ‘869’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3059, 29, 8, 14, 45, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 48, 0, 0, 0, 2020, ‘860’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3060, 29, 8, 15, 14, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 33, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3061, 29, 8, 15, 19, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 26, 0, 0, 0, 2020, ‘862’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3062, 29, 8, 15, 18, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 37, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3063, 29, 8, 15, 26, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 9, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3064, 29, 8, 15, 27, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 3, 3, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3065, 29, 8, 15, 37, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 2, 33, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3066, 29, 8, 15, 40, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 20, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3067, 29, 8, 15, 29, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 13, 37, 0, 0, 0, 2020, ‘869’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3068, 29, 8, 15, 50, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 2, 14, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3069, 29, 8, 15, 57, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 3, 23, 0, 0, 0, 2020, ‘860’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3070, 29, 8, 15, 59, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 3, 22, 0, 0, 0, 2020, ‘860’, 3, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3071, 29, 8, 16, 2, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 16, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3072, 29, 8, 16, 4, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 15, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3073, 29, 8, 16, 15, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 3, 7, 0, 0, 0, 2020, ‘869’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3074, 29, 8, 16, 18, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 6, 0, 0, 0, 2020, ‘44’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3075, 29, 8, 16, 22, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 5, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3076, 29, 8, 16, 23, ‘48’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 18, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3077, 29, 8, 16, 29, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 28, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3078, 29, 8, 16, 31, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 2, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3079, 29, 8, 16, 32, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 25, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3080, 29, 8, 16, 23, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 12, 22, 0, 0, 0, 2020, ‘44’, 3, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3081, 29, 8, 16, 37, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 12, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3082, 29, 8, 16, 39, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 50, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3083, 29, 8, 16, 49, ‘32’, 13, 9, ‘F1’, ‘NULL’, NULL, 0, 20, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3084, 29, 8, 16, 53, ‘48’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 40, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3085, 29, 8, 16, 59, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 22, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3086, 29, 8, 17, 0, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 1, 46, 0, 0, 0, 2, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3087, 29, 8, 17, 3, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 1, 3, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3088, 29, 8, 17, 20, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 3, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3089, 29, 8, 17, 25, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 13, 0, 0, 0, 2020, ‘869’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3090, 29, 8, 17, 45, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, NULL, NULL, 0, 0, 0, 2020, ‘’, 0, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3091, 30, 8, 8, 19, ‘869’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 10, 0, 0, 0, 3, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3092, 30, 8, 8, 20, ‘869’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 30, 0, 0, 0, 3, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3093, 30, 8, 8, 20, ‘868’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 9, 0, 0, 0, 3, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3094, 30, 8, 8, 25, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 29, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3095, 30, 8, 8, 39, ‘32’, 13, 9, ‘F1’, ‘NULL’, NULL, 0, 32, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3096, 30, 8, 8, 35, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 6, 7, 0, 0, 0, 3, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3097, 30, 8, 8, 41, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 1, 44, 0, 0, 0, 2, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3098, 30, 8, 8, 46, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 1, 33, 0, 0, 0, 2, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3099, 30, 8, 8, 54, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 42, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3100, 30, 8, 8, 55, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 2, 3, 0, 0, 0, 2020, ‘43’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3101, 30, 8, 9, 2, ‘36’, 1, 1, ‘F1’, ‘NULL’, NULL, 0, 7, 0, 0, 0, 0, ‘B042’, 0, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3102, 30, 8, 9, 5, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 41, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3103, 30, 8, 9, 7, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 4, 9, 0, 0, 0, 4, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3104, 30, 8, 9, 11, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 15, 0, 0, 0, 2020, ‘44’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3105, 30, 8, 9, 15, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 1, 54, 0, 0, 0, 3, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3106, 30, 8, 9, 18, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 2, 8, 0, 0, 0, 3, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3107, 30, 8, 9, 20, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 11, 0, 0, 0, 2020, ‘44’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3108, 30, 8, 9, 19, ‘43’, 11, 1, ‘’, ‘NULL’, NULL, 3, 10, 0, 0, 0, NULL, ‘869’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3109, 30, 8, 9, 26, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 3, 37, 0, 0, 0, 2020, ‘44’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3110, 30, 8, 9, 30, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 2, 0, 0, 0, 0, 2, ‘B042’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3111, 30, 8, 9, 22, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 11, 19, 0, 0, 0, 4, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3112, 30, 8, 9, 35, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 2, 54, 0, 0, 0, 3, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3113, 30, 8, 9, 45, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 49, 0, 0, 0, 2020, ‘869’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3114, 30, 8, 9, 26, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 33, 16, 0, 0, 0, 2020, ‘43’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3115, 30, 8, 10, 0, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 5, 0, 0, 0, 3, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3116, 30, 8, 10, 1, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 54, 0, 0, 0, 2020, ‘869’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3117, 30, 8, 10, 1, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 6, 56, 0, 0, 0, 12, ‘B002’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3118, 30, 8, 10, 11, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 34, 0, 0, 0, 2020, ‘48’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3119, 30, 8, 10, 9, ‘43’, 11, 1, ‘’, ‘NULL’, NULL, 3, 49, 0, 0, 0, NULL, ‘869’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3120, 30, 8, 10, 17, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 40, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3121, 30, 8, 10, 15, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 4, 11, 0, 0, 0, 2020, ‘43’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3122, 30, 8, 10, 17, ‘48’, 10, 1, ‘F1’, ‘NULL’, NULL, 4, 39, 0, 0, 0, 2, ‘B042’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3123, 30, 8, 10, 23, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 59, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3124, 30, 8, 10, 23, ‘48’, 10, 1, ‘F1’, ‘NULL’, NULL, 2, 7, 0, 0, 0, 2, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3125, 30, 8, 10, 28, ‘48’, 10, 1, ‘F1’, ‘NULL’, NULL, 1, 11, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3126, 30, 8, 10, 28, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 3, 32, 0, 0, 0, 2020, ‘44’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3127, 30, 8, 10, 33, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 10, 32, 0, 0, 0, 2020, ‘43’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3128, 30, 8, 10, 51, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 20, 24, 0, 0, 0, 2020, ‘43’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3129, 30, 8, 11, 12, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 8, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3130, 30, 8, 11, 16, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, NULL, NULL, 0, 0, 0, 2020, ‘’, 0, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3131, 30, 8, 11, 15, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 11, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3132, 30, 8, 11, 14, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 3, 2, 0, 0, 0, 2, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3133, 30, 8, 11, 17, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 48, 0, 0, 0, 2, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3134, 30, 8, 11, 20, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 4, 0, 0, 0, 0, ‘B002’, 0, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3135, 30, 8, 11, 19, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 29, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3136, 30, 8, 11, 20, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 2, 16, 0, 0, 0, 2020, ‘44’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3137, 30, 8, 11, 24, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 35, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3138, 30, 8, 11, 18, ‘868’, 10, 1, ‘F1’, ‘NULL’, NULL, 9, 11, 0, 0, 0, 6, ‘B002’, 2, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3139, 30, 8, 11, 19, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 8, 33, 0, 0, 0, 7, ‘B042’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3140, 30, 8, 11, 28, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 3, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3141, 30, 8, 11, 29, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 30, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3142, 30, 8, 11, 31, ‘48’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 42, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3143, 30, 8, 11, 32, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 2, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3144, 30, 8, 11, 32, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 1, 1, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3145, 30, 8, 11, 21, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 14, 33, 0, 0, 0, 5, ‘B002’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3146, 30, 8, 11, 32, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 4, 55, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3147, 30, 8, 11, 42, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 27, 0, 0, 0, 2020, ‘860’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3148, 30, 8, 11, 50, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 31, 0, 0, 0, 1, ‘B042’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3149, 30, 8, 11, 51, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 2, 0, 0, 0, 1, ‘B002’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3150, 30, 8, 11, 51, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 2, 0, 0, 0, 1, ‘B042’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3151, 30, 8, 11, 49, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 3, 42, 0, 0, 0, 2020, ‘860’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3152, 30, 8, 11, 53, ‘48’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 10, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3153, 30, 8, 11, 46, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 7, 51, 0, 0, 0, 2020, ‘43’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3154, 30, 8, 11, 54, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 58, 0, 0, 0, 2020, ‘860’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3155, 30, 8, 11, 58, ‘43’, 11, 1, ‘’, ‘NULL’, NULL, NULL, NULL, 0, 0, 0, NULL, ‘44’, 0, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3156, 30, 8, 11, 58, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 55, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3157, 30, 8, 11, 58, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 54, 0, 0, 0, 2020, ‘44’, 3, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3158, 30, 8, 12, 7, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 19, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3159, 30, 8, 12, 8, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 28, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3160, 30, 8, 12, 11, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 14, 6, 0, 0, 0, 9289, ‘43’, 1, 1, NULL, NULL, NULL, NULL, 1);
INSERT INTO ticket VALUES (3161, 30, 8, 12, 49, ‘862’, 10, 1, ‘F1’, ‘NULL’, NULL, 8, 46, 0, 0, 0, 3, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3162, 30, 8, 14, 7, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 3, 38, 0, 0, 0, 2020, ‘868’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3163, 30, 8, 14, 16, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 19, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3164, 30, 8, 14, 20, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 2, 0, 0, 0, 1, ‘B002’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3165, 30, 8, 14, 15, ‘48’, 10, 1, ‘F1’, ‘NULL’, NULL, 10, 38, 0, 0, 0, 4, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3166, 30, 8, 14, 37, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 1, 2, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3167, 30, 8, 14, 40, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 2, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3168, 30, 8, 14, 40, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 2, 0, 0, 0, 1, ‘B002’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3169, 30, 8, 14, 31, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 15, 25, 0, 0, 0, 2020, ‘43’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3170, 30, 8, 14, 53, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, NULL, NULL, 0, 0, 0, 2020, ‘’, 0, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3171, 30, 8, 15, 10, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 38, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3172, 30, 8, 15, 20, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 12, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3173, 30, 8, 15, 26, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 4, 35, 0, 0, 0, 2020, ‘54’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3174, 30, 8, 15, 31, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 32, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3175, 30, 8, 15, 33, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 2, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3176, 30, 8, 15, 34, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, NULL, NULL, 0, 0, 0, 2020, ‘’, 0, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3177, 30, 8, 15, 36, ‘868’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 54, 0, 0, 0, 3, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3178, 30, 8, 15, 41, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 43, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3179, 30, 8, 15, 42, ‘868’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 28, 0, 0, 0, 3, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3180, 30, 8, 15, 43, ‘32’, 13, 9, ‘F1’, ‘NULL’, NULL, 1, 1, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3181, 30, 8, 15, 44, ‘868’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 32, 0, 0, 0, 3, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3182, 30, 8, 15, 46, ‘868’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 3, 0, 0, 0, 3, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3183, 30, 8, 15, 47, ‘868’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 3, 0, 0, 0, 3, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3184, 30, 8, 15, 55, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 47, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3185, 30, 8, 15, 57, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 42, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3186, 30, 8, 16, 8, ‘54’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 4, 0, 0, 0, 3, ‘B002’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3187, 30, 8, 16, 8, ‘54’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 9, 0, 0, 0, 3, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3188, 30, 8, 16, 9, ‘54’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 3, 0, 0, 0, 3, ‘B002’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3189, 30, 8, 16, 4, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 6, 45, 0, 0, 0, 2020, ‘48’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3190, 30, 8, 16, 14, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 3, 18, 0, 0, 0, 2020, ‘862’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3191, 30, 8, 16, 19, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, NULL, NULL, 0, 0, 0, 2020, ‘’, 0, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3192, 30, 8, 16, 29, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 28, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3193, 30, 8, 16, 41, ‘48’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 5, 0, 0, 0, 3, ‘B042’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3194, 30, 8, 16, 40, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 48, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3195, 30, 8, 16, 56, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 50, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3196, 30, 8, 16, 51, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 9, 3, 0, 0, 0, 2020, ‘54’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3197, 30, 8, 17, 1, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 30, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3198, 30, 8, 17, 4, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 9, 0, 0, 0, 0, 2020, ‘860’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3199, 30, 8, 17, 20, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, NULL, NULL, 0, 0, 0, 2020, ‘’, 0, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3200, 30, 8, 17, 31, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 5, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3201, 30, 8, 17, 32, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 28, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3202, 30, 8, 17, 37, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 3, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3203, 30, 8, 17, 37, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 19, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3204, 30, 8, 17, 52, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 2, 4, 0, 0, 0, 2, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3205, 31, 8, 8, 7, ‘36’, 1, 1, ‘’, ‘NULL’, NULL, 0, 38, 0, 0, 0, NULL, ‘44’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3206, 31, 8, 8, 6, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 2, 0, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3207, 31, 8, 8, 8, ‘36’, 1, 1, ‘’, ‘NULL’, NULL, 0, 4, 0, 0, 0, NULL, ‘862’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3208, 31, 8, 8, 8, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 2, 15, 0, 0, 0, 2020, ‘862’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3209, 31, 8, 8, 14, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 24, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3210, 31, 8, 8, 15, ‘36’, 1, 1, ‘’, ‘NULL’, NULL, 0, 3, 0, 0, 0, NULL, ‘44’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3211, 31, 8, 8, 15, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 2, 53, 0, 0, 0, 2020, ‘44’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3212, 31, 8, 8, 37, ‘32’, 13, 9, ‘F1’, ‘NULL’, NULL, 0, 17, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3213, 31, 8, 8, 56, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 39, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3214, 31, 8, 8, 57, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 26, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3215, 31, 8, 8, 57, ‘36’, 1, 1, ‘’, ‘NULL’, NULL, 0, 4, 0, 0, 0, NULL, ‘43’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3216, 31, 8, 8, 59, ‘36’, 1, 1, ‘F1’, ‘NULL’, NULL, 1, 9, 0, 0, 0, 2, ‘B002’, 7, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3217, 31, 8, 8, 57, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 3, 36, 0, 0, 0, 2020, ‘43’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3218, 31, 8, 9, 0, ‘32’, 13, 9, ‘F1’, ‘NULL’, NULL, 0, 39, 0, 0, 0, 2, ‘B042’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3219, 31, 8, 9, 11, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 43, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3220, 31, 8, 9, 20, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 11, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3221, 31, 8, 9, 22, ‘36’, 1, 1, ‘F1’, ‘NULL’, NULL, 0, 8, 0, 0, 0, 1, ‘B002’, 7, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3222, 31, 8, 9, 22, ‘36’, 1, 1, ‘F1’, ‘NULL’, NULL, 0, 14, 0, 0, 0, 1, ‘B042’, 7, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3223, 31, 8, 9, 26, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 9, 0, 0, 0, 2020, ‘36’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3224, 31, 8, 9, 25, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 3, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3225, 31, 8, 9, 26, ‘36’, 1, 1, ‘’, ‘NULL’, NULL, 0, 1, 0, 0, 0, NULL, ‘860’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3226, 31, 8, 9, 26, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 45, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3227, 31, 8, 9, 26, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 27, 0, 0, 0, 2020, ‘860’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3228, 31, 8, 9, 41, ‘42’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 56, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3229, 31, 8, 9, 42, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 25, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3230, 31, 8, 9, 43, ‘36’, 1, 1, ‘’, ‘NULL’, NULL, 0, 5, 0, 0, 0, NULL, ‘44’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3231, 31, 8, 9, 43, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 36, 0, 0, 0, 2020, ‘44’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3232, 31, 8, 9, 43, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 46, 0, 0, 0, 2020, ‘860’, 2, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3233, 31, 8, 9, 48, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 11, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3234, 31, 8, 9, 48, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 1, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3235, 31, 8, 9, 50, ‘32’, 13, 9, ‘F1’, ‘NULL’, NULL, 0, 18, 0, 0, 0, 1, ‘B042’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3236, 31, 8, 9, 48, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 3, 58, 0, 0, 0, 2, ‘B002’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3237, 31, 8, 9, 51, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 53, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3238, 31, 8, 9, 52, ‘36’, 1, 1, ‘’, ‘NULL’, NULL, 0, 10, 0, 0, 0, NULL, ‘44’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3239, 31, 8, 9, 52, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 1, 0, 0, 0, 2020, ‘44’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3240, 31, 8, 9, 55, ‘32’, 13, 9, ‘F1’, ‘NULL’, NULL, 0, 21, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3241, 31, 8, 9, 57, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 59, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3242, 31, 8, 9, 56, ‘36’, 1, 1, ‘F1’, ‘NULL’, NULL, 2, 13, 0, 0, 0, 2, ‘B002’, 7, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3243, 31, 8, 10, 2, ‘32’, 13, 9, ‘F1’, ‘NULL’, NULL, 0, 15, 0, 0, 0, 1, ‘B002’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3244, 31, 8, 10, 9, ‘36’, 1, 1, ‘’, ‘NULL’, NULL, NULL, NULL, 0, 0, 0, NULL, ‘44’, 0, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3245, 31, 8, 10, 10, ‘36’, 1, 1, ‘’, ‘NULL’, NULL, 0, 21, 0, 0, 0, NULL, ‘44’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3246, 31, 8, 10, 9, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 4, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3247, 31, 8, 10, 14, ‘42’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 50, 0, 0, 0, 1, ‘B042’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3248, 31, 8, 10, 15, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 49, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3249, 31, 8, 10, 17, ‘42’, 10, 1, ‘F1’, ‘NULL’, NULL, 3, 13, 0, 0, 0, 2, ‘B002’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3250, 31, 8, 10, 30, ‘36’, 1, 1, ‘’, ‘NULL’, NULL, NULL, NULL, 0, 0, 0, NULL, ‘44’, 0, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3251, 31, 8, 10, 31, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 10, 0, 0, 0, 0, ‘B042’, 0, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3252, 31, 8, 10, 30, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 3, 0, 0, 0, 2020, ‘860’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3253, 31, 8, 10, 32, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 28, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3254, 31, 8, 10, 32, ‘36’, 1, 1, ‘’, ‘NULL’, NULL, 0, 4, 0, 0, 0, NULL, ‘860’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3255, 31, 8, 10, 31, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 3, 6, 0, 0, 0, 3, ‘B002’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3256, 31, 8, 10, 35, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 55, 0, 0, 0, 2020, ‘36’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3257, 31, 8, 10, 32, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 6, 1, 0, 0, 0, 2020, ‘860’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3258, 31, 8, 10, 38, ‘36’, 1, 1, ‘’, ‘NULL’, NULL, 0, 23, 0, 0, 0, NULL, ‘44’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3259, 31, 8, 10, 39, ‘36’, 1, 1, ‘F1’, ‘NULL’, NULL, 0, 32, 0, 0, 0, 1, ‘B002’, 7, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3260, 31, 8, 10, 47, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 27, 0, 0, 0, 2020, ‘36’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3261, 31, 8, 10, 47, ‘36’, 1, 1, ‘’, ‘NULL’, NULL, 0, 4, 0, 0, 0, NULL, ‘44’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3262, 31, 8, 10, 46, ‘32’, 13, 9, ‘F1’, ‘NULL’, NULL, 1, 11, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3263, 31, 8, 10, 47, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 36, 0, 0, 0, 2020, ‘44’, 3, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3264, 31, 8, 10, 36, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 19, 48, 0, 0, 0, 6, ‘B042’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3265, 31, 8, 10, 56, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 1, 4, 0, 0, 0, 22, ‘B002’, 6, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3266, 31, 8, 10, 55, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 2, 3, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3267, 31, 8, 10, 57, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 28, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3268, 31, 8, 11, 3, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 3, 0, 0, 0, 0, ‘B042’, 0, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3269, 31, 8, 11, 10, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 57, 0, 0, 0, 2, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3270, 31, 8, 11, 3, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 8, 17, 0, 0, 0, 3, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3271, 31, 8, 11, 12, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 3, 40, 0, 0, 0, 2, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3272, 31, 8, 11, 16, ‘36’, 1, 1, ‘F1’, ‘NULL’, NULL, 1, 27, 0, 0, 0, 2, ‘B042’, 7, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3273, 31, 8, 11, 21, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 50, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3274, 31, 8, 11, 31, ‘36’, 1, 1, ‘’, ‘NULL’, NULL, NULL, NULL, 0, 0, 0, NULL, ‘37’, 0, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3275, 31, 8, 11, 32, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 15, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3276, 31, 8, 11, 31, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 1, 47, 0, 0, 0, 2, ‘B042’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3277, 31, 8, 11, 30, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 2, 53, 0, 0, 0, 2020, ‘37’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3278, 31, 8, 11, 33, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 28, 0, 0, 0, 2020, ‘44’, 2, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3279, 31, 8, 11, 35, ‘32’, 13, 9, ‘F1’, ‘NULL’, NULL, 0, 53, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3280, 31, 8, 11, 39, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 45, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3281, 31, 8, 11, 40, ‘36’, 1, 1, ‘’, ‘NULL’, NULL, 0, 4, 0, 0, 0, NULL, ‘44’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3282, 31, 8, 11, 40, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 36, 0, 0, 0, 2020, ‘44’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3283, 31, 8, 12, 8, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, NULL, NULL, 0, 0, 0, 9289, ‘43’, 0, 1, NULL, NULL, NULL, NULL, 1);
INSERT INTO ticket VALUES (3284, 31, 8, 13, 57, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 16, 0, 0, 0, 2020, ‘43’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3285, 31, 8, 14, 1, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 48, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3286, 31, 8, 14, 2, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, NULL, NULL, 0, 0, 0, 2020, ‘’, 0, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3287, 31, 8, 14, 6, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 3, 4, 0, 0, 0, 2, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3288, 31, 8, 14, 21, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, NULL, NULL, 0, 0, 0, 2020, ‘’, 0, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3289, 31, 8, 14, 22, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 32, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3290, 31, 8, 14, 25, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 39, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3291, 31, 8, 14, 27, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 17, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3292, 31, 8, 14, 28, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 3, 51, 0, 0, 0, 9289, ‘43’, 1, 1, NULL, NULL, NULL, NULL, 1);
INSERT INTO ticket VALUES (3293, 31, 8, 14, 33, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 2, 38, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3294, 31, 8, 14, 44, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 1, 6, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3295, 31, 8, 15, 0, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 3, 13, 0, 0, 0, 2020, ‘43’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3296, 31, 8, 15, 5, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 4, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3297, 31, 8, 15, 6, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 48, 0, 0, 0, 4, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3298, 31, 8, 15, 6, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 7, 0, 0, 0, 0, ‘B042’, 0, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3299, 31, 8, 15, 8, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 18, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3300, 31, 8, 15, 11, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 34, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3301, 31, 8, 15, 13, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 5, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3302, 31, 8, 15, 13, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 14, 14, 0, 0, 0, 11, ‘B042’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3303, 31, 8, 15, 29, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 18, 0, 0, 0, 1, ‘B002’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3304, 31, 8, 15, 30, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 51, 0, 0, 0, 2, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3305, 31, 8, 15, 30, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 9, 13, 0, 0, 0, 24, ‘B002’, 6, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3306, 31, 8, 15, 42, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 16, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3307, 31, 8, 16, 4, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 56, 0, 0, 0, 1, ‘B002’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3308, 31, 8, 16, 2, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 3, 41, 0, 0, 0, 2020, ‘860’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3309, 31, 8, 16, 6, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 3, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3310, 31, 8, 16, 6, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 29, 0, 0, 0, 2020, ‘860’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3311, 31, 8, 16, 9, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 42, 0, 0, 0, 2020, ‘44’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3312, 31, 8, 16, 7, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 5, 59, 0, 0, 0, 3, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3313, 31, 8, 16, 21, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 4, 0, 0, 0, 0, ‘B002’, 0, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3314, 31, 8, 16, 21, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 11, 0, 0, 0, 1, ‘B042’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3315, 31, 8, 16, 16, ‘54’, 10, 1, ‘F1’, ‘NULL’, NULL, 8, 14, 0, 0, 0, 7, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3316, 31, 8, 16, 24, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 41, 0, 0, 0, 2020, ‘44’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3317, 31, 8, 16, 28, ‘48’, 10, 1, ‘F1’, ‘NULL’, NULL, 1, 9, 0, 0, 0, 2, ‘B002’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3318, 31, 8, 16, 22, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 7, 38, 0, 0, 0, 7, ‘B042’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3319, 31, 8, 16, 29, ‘48’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 55, 0, 0, 0, 2, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3320, 31, 8, 16, 21, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 10, 38, 0, 0, 0, 4, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3321, 31, 8, 16, 37, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 8, 29, 0, 0, 0, 2020, ‘43’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3322, 31, 8, 16, 43, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 6, 18, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3323, 31, 8, 16, 59, ‘43’, 11, 1, ‘’, ‘NULL’, NULL, 0, 2, 0, 0, 0, NULL, ‘862’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3324, 31, 8, 16, 59, ‘43’, 11, 1, ‘’, ‘NULL’, NULL, 0, 26, 0, 0, 0, NULL, ‘48’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3325, 31, 8, 17, 8, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 10, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3326, 31, 8, 17, 10, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 37, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3327, 31, 8, 17, 15, ‘868’, 10, 1, ‘F1’, ‘NULL’, NULL, 1, 28, 0, 0, 0, 2, ‘B042’, 1, 2, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3328, 31, 8, 17, 19, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 9, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3329, 31, 8, 17, 20, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 6, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3330, 31, 8, 17, 25, ‘43’, 11, 1, ‘’, ‘NULL’, NULL, 0, 3, 0, 0, 0, NULL, ‘48’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3331, 31, 8, 16, 57, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 28, 53, 0, 0, 0, 2020, ‘862’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3332, 31, 8, 17, 37, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 2, 29, 0, 0, 0, 2, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3333, 31, 8, 17, 39, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 33, 0, 0, 0, 2020, ‘862’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3334, 31, 8, 17, 41, ‘32’, 13, 9, ‘F1’, ‘NULL’, NULL, 1, 3, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3335, 31, 8, 17, 42, ‘32’, 13, 9, ‘F1’, ‘NULL’, NULL, 0, 30, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3336, 31, 8, 17, 41, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 5, 24, 0, 0, 0, 2020, ‘43’, 3, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3337, 31, 8, 17, 49, ‘32’, 13, 9, ‘F1’, ‘NULL’, NULL, 1, 14, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3338, 31, 8, 17, 53, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 1, 0, 0, 0, 9289, ‘43’, 1, 1, NULL, NULL, NULL, NULL, 1);
INSERT INTO ticket VALUES (3339, 31, 8, 17, 53, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 4, 0, 0, 0, 0, ‘B002’, 0, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3340, 31, 8, 17, 53, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 7, 0, 0, 0, 0, ‘B042’, 0, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3341, 31, 8, 17, 54, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 4, 42, 0, 0, 0, 2, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3342, 31, 8, 18, 0, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 3, 0, 0, 0, 0, ‘B042’, 0, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3343, 31, 8, 18, 1, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 38, 0, 0, 0, 0, ‘B002’, 0, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3344, 31, 8, 18, 2, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 6, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3345, 31, 8, 18, 20, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 0, 15, 0, 0, 0, 0, ‘B002’, 0, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3346, 31, 8, 18, 42, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, NULL, NULL, 0, 0, 0, 2020, ‘’, 0, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3347, 31, 8, 18, 37, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 8, 23, 0, 0, 0, 2020, ‘43’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3348, 31, 8, 18, 48, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 58, 0, 0, 0, 9289, ‘43’, 1, 1, NULL, NULL, NULL, NULL, 1);
INSERT INTO ticket VALUES (3349, 31, 8, 18, 57, ‘43’, 11, 1, ‘F1’, ‘NULL’, NULL, 1, 27, 0, 0, 0, 1, ‘B042’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3350, 1, 9, 7, 32, ‘32’, 13, 9, ‘F1’, ‘NULL’, NULL, 0, 31, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3351, 1, 9, 7, 57, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 42, 0, 0, 0, 2020, ‘36’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3352, 1, 9, 7, 58, ‘36’, 1, 1, ‘’, ‘NULL’, NULL, 0, 3, 0, 0, 0, NULL, ‘44’, 1, NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO ticket VALUES (3353, 1, 9, 7, 58, ‘B042’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 38, 0, 0, 0, 2020, ‘44’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3465, 1, 9, 14, 44, ‘48’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 3, 0, 0, 0, 3, ‘B014’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3466, 1, 9, 14, 45, ‘B014’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 24, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3467, 1, 9, 14, 59, ‘B014’, NULL, 1, ‘F1’, ‘NULL’, NULL, 1, 6, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3468, 1, 9, 15, 0, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 4, 54, 0, 0, 0, 2020, ‘48’, 3, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3469, 1, 9, 15, 6, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 26, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3470, 1, 9, 15, 9, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 51, 0, 0, 0, 1, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3471, 1, 9, 15, 8, ‘48’, 10, 1, ‘F1’, ‘NULL’, NULL, 2, 49, 0, 0, 0, 2, ‘B014’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3472, 1, 9, 15, 11, ‘’, 32, 9, ‘F1’, ‘NULL’, NULL, 0, 3, 0, 0, 0, 1, ‘B014’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3473, 1, 9, 15, 16, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, NULL, NULL, 0, 0, 0, 2020, ‘’, 0, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3474, 1, 9, 15, 20, ‘B014’, NULL, 1, ‘F1’, ‘NULL’, NULL, 0, 33, 0, 0, 0, 2020, ‘869’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3475, 1, 9, 15, 19, ‘B014’, NULL, 1, ‘F1’, ‘NULL’, NULL, 2, 20, 0, 0, 0, 2020, ‘44’, 7, 1, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3476, 1, 9, 15, 48, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 0, 6, 0, 0, 0, 1, ‘B014’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3477, 1, 9, 15, 49, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 2, 34, 0, 0, 0, 2, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3478, 1, 9, 15, 50, ‘B002’, NULL, 1, ‘F1’, ‘NULL’, NULL, 3, 25, 0, 0, 0, 2020, ‘860’, 7, 2, NULL, NULL, NULL, NULL, 4);
INSERT INTO ticket VALUES (3479, 1, 9, 16, 8, ‘44’, 10, 1, ‘F1’, ‘NULL’, NULL, 1, 27, 0, 0, 0, 2, ‘B014’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3480, 1, 9, 16, 12, ‘39’, 13, 1, ‘F1’, ‘NULL’, NULL, 0, 6, 0, 0, 0, 3, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3481, 1, 9, 16, 12, ‘39’, 13, 1, ‘F1’, ‘NULL’, NULL, 0, 3, 0, 0, 0, 3, ‘B014’, 1, 1, NULL, NULL, NULL, NULL, 0);
INSERT INTO ticket VALUES (3482, 1, 9, 16, 12, ‘39’, 13, 1, ‘F1’, ‘NULL’, NULL, 0, 7, 0, 0, 0, 3, ‘B002’, 1, 1, NULL, NULL, NULL, NULL, 0);

17

Tu devrais utiliser des formats adapter pour toutes ces heures et minutes et jours là, tu te compliques la tâche à mon avis, encore que je ne sache pas trop à quoi serve ton script.

Par exemple recordmonth c’est bien un chiffre en 1 et 12 attendu non ? Pourquoi avoir un champ typé int(10) du coup ? c’est du gaspillage.

Enfin sans-nom, quand il passera, pourra certainement mieux se pronnoncer que moi dans ce domaine, mais de ma très faible connaissance du truc ca me semble pas très bon comme façon de procéder. Avec des dates t’as des fonctions prévues par mysql pour gérer les traitements que tu veux faire.

18

malheureusement je ne peux avoir dans mysql un format date avec yyyy-mm-jj…

je sais bien que ca complique enormement malheureusement je n ai pas le choix

19

deja met des parenthese pour ordonner tes test logique

( <condition1> AND <condition2> ) OR ( <condition3> AND <condition4> ) par ex

20

c fait!