T04.001- Toda la información de los pedidos anteriores a octubre de 2010.
numPedido | usuario | fecha |
---|---|---|
1 | amd@colegas.com | 2010-03-03 00:00:00 |
2 | rpv@iotmail.cm | 2010-08-10 00:00:00 |
3 | jlop@bitoben.mus.es | 2010-08-07 00:00:00 |
4 | alr@agwab.com | 2010-07-31 00:00:00 |
5 | acm@colegas.com | 2010-08-11 00:00:00 |
6 | jgr@lamail.ar | 2010-08-31 00:00:00 |
7 | jmem@colegas.com | 2010-09-13 00:00:00 |
11 | jccf@eps.upa.ej | 2010-09-13 00:00:00 |
13 | jsm@lamail.ar | 2010-09-01 00:00:00 |
14 | mraj@colegas.com | 2010-08-13 00:00:00 |
17 | acs@emtj.cof | 2010-09-24 00:00:00 |
18 | deg@lamail.ar | 2010-08-26 00:00:00 |
19 | jmf1@colegas.com | 2010-09-17 00:00:00 |
20 | rpg@colegas.com | 2010-09-19 00:00:00 |
23 | spdp@colegas.com | 2010-08-12 00:00:00 |
24 | pgt@colegas.com | 2010-08-03 00:00:00 |
25 | mps@agwab.com | 2010-09-13 00:00:00 |
26 | hrdcj@colegas.com | 2010-08-26 00:00:00 |
28 | vsg@colegas.com | 2010-09-23 00:00:00 |
30 | agt@lamail.ar | 2010-09-13 00:00:00 |
31 | svv@colegas.com | 2010-09-10 00:00:00 |
32 | ah@colegas.com | 2010-09-02 00:00:00 |
33 | mav@colegas.com | 2010-09-16 00:00:00 |
34 | acm@colegas.com | 2010-09-29 00:00:00 |
36 | mraj@colegas.com | 2010-08-20 00:00:00 |
38 | spa@colegas.com | 2010-09-25 00:00:00 |
39 | jme@lolipop.com | 2010-08-06 00:00:00 |
41 | lsj@colegas.com | 2010-09-14 00:00:00 |
43 | orr@emtj.cof | 2010-08-09 00:00:00 |
47 | ans@colegas.com | 2010-08-30 00:00:00 |
49 | cvm@colegas.com | 2010-09-22 00:00:00 |
31 filas (de 31) seleccionadas
T04.002- Toda la información de los pedidos posteriores a agosto de 2010.
numPedido | usuario | fecha |
---|---|---|
7 | jmem@colegas.com | 2010-09-13 00:00:00 |
8 | jps@lamail.ar | 2010-10-07 00:00:00 |
9 | jptg@colegas.com | 2010-10-04 00:00:00 |
10 | emsm@eps.upa.ej | 2010-10-19 00:00:00 |
11 | jccf@eps.upa.ej | 2010-09-13 00:00:00 |
12 | ppa@colegas.com | 2010-11-06 00:00:00 |
13 | jsm@lamail.ar | 2010-09-01 00:00:00 |
15 | rbc@bitoben.mus.es | 2010-10-21 00:00:00 |
16 | cmg@colegas.com | 2010-10-05 00:00:00 |
17 | acs@emtj.cof | 2010-09-24 00:00:00 |
19 | jmf1@colegas.com | 2010-09-17 00:00:00 |
20 | rpg@colegas.com | 2010-09-19 00:00:00 |
21 | gvs@colegas.com | 2010-10-31 00:00:00 |
22 | ze@colegas.com | 2010-10-19 00:00:00 |
25 | mps@agwab.com | 2010-09-13 00:00:00 |
27 | kcdltb@colegas.com | 2010-10-26 00:00:00 |
28 | vsg@colegas.com | 2010-09-23 00:00:00 |
29 | jjgp@emtj.cof | 2010-11-06 00:00:00 |
30 | agt@lamail.ar | 2010-09-13 00:00:00 |
31 | svv@colegas.com | 2010-09-10 00:00:00 |
32 | ah@colegas.com | 2010-09-02 00:00:00 |
33 | mav@colegas.com | 2010-09-16 00:00:00 |
34 | acm@colegas.com | 2010-09-29 00:00:00 |
35 | adlmm@upa.ej | 2010-10-20 00:00:00 |
37 | jmpl@eps.upa.ej | 2010-10-31 00:00:00 |
38 | spa@colegas.com | 2010-09-25 00:00:00 |
40 | rcr@colegas.com | 2010-10-13 00:00:00 |
41 | lsj@colegas.com | 2010-09-14 00:00:00 |
42 | pcg@colegas.com | 2010-11-07 00:00:00 |
44 | pge@colegas.com | 2010-10-12 00:00:00 |
45 | pga@colegas.com | 2010-11-04 00:00:00 |
46 | agc@cazurren.ma.de | 2010-10-27 00:00:00 |
48 | fae@colegas.com | 2010-11-05 00:00:00 |
49 | cvm@colegas.com | 2010-09-22 00:00:00 |
50 | acl@emtj.cof | 2010-12-24 00:00:00 |
51 | bmm@agwab.com | 2010-10-20 00:00:00 |
36 filas (de 36) seleccionadas
T04.003- Toda la información de los pedidos realizados entre agosto y octubre de 2010.
numPedido | usuario | fecha |
---|---|---|
2 | rpv@iotmail.cm | 2010-08-10 00:00:00 |
3 | jlop@bitoben.mus.es | 2010-08-07 00:00:00 |
5 | acm@colegas.com | 2010-08-11 00:00:00 |
6 | jgr@lamail.ar | 2010-08-31 00:00:00 |
7 | jmem@colegas.com | 2010-09-13 00:00:00 |
8 | jps@lamail.ar | 2010-10-07 00:00:00 |
9 | jptg@colegas.com | 2010-10-04 00:00:00 |
10 | emsm@eps.upa.ej | 2010-10-19 00:00:00 |
11 | jccf@eps.upa.ej | 2010-09-13 00:00:00 |
13 | jsm@lamail.ar | 2010-09-01 00:00:00 |
14 | mraj@colegas.com | 2010-08-13 00:00:00 |
15 | rbc@bitoben.mus.es | 2010-10-21 00:00:00 |
16 | cmg@colegas.com | 2010-10-05 00:00:00 |
17 | acs@emtj.cof | 2010-09-24 00:00:00 |
18 | deg@lamail.ar | 2010-08-26 00:00:00 |
19 | jmf1@colegas.com | 2010-09-17 00:00:00 |
20 | rpg@colegas.com | 2010-09-19 00:00:00 |
21 | gvs@colegas.com | 2010-10-31 00:00:00 |
22 | ze@colegas.com | 2010-10-19 00:00:00 |
23 | spdp@colegas.com | 2010-08-12 00:00:00 |
24 | pgt@colegas.com | 2010-08-03 00:00:00 |
25 | mps@agwab.com | 2010-09-13 00:00:00 |
26 | hrdcj@colegas.com | 2010-08-26 00:00:00 |
27 | kcdltb@colegas.com | 2010-10-26 00:00:00 |
28 | vsg@colegas.com | 2010-09-23 00:00:00 |
30 | agt@lamail.ar | 2010-09-13 00:00:00 |
31 | svv@colegas.com | 2010-09-10 00:00:00 |
32 | ah@colegas.com | 2010-09-02 00:00:00 |
33 | mav@colegas.com | 2010-09-16 00:00:00 |
34 | acm@colegas.com | 2010-09-29 00:00:00 |
35 | adlmm@upa.ej | 2010-10-20 00:00:00 |
36 | mraj@colegas.com | 2010-08-20 00:00:00 |
37 | jmpl@eps.upa.ej | 2010-10-31 00:00:00 |
38 | spa@colegas.com | 2010-09-25 00:00:00 |
39 | jme@lolipop.com | 2010-08-06 00:00:00 |
40 | rcr@colegas.com | 2010-10-13 00:00:00 |
41 | lsj@colegas.com | 2010-09-14 00:00:00 |
43 | orr@emtj.cof | 2010-08-09 00:00:00 |
44 | pge@colegas.com | 2010-10-12 00:00:00 |
46 | agc@cazurren.ma.de | 2010-10-27 00:00:00 |
47 | ans@colegas.com | 2010-08-30 00:00:00 |
49 | cvm@colegas.com | 2010-09-22 00:00:00 |
51 | bmm@agwab.com | 2010-10-20 00:00:00 |
43 filas (de 43) seleccionadas
T04.004- Toda la información de los pedidos realizados el 3 de marzo o el 27 de octubre de 2010.
numPedido | usuario | fecha |
---|---|---|
1 | amd@colegas.com | 2010-03-03 00:00:00 |
46 | agc@cazurren.ma.de | 2010-10-27 00:00:00 |
2 filas (de 2) seleccionadas
T04.005- ¿En qué día y hora vivimos?
now() |
---|
2024-04-25 09:53:40 |
1 filas (de 1) seleccionadas
T04.006- Códigos de articulos solicitados en 2010, eliminando duplicados y ordenado ascendentemente.
articulo |
---|
A0001 |
A0002 |
A0003 |
A0006 |
A0008 |
A0009 |
A0010 |
A0012 |
A0013 |
A0014 |
A0015 |
A0016 |
A0017 |
A0018 |
A0020 |
A0023 |
A0024 |
A0025 |
A0027 |
A0028 |
A0029 |
A0030 |
A0031 |
A0032 |
A0033 |
A0034 |
A0036 |
A0037 |
A0038 |
A0040 |
A0041 |
A0042 |
A0044 |
A0046 |
A0048 |
A0051 |
A0052 |
A0053 |
A0054 |
A0055 |
A0056 |
A0057 |
A0059 |
A0060 |
A0070 |
A0072 |
A0146 |
A0198 |
A0199 |
A0200 |
A0203 |
A0204 |
A0205 |
A0206 |
A0207 |
A0210 |
A0211 |
A0214 |
A0215 |
A0216 |
A0220 |
A0225 |
A0233 |
A0303 |
A0686 |
A0689 |
A0692 |
A0695 |
A0774 |
A0776 |
A0777 |
A0778 |
A0779 |
A0780 |
A0781 |
A0785 |
A0788 |
A0818 |
A0946 |
A1069 |
A1073 |
A1074 |
A1077 |
A1078 |
A1079 |
A1080 |
A1082 |
A1083 |
A1084 |
A1085 |
A1086 |
A1087 |
A1088 |
A1089 |
A1091 |
A1235 |
A1252 |
A1257 |
A1265 |
A1270 |
100 filas (de 101) seleccionadas
T04.007- Códigos de articulos solicitados en pedidos de marzo de 2010, eliminando duplicados y ordenado ascendentemente.
articulo |
---|
A0214 |
A1085 |
2 filas (de 2) seleccionadas
T04.008- Toda la información de USUARIOs nacido en marzo de cualquier año.
nombre | apellidos | dni | telefono | calle | calle2 | codpos | pueblo | provincia | nacido | |
---|---|---|---|---|---|---|---|---|---|---|
acdlv@bitoben.mus.es | ANTONIO | CASTAÑO DE LA VIEJA | 24549899W | 968795875 | Rio Piles, 135, 6 s/n | (null) | 03052 | 1225 | 03 | 1984-03-18 |
acl@emtj.cof | ADRIANA | CALVARRO LAVIADA | 24669495B | 968861363 | Baldovi, 15, 10 B | (null) | 33036 | 0315 | 30 | 1971-03-28 |
agl@emtj.cof | ALBERTO | GURI LOPEZ | 25821404X | 969161414 | Barrio Cocoteros, 129, 5 D | (null) | 03010 | 0020 | 03 | 1963-03-06 |
als@agwab.com | ALVARO | LEON SIERRA | 23484374D | 961127974 | Jovellanos, 54, 7 A | (null) | 46003 | 0082 | 46 | 1989-03-11 |
amv@lamail.ar | ANGEL | MARTINEZ VASSALLO | 22853393A | 968634101 | Rio San Pedro, 141, 9 s/n | (null) | 03016 | 0134 | 03 | 1967-03-07 |
clqs@colegas.com | CESAR LUIS | QUINTERO SANZ | 22045526E | 961989842 | Pico Bustiello, 93, 10 s/n | (null) | 03015 | 0106 | 03 | 1959-03-07 |
emsm@eps.upa.ej | EVA MARIA | SANCHO MORILLO | 25249275M | 967305085 | Ronda, 126, 11 C | (null) | 02027 | 0539 | 02 | 1975-03-23 |
epg@colegas.com | EDUARDO | PEREZ GONZALEZ | 26336916F | 961732159 | Fuente De La Plata,Zona, 120, 7 B | (null) | 03053 | 1278 | 03 | 1977-03-22 |
fadr@colegas.com | FERNANDO | ARROYO DEL REY | 26293217Y | 962214597 | Periodistas Cepeda, 7, 3 A | (null) | 46024 | 2573 | 46 | 1960-03-11 |
febg@colegas.com | FRANCISCO EZEQUIEL | BAYAS GERALDINO | 25925420Y | 961908439 | Rosales, Los, 71, 2 D | (null) | 46061 | 2520 | 46 | 1955-03-16 |
ffp@colegas.com | FRANCISCO | FUENTES PADILLA | 25425062X | 968327639 | Pico Bustiello, 133, Bajo s/n | (null) | 46042 | 1748 | 46 | 1980-03-16 |
fss@colegas.com | FRANCISCO | SERRANO SALVAGO | 21606233U | 969701422 | Pin De La Quinta,Zona, 54, 9 izq. | (null) | 03019 | 0190 | 03 | 1984-03-30 |
gpy@colegas.com | GERMAN | PRIETO YERRO | 23154615K | 964528458 | Juan Cordero, 144, 9 s/n | (null) | 03036 | 0627 | 03 | 1969-03-20 |
jlop@bitoben.mus.es | JOSE LUIS | OCHOTORENA PICAZO | 25831650J | 968863844 | Piñeo, 84, 7 A | (null) | 33028 | 0145 | 30 | 1964-03-24 |
mccs@colegas.com | MARIA CRUZ | CAMPOS SAEZ | 23957736Q | 969530011 | Amorosas, 37, 4 C | (null) | 03052 | 1225 | 03 | 1971-03-07 |
mgm@colegas.com | MARCOS | GONZALEZ MUÑOZ | 24934034C | 966214029 | Anguila,Carretera, 76, 10 s/n | (null) | 03055 | 1301 | 03 | 1962-03-14 |
mpfh@emtj.cof | Mª PILAR | FERNANDEZ HERNANDEZ | 22165528L | 965962757 | Antonio Suarez, 96, 3 B | (null) | 03024 | 0361 | 03 | 1986-03-30 |
ofa@emtj.cof | OSCAR | FERNANDEZ ALBARRACIN | 22428387X | 986853258 | Piles,Carretera, 48, 11 izq. | (null) | 33023 | 0729 | 33 | 1987-03-27 |
ppa@colegas.com | PALOMA | PINTO AREVALO | 22098508E | 967362425 | Rosa Luxemburgo, 26, 7 izq. | (null) | 02018 | 0194 | 02 | 1989-03-10 |
vco@bitoben.mus.es | VANESSA | CHICHON ONTENIENTE | 22158533J | 961875720 | Aida Lafuente, 34, 2 B | (null) | 03014 | 0092 | 03 | 1974-03-04 |
20 filas (de 20) seleccionadas