T03.001- Código de los artículos que pertenecen a algún pack.
| articulo |
|---|
| A0070 |
| A0528 |
| A0200 |
| A0349 |
| A0557 |
| A1290 |
| A0023 |
| A0027 |
| A0037 |
9 filas (de 9) seleccionadas
T03.002- Número de pack, nombre y precio del mismo.
| cod | nombre | pvp |
|---|---|---|
| A0685 | Pack Foto | 3699.00 |
| A1234 | Pack FOTO 2 | 1499.99 |
| A1291 | Megaoferta | 299.99 |
3 filas (de 3) seleccionadas
T03.003- Código, nombre y marca de los artículos que pertenecen a algún pack.
| articulo | nombre | marca |
|---|---|---|
| A0070 | EOS-1D Mark III | Canon |
| A0528 | 50-150 mm f2.8 II EX DC APO HSM (Canon) | Sigma |
| A0200 | D3100 | Nikon |
| A0349 | 17-35 mm f2.8-4 DG EX HSM (Nikon) | Sigma |
| A0557 | 70-200 mm f2.8 DG EX HSM (Nikon) | Sigma |
| A1290 | SDHC-SD4/32GB | KINGSTON |
| A0023 | Digital IXUS 120 IS | Canon |
| A0027 | PowerShot D10 | Canon |
| A0037 | PowerShot SX1 IS | Canon |
9 filas (de 9) seleccionadas
T03.004- Código de la provincia Alicante.
| codp |
|---|
| 03 |
1 filas (de 1) seleccionadas
T03.005- Obtener el código, nombre y pvp de los articulos cuya marca comience por S.
| cod | nombre | pvp |
|---|---|---|
| A0296 | 8 mm f4 EX | (null) |
| A0297 | 8 mm f4 EX (Canon) | (null) |
| A0298 | 8 mm f4 EX (Nikon) | (null) |
| A0299 | 8 mm f4 EX (Minolta) | (null) |
| A0300 | 8 mm f4 EX (Pentax) | (null) |
| A0301 | 8 mm f4 DG EX | (null) |
| A0302 | 8 mm f4 DG EX (Canon) | (null) |
| A0303 | 8 mm f4 DG EX (Nikon) | 692.00 |
| A0304 | 8 mm f4 DG EX (Pentax) | (null) |
| A0305 | 8 mm f4 DG EX (Konica Minolta) | (null) |
| A0306 | 8-16 mm f4.5-5.6 DC HSM | (null) |
| A0307 | 8-16 mm f4.5-5.6 DC HSM (Sony) | 751.00 |
| A0308 | 8-16 mm f4.5-5.6 DC HSM (Nikon) | 751.00 |
| A0309 | 8-16 mm f4.5-5.6 DC HSM (Pentax) | (null) |
| A0310 | 8-16 mm f4.5-5.6 DC HSM (Canon) | 791.00 |
| A0311 | 10-20 mm f4-5.6 DC EX HSM | (null) |
| A0312 | 10-20 mm f4-5.6 DC EX HSM (Canon) | 419.00 |
| A0313 | 10-20 mm f4-5.6 DC EX HSM (Nikon) | 419.00 |
| A0314 | 10-20 mm f4-5.6 DC EX (Konica Minolta) | 425.00 |
| A0315 | 10-20 mm f4-5.6 DC EX (Pentax) | 450.00 |
| A0316 | 10-20 mm f4-5.6 DC EX (Cuatro Tercios) | 409.00 |
| A0317 | 10-20 mm f3.5 DC EX HSM | (null) |
| A0318 | 10-20 mm f3.5 DC EX HSM (Canon) | 575.00 |
| A0319 | 10-20 mm f3.5 DC EX HSM (Nikon) | 575.00 |
| A0320 | 10-20 mm f3.5 DC EX HSM (Pentax) | 792.43 |
| A0321 | 10-20 mm f3.5 DC EX HSM (Sony) | (null) |
| A0322 | 12-24 mm f4.5-5.6 DG EX HSM | (null) |
| A0323 | 12-24 mm f4.5-5.6 DG EX HSM (Canon) | 635.00 |
| A0324 | 12-24 mm f4.5-5.6 DG EX HSM (Nikon) | 635.00 |
| A0325 | 12-24 mm f4.5-5.6 DG EX (Pentax) | 826.00 |
| A0326 | 12-24 mm f4.5-5.6 DG EX (Minolta) | 649.00 |
| A0327 | 14 mm f2.8 EX HSM | (null) |
| A0328 | 14 mm f2.8 EX HSM (Canon) | (null) |
| A0329 | 14 mm f2.8 EX HSM (Nikon) | (null) |
| A0330 | 14 mm f2.8 EX (Minolta) | (null) |
| A0331 | 14 mm f2.8 EX (Pentax) | (null) |
| A0332 | 15 mm f2.8 EX | (null) |
| A0333 | 15 mm f2.8 EX (Canon) | 518.00 |
| A0334 | 15 mm f2.8 EX (Nikon) | (null) |
| A0335 | 15 mm f2.8 EX (Pentax) | (null) |
| A0336 | 15 mm f2.8 EX (Minolta) | (null) |
| A0337 | 15-30 mm f3.5-4.5 DG EX | (null) |
| A0338 | 15-30 mm f3.5-4.5 DG EX (Canon) | (null) |
| A0339 | 15-30 mm f3.5-4.5 DG EX (Nikon) | (null) |
| A0340 | 15-30 mm f3.5-4.5 DG EX (Pentax) | 442.09 |
| A0341 | 15-30 mm f3.5-4.5 DG EX (Minolta) | (null) |
| A0342 | 15 mm f2.8 DG EX | (null) |
| A0343 | 15 mm f2.8 DG EX (Canon) | (null) |
| A0344 | 15 mm f2.8 DG EX (Nikon) | 499.00 |
| A0345 | 15 mm f2.8 DG EX (Konica Minolta) | (null) |
| A0346 | 15 mm f2.8 DG EX (Pentax) | 695.02 |
| A0347 | 17-35 mm f2.8-4 DG EX HSM | (null) |
| A0348 | 17-35 mm f2.8-4 DG EX HSM (Canon) | (null) |
| A0349 | 17-35 mm f2.8-4 DG EX HSM (Nikon) | 315.00 |
| A0350 | 17-35 mm f2.8-4 DG EX (Pentax) | 584.99 |
| A0351 | 17-35 mm f2.8-4 DG EX (Minolta) | (null) |
| A0352 | 17-70 mm f2.8-4.5 DC Macro | (null) |
| A0353 | 17-70 mm f2.8-4.5 DC Macro (Nikon) | 295.00 |
| A0354 | 17-70 mm f2.8-4.5 DC Macro (Canon) | 298.08 |
| A0355 | 17-70 mm f2.8-4.5 DC Macro (Sony) | 295.00 |
| A0356 | 17-70 mm f2.8-4.5 DC Macro (Pentax) | 345.27 |
| A0357 | 17-70 mm f2.8-4.5 DC HSM Macro (Nikon) | (null) |
| A0358 | 17-70 mm f2.8-4 DC OS HSM Macro | (null) |
| A0359 | 17-70 mm f2.8-4 DC OS HSM Macro (Sony) | 401.00 |
| A0360 | 17-70 mm f2.8-4 DC OS HSM Macro (Nikon) | 390.00 |
| A0361 | 17-70 mm f2.8-4 DC OS HSM Macro (Pentax) | 415.00 |
| A0362 | 17-70 mm f2.8-4 DC OS HSM Macro (Canon) | 389.00 |
| A0363 | 17-50 mm f2.8 DC EX OS HSM | (null) |
| A0364 | 17-50 mm f2.8 DC EX OS HSM (Sony) | (null) |
| A0365 | 17-50 mm f2.8 DC EX OS HSM (Nikon) | 550.00 |
| A0366 | 17-50 mm f2.8 DC EX OS HSM (Pentax) | (null) |
| A0367 | 17-50 mm f2.8 DC EX OS HSM (Canon) | 550.00 |
| A0368 | 18-50 mm f2.8 DC EX (Minolta) | 396.34 |
| A0369 | 18-50 mm f3.5-5.6 DC | (null) |
| A0370 | 18-50 mm f3.5-5.6 DC (Canon) | (null) |
| A0371 | 18-50 mm f3.5-5.6 DC (Nikon) | (null) |
| A0372 | 18-50 mm f3.5-5.6 DC (Minolta) | (null) |
| A0373 | 18-50 mm f3.5-5.6 DC (Cuatro Tercios) | (null) |
| A0374 | 18-50 mm f3.5-5.6 DC (Pentax) | 136.31 |
| A0375 | 18-125 mm f3.5-5.6 DC | (null) |
| A0376 | 18-125 mm f3.5-5.6 DC (Canon) | 240.00 |
| A0377 | 18-125 mm f3.5-5.6 DC (Nikon) | 240.00 |
| A0378 | 18-125 mm f3.5-5.6 DC (Pentax) | (null) |
| A0379 | 18-125 mm f3.5-5.6 DC (Minolta) | (null) |
| A0380 | 18-125 mm f3.5-5.6 DC (Cuatro Tercios) | (null) |
| A0381 | 18-200 mm f3.5-6.3 DC (Sony) | 210.00 |
| A0382 | 18-50 mm f2.8 DC EX HSM (Nikon) | 414.00 |
| A0383 | 18-50 mm f3.5-5.6 DC HSM (Nikon) | (null) |
| A0384 | 18-200 mm f3.5-6.3 DC OS | (null) |
| A0385 | 18-200 mm f3.5-6.3 DC OS (Canon) | 335.00 |
| A0386 | 18-200 mm f3.5-6.3 DC OS HSM (Nikon) | 335.00 |
| A0387 | 18-200 mm f3.5-6.3 DC HSM (Nikon) | (null) |
| A0388 | 18-250 mm F3.5-6.3 DC OS HSM | (null) |
| A0389 | 18-250 mm F3.5-6.3 DC OS HSM (Nikon) | 475.00 |
| A0390 | 18-250 mm F3.5-6.3 DC OS HSM (Canon) | 475.00 |
| A0391 | 18-250 mm F3.5-6.3 DC OS HSM (Sony) | 475.00 |
| A0392 | 18-250 mm F3.5-6.3 DC OS HSM (Pentax) | 568.56 |
| A0393 | 18-50 mm f2.8-4.5 DC OS HSM | (null) |
| A0394 | 18-50 mm f2.8-4.5 DC OS HSM (Canon) | 237.16 |
| A0395 | 18-50 mm f2.8-4.5 DC OS HSM (Nikon) | 265.64 |
100 filas (de 755) seleccionadas
T03.006- Información sobre los usuarios cuyo email es de la eps.
| nombre | apellidos | dni | telefono | calle | calle2 | codpos | pueblo | provincia | nacido | |
|---|---|---|---|---|---|---|---|---|---|---|
| aza@eps.upa.ej | ALVARO | ZUGASTI AGÜI | 25849667M | 967972188 | Abetos, De Los,Camino, 32, 10 D | (null) | 02034 | 0621 | 02 | 1981-04-28 |
| bom@eps.upa.ej | BORIS | OLIVAS MORENO | 23169082H | 967611302 | Fuerte, Al,Camino, 41, 1 B | (null) | 02046 | 0833 | 02 | 1979-07-30 |
| dmpb@eps.upa.ej | DANIEL | MARTIN PORTUGUES BARBERO | 26226581X | 961438475 | Jose Maria Fernandez Buelta, 18, Bajo der. | (null) | 46038 | 1555 | 46 | 1972-02-16 |
| dov@eps.upa.ej | DAVID | OLIVARES VILLEGAS | 26102931K | 986284003 | Juan Escalante De Mendoza, 54, Bajo C | (null) | 33021 | 0674 | 33 | 1987-12-31 |
| emsm@eps.upa.ej | EVA MARIA | SANCHO MORILLO | 25249275M | 967305085 | Ronda, 126, 11 C | (null) | 02027 | 0539 | 02 | 1975-03-23 |
| erv@eps.upa.ej | EDWIN | ROMERO VASQUEZ | 24612313J | 964096803 | Baja, 1, 2 C | (null) | 03049 | 1072 | 03 | 1983-10-29 |
| fgm@eps.upa.ej | FELIPE | GOMEZ-JAREÑO MORENO | 25624572I | 961303271 | Amadeo Roca, Pintor, 46, 5 D | (null) | 46021 | 0804 | 46 | 1958-07-27 |
| hdp@eps.upa.ej | HUGO | DIAZ-REGAÑÓN PALAO | 24818744I | 967744463 | Barracas De Llacer, 35, 5 B | (null) | 03052 | 1225 | 03 | 1964-02-12 |
| jccf@eps.upa.ej | JUAN CARLOS | CONDE FERNANDEZ | 25386132B | 967101780 | Jose Maribona, 28, 1 C | (null) | 02039 | 0714 | 02 | 1957-08-25 |
| jdmg@eps.upa.ej | JUAN | DE MIGUEL GONZALEZ | 25521346R | 967674554 | Piles, Eria Del, 121, 2 D | (null) | 03023 | 0358 | 03 | 1956-09-10 |
| jmpl@eps.upa.ej | JUAN MIGUEL | PEDREGOSA LOSADA | 23027499U | 982885387 | Barraca, La, 15, 4 C | (null) | 03060 | 0083 | 33 | 1987-09-17 |
| mfds@eps.upa.ej | MARTIN FEDERICO | DESCALZI SANTAMARIA | 25875209P | 967205220 | Barrio Francisco Climent, 147, 1 A | (null) | 03039 | 0699 | 03 | 1971-02-09 |
| mnrg@eps.upa.ej | MARIA NADIA | RODRIGUEZ GARCIA-ABAD | 26399064B | 963242272 | Barraca, La, 22, Bajo C | (null) | 46039 | 1537 | 46 | 1986-10-31 |
| pmm@eps.upa.ej | PABLO | MELIJOSA MENDEZ | 23875015S | 962600472 | Barrio Patronato, 129, 6 D | (null) | 03049 | 1072 | 03 | 1973-12-05 |
| rlh@eps.upa.ej | RAFAEL | LOPEZ HIDALGO | 22435274X | 985596556 | Rosales, Los, 110, 7 der. | (null) | 33019 | 0621 | 33 | 1959-11-26 |
| rvg@eps.upa.ej | RAUL | VALENCIA GARCIA | 21772426X | 981358839 | Baja, 130, 9 izq. | (null) | 33015 | 0501 | 33 | 1961-08-20 |
| sm@eps.upa.ej | STEFANO | MAZZOLETTI | 24081201F | 961872189 | Ameriques, 14, 1 D | (null) | 03038 | 0686 | 03 | 1988-06-12 |
17 filas (de 17) seleccionadas
T03.007- Código, nombre y resolución de los televisores cuya pantalla no esté entre 22 y 42.
| cod | nombre | resolucion |
|---|---|---|
| A0686 | 55LE8500 | 1920 x 1080 |
| A0687 | 50PS8000 | 1920 x 1080 |
| A0694 | 47LE5300 | 1920 x 1080 |
| A0696 | 47LE8500 | 1920 x 1080 |
| A0698 | 19LG3010 | 1440 x 900 |
| A0699 | 19LG3000 | 1440 x 900 |
| A0701 | 22LG3050 | 1680 x 1050 |
| A0702 | 19LG3050 | 1440 x 900 |
| A0705 | 19LS4D | 1440 x 900 |
| A0706 | 47LG5000 | 1920 x 1080 |
| A0707 | 50PG3000 | 1365 x 768 |
| A0711 | 52LG5000 | 1920 x 1080 |
| A0713 | 60PG3000 | 1365 x 768 |
| A0717 | 47LG6000 | 1920 x 1080 |
| A0719 | 50PG6000 | 1365 x 768 |
| A0722 | 47LY95 | 1920 x 1080 |
| A0725 | 50PT85 | 1366 x 768 |
| A0733 | 60PC45 | 1366 x 768 |
| A0734 | 47LF65 | 1920 x 1080 |
| A0737 | 50PF55 | 1366 x 768 |
| A0740 | 60PF95 Chocolate | 1920 x 1080 |
| A0745 | 20LS5R | 640 x 480 |
| A0746 | 19LS4R | 1440 x 900 |
| A0747 | 17LS5R | 1280 x 1024 |
| A0748 | 20LS1R | 640 x 480 |
| A0749 | 15LS1R | 1024 x 768 |
| A0750 | 50PC55 | 1366 x 768 |
| A0752 | MW-71PY10 | 1920 x 1080 |
| A0753 | 60PY2R | 1366 x 768 |
| A0754 | 50PC1RR | 1366 x 768 |
| A0755 | 50PC1D | 1366 x 768 |
| A0766 | 20LC1RB | 640 x 480 |
| A0767 | 15LC1RB | 1024 x 768 |
| A0788 | Bravia KDL-46EX700 | 1920 x 1080 |
| A0789 | Bravia KDL-46HX700 | 1920 x 1080 |
| A0790 | Bravia KDL-46HX800 | 1920 x 1080 |
| A0791 | Bravia KDL-46HX900 | 1920 x 1080 |
| A0792 | Bravia KDL-52NX800 | 1920 x 1080 |
| A0793 | Bravia KDL-52LX900 | 1920 x 1080 |
| A0794 | Bravia KDL-52EX700 | 1920 x 1080 |
| A0795 | Bravia KDL-52HX900 | 1920 x 1080 |
| A0796 | Bravia KDL-60LX900 | 1920 x 1080 |
| A0799 | Bravia KDL-52V5500 | 1920 x 1080 |
| A0801 | Bravia KDL-46Z5500 | 1920 x 1080 |
| A0802 | Bravia KDL-46V5500 | 1920 x 1080 |
| A0803 | Bravia KDL-52Z5500 | 1920 x 1080 |
| A0809 | Bravia KDL-46WE5W | 1920 x 1080 |
| A0810 | Bravia KDL-46W5500 | 1920 x 1080 |
| A0811 | Bravia KDL-52W5500 | 1920 x 1080 |
| A0812 | XEL-1 | 960 x 540 |
| A0822 | Bravia KDL-46X4500 | 1920 x 1080 |
| A0823 | Bravia KDL-46EX1 | 1920 x 1080 |
| A0824 | Bravia KDL-46Z4500 | 1920 x 1080 |
| A0825 | Bravia KDL-46W4500 | 1920 x 1080 |
| A0826 | Bravia KDL-52Z4500 | 1920 x 1080 |
| A0827 | Bravia KDL-52EX1 | 1920 x 1080 |
| A0828 | Bravia KDL-52W4500 | 1920 x 1080 |
| A0829 | Bravia KDL-55X4500 | 1920 x 1080 |
| A0847 | Bravia KDL-46V4000 | 1920 x 1080 |
| A0848 | Bravia KDL-52V4000 | 1920 x 1080 |
| A0851 | Bravia KDL-46W4000 | 1920 x 1080 |
| A0852 | Bravia KDL-52W4000 | 1920 x 1080 |
| A0853 | Bravia KDL-20B4030 | 1366 x 768 |
| A0854 | Bravia KDL-20B4050 | 1366 x 768 |
| A0859 | Bravia KDL-20G3030 | 640 x 480 |
| A0860 | Bravia KDL-20G3000 | 640 x 480 |
| A0861 | Bravia KDL-20S3030 | 1366 x 768 |
| A0862 | Bravia KDL-20S3040 | 1366 x 768 |
| A0863 | Bravia KDL-20S3050 | 1366 x 768 |
| A0864 | Bravia KDL-20S3060 | 1366 x 768 |
| A0865 | Bravia KDL-20S3070 | 1366 x 768 |
| A0866 | Bravia KDL-20S4000 | 1366 x 768 |
| A0867 | Bravia KDL-20S4020 | 1366 x 768 |
| A0868 | Bravia KDL-20S3000 | 1366 x 768 |
| A0892 | Bravia KDL-46X3500 | 1920 x 1080 |
| A0893 | Bravia KDL-46X3000 | 1920 x 1080 |
| A0894 | Bravia KDL-46W3000 | 1920 x 1080 |
| A0895 | Bravia KDL-46V3000 | 1920 x 1080 |
| A0896 | Bravia KDL-52X3500 | 1920 x 1080 |
| A0897 | Bravia KDL-52W3000 | 1920 x 1080 |
| A0898 | Bravia KDL-70X3500 | 1920 x 1080 |
| A0901 | Bravia KDL-46D3500 | 1920 x 1080 |
| A0902 | Bravia KDL-46D3000 | 1366 x 768 |
| A0914 | Bravia KDL-46V2500 | 1366 x 768 |
| A0915 | Bravia KDL-46S2530 | 1366 x 768 |
| A0916 | Bravia KDL-15G2000 | 1024 x 768 |
| A0917 | Bravia KDL-20G2000 | 640 x 480 |
| A0927 | Bravia KDL-46V2000 | 1366 x 768 |
| A0928 | Bravia KDL-46V2000 | 1366 x 768 |
| A0929 | Bravia KDL-46W2000 | 1920 x 1080 |
| A0930 | Bravia KDF-50E2010 | 1280 x 720 |
| A0931 | Bravia KDL-52X2000 | 1920 x 1080 |
| A0932 | Bravia KDL-52X2000B | 1920 x 1080 |
| A0933 | Bravia KDS-55A2000 | 1920 x 1080 |
| A0934 | Bravia KDS-70R2000 | 1920 x 1080 |
| A0935 | Bravia KLV-15SR3 | 640 x 480 |
| A0936 | Bravia KDL-20S2000 | 1366 x 768 |
| A0937 | Bravia KDL-20S2020 | 1366 x 768 |
| A0938 | Bravia KDL-20S2030 | 1366 x 768 |
| A0944 | Bravia KDL-46S2000 | 1366 x 768 |
100 filas (de 178) seleccionadas
T03.008- Código y nombre de los televisores cuyo panel sea tipo LED y su precio no supere los 1000 euros.
| cod | nombre |
|---|---|
| A0689 | 32LE5300 |
| A0690 | 37LE5300 |
| A0691 | 42LE5300 |
| A0692 | 32LE5500 |
| A0693 | 37LE5500 |
| A0697 | 42LE5500 |
| A0774 | Bravia KDL-32EX500 |
| A0775 | Bravia KDL-32EX600 |
| A0776 | Bravia KDL-32EX700 |
| A0777 | Bravia KDL-32EX402 |
| A0778 | Bravia KDL-37EX402 |
| A0779 | Bravia KDL-37EX500 |
| A0780 | Bravia KDL-40EX402 |
| A0781 | Bravia KDL-40EX500 |
| A0782 | Bravia KDL-40EX600 |
| A1069 | UE32C6000 |
| A1070 | UE32C6510 |
| A1074 | UE40C6000 |
| A1085 | UE22C4000 |
| A1086 | UE26C4000 |
| A1087 | UE32C5100 |
| A1088 | UE32C4000 |
| A1089 | UE37C5100 |
| A1090 | UE40C5100 |
24 filas (de 24) seleccionadas
T03.009- Email de los usuarios cuyo código postal no sea 02012, 02018 o 02032.
| aam@colegas.com |
| aca@agwab.com |
| acdlv@bitoben.mus.es |
| acg@iotmail.cm |
| acl@emtj.cof |
| acm@colegas.com |
| acm@upa.ej |
| acn@iotmail.cm |
| adf@lolipop.com |
| adlmm@upa.ej |
| adrm@emtj.cof |
| aeb@colegas.com |
| afg@colegas.com |
| agg@gbail.com |
| agl@emtj.cof |
| agt@lamail.ar |
| ah@colegas.com |
| ali@gbail.com |
| alm@lolipop.com |
| alr@agwab.com |
| als@agwab.com |
| ama@lolipop.com |
| amd@colegas.com |
| amg@lamail.ar |
| aml@colegas.com |
| amp@colegas.com |
| amt@iotmail.cm |
| amv@emtj.cof |
| amv@lamail.ar |
| ana@lolipop.com |
| ans@colegas.com |
| apa@colegas.com |
| apg1@colegas.com |
| apg2@colegas.com |
| apv@colegas.com |
| arc@colegas.com |
| ards@emtj.cof |
| ars@bitoben.mus.es |
| ary@bitoben.mus.es |
| asc@colegas.com |
| aza@eps.upa.ej |
| bgc@agwab.com |
| bmm@agwab.com |
| bom@eps.upa.ej |
| btb@gbail.com |
| cag@bitoben.mus.es |
| cagdt@cazurren.ma.de |
| cam@colegas.com |
| cat@emtj.cof |
| cat@lamail.ar |
| cca@upa.ej |
| cfu@lamail.ar |
| clqs@colegas.com |
| cmg@colegas.com |
| cms@lamail.ar |
| coc@cazurren.ma.de |
| coco@gbail.com |
| com@colegas.com |
| csdc@lolipop.com |
| csr@colegas.com |
| cvm@colegas.com |
| czf@colegas.com |
| das@colegas.com |
| dbb@cazurren.ma.de |
| ddmm@iotmail.cm |
| deg@lamail.ar |
| dfg@colegas.com |
| dga@iotmail.cm |
| dgl@lamail.ar |
| dgm@upa.ej |
| dhg@colegas.com |
| dmb@colegas.com |
| dmm@colegas.com |
| dmpb@eps.upa.ej |
| dov@eps.upa.ej |
| drg@emtj.cof |
| dvl@colegas.com |
| edc@colegas.com |
| edv@upa.ej |
| egm@emtj.cof |
| emc@agwab.com |
| emc@colegas.com |
| emr@iotmail.cm |
| ems@iotmail.cm |
| emsm@eps.upa.ej |
| epg@colegas.com |
| erv@eps.upa.ej |
| etp@colegas.com |
| fadr@colegas.com |
| fae@colegas.com |
| fbp@colegas.com |
| fcm@lolipop.com |
| fcs@bitoben.mus.es |
| fdf@colegas.com |
| febg@colegas.com |
| ffp@colegas.com |
| fgm@eps.upa.ej |
| fls@colegas.com |
| fmm@cazurren.ma.de |
| fms@colegas.com |
100 filas (de 260) seleccionadas
T03.010- Código y nombre de los packs de los que se conoce qué articulos los componen, eliminando duplicados.
| cod | nombre |
|---|---|
| A0685 | Pack Foto |
| A1234 | Pack FOTO 2 |
| A1291 | Megaoferta |
3 filas (de 3) seleccionadas
T03.011- ¿Hay algún artículo en cesta que esté descatalogado?
| articulo | usuario | fecha | stock | disponible | entrega |
|---|
0 filas (de 0) seleccionadas
T03.012- Código, nombre y pvp de las cámaras de tipo compacta.
| cod | nombre | pvp |
|---|---|---|
| A0001 | PowerShot SX30 IS | 415.00 |
| A0002 | PowerShot G12 | 529.00 |
| A0004 | PowerShot SX130 IS | 165.00 |
| A0005 | IXUS 1000 HS | 319.00 |
| A0006 | PowerShot S95 | 399.00 |
| A0007 | Digital IXUS 300 HS | 285.00 |
| A0008 | PowerShot SX210 IS | 219.00 |
| A0009 | Digital IXUS 210 IS | 219.00 |
| A0010 | Digital IXUS 130 | 159.00 |
| A0011 | Digital IXUS 105 | 129.00 |
| A0013 | PowerShot A3100 IS | 109.00 |
| A0014 | PowerShot A3000 IS | 115.00 |
| A0015 | PowerShot A495 | 85.00 |
| A0016 | PowerShot A490 | 90.00 |
| A0019 | PowerShot S90 | 299.00 |
| A0020 | PowerShot G11 | 385.00 |
| A0021 | PowerShot SX120 IS | 159.00 |
| A0022 | PowerShot SX20 IS | 287.00 |
| A0023 | Digital IXUS 120 IS | 227.00 |
| A0024 | Digital IXUS 200 IS | 190.00 |
| A0026 | Digital IXUS 95 IS | 250.00 |
| A0027 | PowerShot D10 | 241.00 |
| A0028 | PowerShot SX200 IS | 125.00 |
| A0029 | PowerShot A1100 IS | 175.00 |
| A0030 | PowerShot A2100 IS | 160.00 |
| A0031 | Digital IXUS 100 IS | 220.00 |
| A0032 | Digital IXUS 110 IS | 259.00 |
| A0033 | Digital IXUS 990 IS | 319.00 |
| A0034 | PowerShot A480 | 75.00 |
| A0036 | PowerShot G10 | 299.00 |
| A0037 | PowerShot SX1 IS | 170.00 |
| A0038 | PowerShot SX10 IS | 380.00 |
| A0039 | Digital IXUS 870 IS | 190.00 |
| A0040 | Digital IXUS 980 IS | 305.00 |
| A0042 | PowerShot SX110 IS | 275.00 |
| A0043 | PowerShot A2000 IS | 187.00 |
| A0044 | PowerShot A1000 IS | 360.00 |
| A0045 | PowerShot E1 | 353.00 |
| A0047 | Digital IXUS 970 IS | 359.00 |
| A0048 | Digital IXUS 90 IS | 298.00 |
| A0049 | Digital IXUS 85 IS | 206.00 |
| A0051 | Digital IXUS 80 IS | 480.00 |
| A0052 | PowerShot A590 IS | 260.00 |
| A0053 | PowerShot A470 | 334.00 |
| A0054 | PowerShot A580 | 285.00 |
| A0055 | Digital IXUS 960 IS | 150.00 |
| A0056 | PowerShot A720 IS | 496.00 |
| A0057 | PowerShot A650 IS | 216.00 |
| A0058 | PowerShot SX100 IS | 336.00 |
| A0059 | Digital IXUS 860 IS | 398.00 |
| A0061 | PowerShot G9 | (null) |
| A0063 | Digital IXUS 950 IS | (null) |
| A0064 | PowerShot S5 IS | (null) |
| A0065 | Digital IXUS 70 | (null) |
| A0066 | Digital IXUS 75 | (null) |
| A0067 | PowerShot TX1 | (null) |
| A0068 | PowerShot A560 | (null) |
| A0069 | PowerShot A570 IS | (null) |
| A0071 | PowerShot A450 | (null) |
| A0072 | PowerShot A460 | 69.00 |
| A0073 | PowerShot A550 | (null) |
| A0074 | Digital IXUS 850 IS | (null) |
| A0075 | PowerShot G7 | (null) |
| A0076 | Digital IXUS i7 zoom | (null) |
| A0077 | Digital IXUS 900 Ti | (null) |
| A0078 | PowerShot A710 IS | (null) |
| A0079 | PowerShot A630 | (null) |
| A0080 | PowerShot A640 | (null) |
| A0082 | PowerShot S3 IS | (null) |
| A0084 | Digital IXUS 60 | (null) |
| A0085 | Digital IXUS 65 | (null) |
| A0086 | Digital IXUS 800 IS | (null) |
| A0087 | PowerShot A420 | (null) |
| A0088 | PowerShot A430 | (null) |
| A0089 | PowerShot A530 | (null) |
| A0090 | PowerShot A540 | (null) |
| A0091 | PowerShot A700 | (null) |
| A0092 | Digital IXUS Wireless | (null) |
| A0093 | PowerShot A620 | (null) |
| A0094 | PowerShot A610 | (null) |
| A0095 | PowerShot A410 | (null) |
| A0096 | PowerShot S80 | (null) |
| A0099 | Digital IXUS 750 | (null) |
| A0100 | Digital IXUS 55 | (null) |
| A0101 | Digital IXUS i zoom | (null) |
| A0102 | PowerShot S2 IS | (null) |
| A0103 | Digital IXUS 700 | (null) |
| A0105 | Digital IXUS 50 | (null) |
| A0107 | PowerShot A520 | (null) |
| A0108 | PowerShot A510 | (null) |
| A0110 | Digital IXUS i5 | (null) |
| A0111 | Digital IXUS 30 | (null) |
| A0112 | Digital IXUS 40 | (null) |
| A0114 | PowerShot G6 | (null) |
| A0115 | PowerShot S70 | (null) |
| A0116 | PowerShot A95 | (null) |
| A0117 | PowerShot A400 | (null) |
| A0118 | PowerShot A85 | (null) |
| A0119 | PowerShot S60 | (null) |
| A0120 | Digital IXUS IIs | (null) |
100 filas (de 245) seleccionadas
T03.013- Código, nombre y diferencia entre pvp e importe de los articulos que hayan sido solicitados en algún pedido a un importe distinto de su precio de venta al público.
| cod | nombre | pvp-importe |
|---|---|---|
| A1085 | UE22C4000 | 120.00 |
| A1086 | UE26C4000 | 50.00 |
| A0777 | Bravia KDL-32EX402 | 104.00 |
| A0211 | Coolpix S640 | 12.00 |
| A0215 | D300s | -114.00 |
| A1078 | UE46C8000 | -34.00 |
| A0204 | Coolpix S3000 | 61.00 |
| A0016 | PowerShot A490 | 34.00 |
| A0210 | Coolpix S1000pj | -5.00 |
| A1077 | UE46C7000 | -114.00 |
| A1077 | UE46C7000 | -46.00 |
| A0024 | Digital IXUS 200 IS | -13.00 |
| A0023 | Digital IXUS 120 IS | -13.00 |
| A0220 | Coolpix S220 | -107.00 |
| A0233 | D700 | 74.00 |
| A0010 | Digital IXUS 130 | -67.00 |
| A0052 | PowerShot A590 IS | -135.00 |
| A0036 | PowerShot G10 | -68.00 |
| A1091 | UE46C5100 | 30.00 |
| A0055 | Digital IXUS 960 IS | 9.00 |
| A1083 | UE55C8000 | 51.00 |
| A0215 | D300s | 127.00 |
| A1084 | UE40C8000 | -40.00 |
| A0027 | PowerShot D10 | 71.00 |
| A0017 | EOS-1D Mark IV | 82.00 |
| A0023 | Digital IXUS 120 IS | -82.00 |
| A0013 | PowerShot A3100 IS | -114.00 |
| A0777 | Bravia KDL-32EX402 | 72.00 |
| A0220 | Coolpix S220 | 5.00 |
| A0779 | Bravia KDL-37EX500 | 7.00 |
| A1085 | UE22C4000 | 2.00 |
| A0059 | Digital IXUS 860 IS | 88.00 |
| A0206 | Coolpix L110 | 45.00 |
| A0042 | PowerShot SX110 IS | -109.00 |
| A0214 | D3000 | 32.00 |
| A0818 | Bravia KDL-40ZX1 | 128.00 |
| A1079 | UE46C6000 | -84.00 |
| A0033 | Digital IXUS 990 IS | -53.00 |
| A0205 | Coolpix P100 | -3.00 |
| A0215 | D300s | -146.00 |
| A0018 | EOS 7D | -114.00 |
| A0037 | PowerShot SX1 IS | -5.00 |
| A0032 | Digital IXUS 110 IS | -145.00 |
| A0818 | Bravia KDL-40ZX1 | 26.00 |
| A0006 | PowerShot S95 | -79.00 |
| A0211 | Coolpix S640 | -93.00 |
| A0009 | Digital IXUS 210 IS | -9.00 |
| A0198 | Coolpix S5100 | 129.00 |
| A0774 | Bravia KDL-32EX500 | 32.00 |
| A0025 | EOS 500D | 116.00 |
| A0023 | Digital IXUS 120 IS | -23.00 |
| A0040 | Digital IXUS 980 IS | 101.00 |
| A0233 | D700 | -20.00 |
| A0025 | EOS 500D | 39.00 |
| A0044 | PowerShot A1000 IS | 18.00 |
| A0686 | 55LE8500 | -40.00 |
| A0788 | Bravia KDL-46EX700 | 70.00 |
| A0206 | Coolpix L110 | 48.00 |
| A0029 | PowerShot A1100 IS | 60.00 |
| A0041 | EOS 50D | -149.00 |
| A0203 | Coolpix S4000 | 110.00 |
| A1078 | UE46C8000 | 14.00 |
| A1079 | UE46C6000 | -63.00 |
| A0206 | Coolpix L110 | 21.00 |
| A0072 | PowerShot A460 | -110.00 |
| A0146 | EOS-D60 | 85.00 |
| A0692 | 32LE5500 | -81.00 |
| A0027 | PowerShot D10 | -94.00 |
| A0014 | PowerShot A3000 IS | 149.00 |
| A0034 | PowerShot A480 | 105.00 |
| A0205 | Coolpix P100 | -72.00 |
| A1089 | UE37C5100 | 40.00 |
| A0030 | PowerShot A2100 IS | -36.00 |
| A0016 | PowerShot A490 | -115.00 |
| A1091 | UE46C5100 | 15.00 |
| A0225 | D3X | 59.00 |
| A1086 | UE26C4000 | -71.00 |
| A0028 | PowerShot SX200 IS | 132.00 |
| A0781 | Bravia KDL-40EX500 | 149.00 |
| A0001 | PowerShot SX30 IS | -87.00 |
| A1080 | UE46C6530 | 27.00 |
| A0029 | PowerShot A1100 IS | 11.00 |
| A0778 | Bravia KDL-37EX402 | -71.00 |
| A0020 | PowerShot G11 | 85.00 |
| A0692 | 32LE5500 | -37.00 |
| A1069 | UE32C6000 | 41.00 |
| A0689 | 32LE5300 | -9.00 |
| A0206 | Coolpix L110 | -79.00 |
| A1282 | SDHC 16GB CL4 AGFA | 2.37 |
| A0012 | EOS 550D | 23.00 |
| A0038 | PowerShot SX10 IS | 15.00 |
| A0057 | PowerShot A650 IS | 65.00 |
| A0051 | Digital IXUS 80 IS | -98.00 |
| A0056 | PowerShot A720 IS | 113.00 |
| A0042 | PowerShot SX110 IS | 11.00 |
| A0025 | EOS 500D | 45.00 |
| A0034 | PowerShot A480 | 67.00 |
| A0695 | 42LE8500 | 133.00 |
| A0020 | PowerShot G11 | -130.00 |
| A0046 | EOS 1000D | 112.00 |
100 filas (de 107) seleccionadas
T03.014- Número de pedido,fecha y nombre y apellidos del usuario que solicita el pedido, para aquellos pedidos solicitados por algún usuario de apellido MARTINEZ.
| numpedido | fecha | nombre | apellidos |
|---|---|---|---|
| 1 | 2010-03-03 00:00:00 | ALEJANDRA | MARTINEZ DOBARCO |
| 19 | 2010-09-17 00:00:00 | JAVIER | MARTINEZ FERNANDEZ |
2 filas (de 2) seleccionadas
T03.016- Nombre, marca y resolucion de las cámaras que nunca se han solicitado.
| nombre | marca | resolucion |
|---|---|---|
| PowerShot SX130 IS | Canon | 4000 x 3000 |
| IXUS 1000 HS | Canon | 3648 x 2736 |
| Digital IXUS 300 HS | Canon | 3648 x 2736 |
| Digital IXUS 105 | Canon | 4000 x 3000 |
| PowerShot S90 | Canon | 3648 x 2736 |
| PowerShot SX120 IS | Canon | 3648 x 2736 |
| PowerShot SX20 IS | Canon | 4000 x 3000 |
| Digital IXUS 95 IS | Canon | 3648 x 2736 |
| EOS 5D Mark II | Canon | 5616 x 3744 |
| Digital IXUS 870 IS | Canon | 3648 x 2736 |
| PowerShot A2000 IS | Canon | 3648 x 2736 |
| PowerShot E1 | Canon | 3648 x 2736 |
| Digital IXUS 970 IS | Canon | 3648 x 2736 |
| Digital IXUS 85 IS | Canon | 3648 x 2736 |
| EOS 450D | Canon | 4272 x 2848 |
| PowerShot SX100 IS | Canon | 3264 x 2448 |
| PowerShot G9 | Canon | 4000 x 3000 |
| EOS 40D | Canon | 3888 x 2592 |
| Digital IXUS 950 IS | Canon | 3264 x 2448 |
| PowerShot S5 IS | Canon | 3264 x 2448 |
| Digital IXUS 70 | Canon | 3072 x 2304 |
| Digital IXUS 75 | Canon | 3072 x 2304 |
| PowerShot TX1 | Canon | 3072 x 2304 |
| PowerShot A560 | Canon | 3072 x 2304 |
| PowerShot A570 IS | Canon | 3072 x 2304 |
| PowerShot A450 | Canon | 2592 x 1944 |
| PowerShot A550 | Canon | 3072 x 2304 |
| Digital IXUS 850 IS | Canon | 3072 x 2304 |
| PowerShot G7 | Canon | 3648 x 2736 |
| Digital IXUS i7 zoom | Canon | 2592 x 1944 |
| Digital IXUS 900 Ti | Canon | 3648 x 2736 |
| PowerShot A710 IS | Canon | 3072 x 2304 |
| PowerShot A630 | Canon | 3264 x 2448 |
| PowerShot A640 | Canon | 3648 x 2736 |
| EOS 400D | Canon | 3888 x 2592 |
| PowerShot S3 IS | Canon | 2816 x 2112 |
| EOS 30D | Canon | 3504 x 2336 |
| Digital IXUS 60 | Canon | 2816 x 2112 |
| Digital IXUS 65 | Canon | 2816 x 2112 |
| Digital IXUS 800 IS | Canon | 2816 x 2112 |
| PowerShot A420 | Canon | 2272 x 1704 |
| PowerShot A430 | Canon | 2272 x 1704 |
| PowerShot A530 | Canon | 2592 x 1944 |
| PowerShot A540 | Canon | 2816 x 2112 |
| PowerShot A700 | Canon | 2816 x 2112 |
| Digital IXUS Wireless | Canon | 2592 x 1944 |
| PowerShot A620 | Canon | 3072 x 2304 |
| PowerShot A610 | Canon | 2592 x 1944 |
| PowerShot A410 | Canon | 2048 x 1536 |
| PowerShot S80 | Canon | 3264 x 2448 |
| EOS-1D Mark II N | Canon | 3504 x 2336 |
| EOS 5D | Canon | 4368 x 2912 |
| Digital IXUS 750 | Canon | 3072 x 2304 |
| Digital IXUS 55 | Canon | 2592 x 1944 |
| Digital IXUS i zoom | Canon | 2592 x 1944 |
| PowerShot S2 IS | Canon | 2592 x 1944 |
| Digital IXUS 700 | Canon | 3072 x 2304 |
| EOS 350D | Canon | 3456 x 2304 |
| Digital IXUS 50 | Canon | 2592 x 1944 |
| EOS 20Da | Canon | 3504 x 2336 |
| PowerShot A520 | Canon | 2272 x 1704 |
| PowerShot A510 | Canon | 2048 x 1536 |
| EOS-1Ds Mark II | Canon | 4992 x 3328 |
| Digital IXUS i5 | Canon | 2592 x 1944 |
| Digital IXUS 30 | Canon | 2048 x 1536 |
| Digital IXUS 40 | Canon | 2272 x 1704 |
| EOS 20D | Canon | 3504 x 2336 |
| PowerShot G6 | Canon | 3072 x 2304 |
| PowerShot S70 | Canon | 3072 x 2304 |
| PowerShot A95 | Canon | 2592 x 1944 |
| PowerShot A400 | Canon | 2048 x 1536 |
| PowerShot A85 | Canon | 2272 x 1704 |
| PowerShot S60 | Canon | 2592 x 1944 |
| Digital IXUS IIs | Canon | 2048 x 1536 |
| Digital IXUS 430 | Canon | 2272 x 1704 |
| Digital IXUS 500 | Canon | 2592 x 1944 |
| PowerShot Pro1 | Canon | 3264 x 2448 |
| PowerShot S1 IS | Canon | 2048 x 1536 |
| PowerShot A310 | Canon | 2048 x 1536 |
| PowerShot A75 | Canon | 2048 x 1536 |
| EOS-1D Mark II | Canon | 3504 x 2336 |
| Digital IXUS i | Canon | 2274 x 1704 |
| EOS 300D | Canon | 3072 x 2048 |
| PowerShot A80 | Canon | 2272 x 1704 |
| PowerShot G5 | Canon | 2592 x 1944 |
| Digital IXUS II | Canon | 2048 x 1536 |
| EOS 10D | Canon | 3072 x 2048 |
| PowerShot A300 | Canon | 2048 x 1536 |
| PowerShot A60 | Canon | 1600 x 1200 |
| PowerShot A70 | Canon | 2048 x 1536 |
| PowerShot S50 | Canon | 2592 x 1944 |
| Digital IXUS 400 | Canon | 2272 x 1704 |
| EOS-1Ds | Canon | 4064 x 2704 |
| PowerShot G3 | Canon | 2272 x 1704 |
| Digital IXUS v3 | Canon | 2048 x 1536 |
| PowerShot S45 | Canon | 2272 x 1704 |
| PowerShot A200 | Canon | 1600 x 1200 |
| Digital IXUS v2 | Canon | 1600 x 1200 |
| Digital IXUS 330 | Canon | 1600 x 1200 |
| PowerShot A100 | Canon | 1280 x 960 |
100 filas (de 232) seleccionadas
T03.017- Código, nombre, tipo y marca de las cámaras de marca Nikon, LG o Sigma.
| cod | nombre | tipo | marca |
|---|---|---|---|
| A0164 | Coolpix 4800 | compacta, visor óptico | Nikon |
| A0165 | Coolpix 8400 | compacta, visor electrónico | Nikon |
| A0166 | Coolpix 8800 | compacta, visor electrónico | Nikon |
| A0167 | Coolpix 4100 | compacta, visor óptico | Nikon |
| A0168 | Coolpix 4200 | compacta, visor óptico | Nikon |
| A0169 | Coolpix 5200 | compacta, visor óptico | Nikon |
| A0170 | D70 | réflex, objetivos intercambiables | Nikon |
| A0171 | Coolpix 8700 | compacta, visor electrónico | Nikon |
| A0172 | Coolpix 2200 | compacta, visor óptico | Nikon |
| A0173 | Coolpix 3200 | compacta, visor óptico | Nikon |
| A0174 | Coolpix 3700 | compacta, visor óptico | Nikon |
| A0175 | D2H | réflex, objetivos intercambiables | Nikon |
| A0176 | Coolpix 5400 | compacta, visor óptico | Nikon |
| A0177 | D100 | réflex, objetivos intercambiables | Nikon |
| A0178 | Coolpix 2100 | compacta, visor óptico | Nikon |
| A0179 | Coolpix SQ | compacta, sin visor | Nikon |
| A0180 | Coolpix 3100 | compacta, visor óptico | Nikon |
| A0181 | Coolpix 3500 | compacta, sin visor | Nikon |
| A0182 | Coolpix 4300 | compacta, visor óptico | Nikon |
| A0183 | Coolpix 2000 | compacta, sin visor | Nikon |
| A0184 | Coolpix 4500 | compacta, visor óptico | Nikon |
| A0185 | Coolpix 5700 | compacta, visor electrónico | Nikon |
| A0186 | Coolpix 2500 | compacta, sin visor | Nikon |
| A0187 | Coolpix 5000 | compacta, visor óptico | Nikon |
| A0188 | Coolpix 885 | compacta, visor óptico | Nikon |
| A0189 | Coolpix 775 | compacta, visor óptico | Nikon |
| A0190 | Coolpix 990 | compacta, visor óptico | Nikon |
| A0191 | Coolpix 995 | compacta, visor óptico | Nikon |
| A0192 | Coolpix 880 | compacta, visor óptico | Nikon |
| A0193 | Coolpix 800 | compacta, visor óptico | Nikon |
| A0194 | Coolpix 950 | compacta, visor óptico | Nikon |
| A0195 | D7000 | réflex, objetivos intercambiables | Nikon |
| A0196 | Coolpix P7000 | compacta, visor óptico | Nikon |
| A0197 | Coolpix S80 | compacta, sin visor | Nikon |
| A0198 | Coolpix S5100 | compacta, sin visor | Nikon |
| A0199 | Coolpix S1100pj | compacta, sin visor | Nikon |
| A0200 | D3100 | réflex, objetivos intercambiables | Nikon |
| A0201 | Coolpix S8000 | compacta, sin visor | Nikon |
| A0202 | Coolpix S6000 | compacta, sin visor | Nikon |
| A0203 | Coolpix S4000 | compacta, sin visor | Nikon |
| A0204 | Coolpix S3000 | compacta, sin visor | Nikon |
| A0205 | Coolpix P100 | compacta, visor electrónico | Nikon |
| A0206 | Coolpix L110 | compacta, sin visor | Nikon |
| A0207 | Coolpix L22 | compacta, sin visor | Nikon |
| A0208 | Coolpix L21 | compacta, sin visor | Nikon |
| A0209 | D3s | réflex, objetivos intercambiables | Nikon |
| A0210 | Coolpix S1000pj | compacta, sin visor | Nikon |
| A0211 | Coolpix S640 | compacta, sin visor | Nikon |
| A0212 | Coolpix S570 | compacta, sin visor | Nikon |
| A0213 | Coolpix S70 | compacta, sin visor | Nikon |
| A0214 | D3000 | réflex, objetivos intercambiables | Nikon |
| A0215 | D300s | réflex, objetivos intercambiables | Nikon |
| A0216 | D5000 | réflex, objetivos intercambiables | Nikon |
| A0217 | Coolpix L19 | compacta, sin visor | Nikon |
| A0218 | Coolpix L20 | compacta, sin visor | Nikon |
| A0219 | Coolpix L100 | compacta, sin visor | Nikon |
| A0220 | Coolpix S220 | compacta, sin visor | Nikon |
| A0221 | Coolpix S230 | compacta, sin visor | Nikon |
| A0222 | Coolpix S620 | compacta, sin visor | Nikon |
| A0223 | Coolpix P90 | compacta, visor electrónico | Nikon |
| A0224 | Coolpix S630 | compacta, sin visor | Nikon |
| A0225 | D3X | réflex, objetivos intercambiables | Nikon |
| A0226 | D90 | réflex, objetivos intercambiables | Nikon |
| A0227 | Coolpix P6000 | compacta, visor óptico | Nikon |
| A0228 | Coolpix S60 | compacta, sin visor | Nikon |
| A0229 | Coolpix S710 | compacta, sin visor | Nikon |
| A0230 | Coolpix S610c | compacta, sin visor | Nikon |
| A0231 | Coolpix S610 | compacta, sin visor | Nikon |
| A0232 | Coolpix S560 | compacta, sin visor | Nikon |
| A0233 | D700 | réflex, objetivos intercambiables | Nikon |
| A0234 | Coolpix S52 | compacta, sin visor | Nikon |
| A0235 | Coolpix S52c | compacta, sin visor | Nikon |
| A0236 | Coolpix P80 | compacta, visor electrónico | Nikon |
| A0237 | Coolpix L16 | compacta, sin visor | Nikon |
| A0238 | Coolpix L18 | compacta, sin visor | Nikon |
| A0239 | Coolpix S210 | compacta, sin visor | Nikon |
| A0240 | Coolpix S520 | compacta, sin visor | Nikon |
| A0241 | Coolpix S550 | compacta, sin visor | Nikon |
| A0242 | Coolpix S600 | compacta, sin visor | Nikon |
| A0243 | Coolpix P60 | compacta, visor electrónico | Nikon |
| A0244 | D60 | réflex, objetivos intercambiables | Nikon |
| A0245 | Coolpix P5100 | compacta, visor óptico | Nikon |
| A0246 | Coolpix P50 | compacta, visor óptico | Nikon |
| A0247 | Coolpix S700 | compacta, sin visor | Nikon |
| A0248 | Coolpix S510 | compacta, sin visor | Nikon |
| A0249 | Coolpix S51c | compacta, sin visor | Nikon |
| A0250 | Coolpix S51 | compacta, sin visor | Nikon |
| A0251 | Coolpix L14 | compacta, sin visor | Nikon |
| A0252 | Coolpix L15 | compacta, sin visor | Nikon |
| A0253 | D3 | réflex, objetivos intercambiables | Nikon |
| A0254 | D300 | réflex, objetivos intercambiables | Nikon |
| A0255 | D40x | réflex, objetivos intercambiables | Nikon |
| A0256 | Coolpix L10 | compacta, sin visor | Nikon |
| A0257 | Coolpix L11 | compacta, sin visor | Nikon |
| A0258 | Coolpix L12 | compacta, sin visor | Nikon |
| A0259 | Coolpix S200 | compacta, sin visor | Nikon |
| A0260 | Coolpix S500 | compacta, sin visor | Nikon |
| A0261 | Coolpix S50c | compacta, sin visor | Nikon |
| A0262 | Coolpix S50 | compacta, sin visor | Nikon |
| A0263 | Coolpix P5000 | compacta, visor óptico | Nikon |
100 filas (de 132) seleccionadas
T03.019- Marcas de las que no existe ningún televisor en nuestra base de datos.
| marca |
|---|
| AGFA |
| Canon |
| ENERGY SISTEM |
| HOODMAN |
| KINGSTON |
| Nikon |
| SANDISK |
| Sigma |
| TRANSCEND |
| Xiaomi |
10 filas (de 10) seleccionadas
T03.021- Nombre de los artículos cuyo nombre contenga la palabra EOS.
| nombre |
|---|
| EOS 60D |
| EOS 550D |
| EOS-1D Mark IV |
| EOS 7D |
| EOS 500D |
| EOS 5D Mark II |
| EOS 50D |
| EOS 1000D |
| EOS 450D |
| EOS-1Ds Mark III |
| EOS 40D |
| EOS-1D Mark III |
| EOS 400D |
| EOS 30D |
| EOS-1D Mark II N |
| EOS 5D |
| EOS 350D |
| EOS 20Da |
| EOS-1Ds Mark II |
| EOS 20D |
| EOS-1D Mark II |
| EOS 300D |
| EOS 10D |
| EOS-1Ds |
| EOS-D60 |
| EOS-1D |
| EOS-D30 |
| Cineos 32PFL9632D/10 |
| Cineos 32PFL7962D/12 |
| Cineos 32PFL7862D/10 |
| Cineos 37PFL9732D/10 |
| Cineos 37PFL9632D/10 |
| Cineos 37PF9641D/10 |
| Cineos 42PFL9732D/10 |
| Cineos 42PFL9632D/10 |
| Cineos 47PFL9732D/10 |
| Cineos 47PFL9532D/10 |
| Cineos 47PFL9632D/10 |
| Cineos 52PFL9632D/10 |
| Cineos 26PF9631D/10 |
| Cineos 26PF9531/10 |
| Cineos 32PF9731D/10 |
| Cineos 32PF9641D/10 |
| Cineos 32PF9551/10 |
| Cineos 32PF9541/10 |
| Cineos 32PF9631D/10 |
| Cineos 32PF9531/10 |
| Cineos 37PF9731D/10 |
| Cineos 37PF9631D/10 |
| Cineos 42PF9631D/10 |
| Cineos 42PF9831D/10 |
| Cineos 42PF9731D/10 |
| Cineos 42PF9641D/10 |
| Cineos 42PF7641D/10 |
| Cineos 50PF9631D/10 |
55 filas (de 55) seleccionadas
T03.022- Tipo y focal de los objetivos que se monten en una cámara Canon sea cual sea el modelo.
| tipo | focaL |
|---|---|
| ojo de pez | 8 mm |
| ojo de pez | 8 mm |
| angular zoom | 8-16 mm |
| angular zoom | 10-20 mm |
| angular zoom | 10-20 mm |
| angular zoom | 12-24 mm |
| angular fijo | 14 mm |
| ojo de pez | 15 mm |
| angular zoom | 15-30 mm |
| ojo de pez | 15 mm |
| angular zoom | 17-35 mm |
| ultrazoom | 17-70 mm |
| angular zoom | 17-70 mm |
| estándar zoom | 17-50 mm |
| angular zoom | 18-50 mm |
| ultrazoom | 18-125 mm |
| ultrazoom | 18-200 mm |
| ultrazoom | 18-250 mm |
| angular zoom | 18-50 mm |
| ultrazoom | 18-200 mm |
| angular zoom | 18-50 mm |
| angular fijo | 20 mm |
| angular zoom | 20-40 mm |
| angular fijo | 24 mm |
| angular zoom | 24-60 mm |
| angular zoom | 24-70 mm |
| angular zoom | 24-70 mm |
| ultrazoom | 24-135 mm |
| angular zoom | 24-70 mm |
| angular fijo | 28 mm |
| estándar zoom | 28-70 mm |
| angular zoom | 28-70 mm |
| estándar zoom | 28-80 mm |
| estándar zoom | 28-105 mm |
| estándar zoom | 28-105 mm |
| estándar zoom | 28-135 mm |
| ultrazoom | 28-200 mm |
| ultrazoom | 28-300 mm |
| estándar zoom | 28-70 mm |
| estándar zoom | 28-105 mm |
| ultrazoom | 28-200 mm |
| ultrazoom | 28-300 mm |
| angular fijo | 30 mm |
| estándar fijo | 50 mm |
| ultrazoom | 50-500 mm |
| tele zoom | 50-150 mm |
| tele zoom | 50-150 mm |
| tele zoom | 50-200 mm |
| estándar fijo | 50 mm |
| tele zoom | 50-500 mm |
| tele zoom | 55-200 mm |
| tele zoom | 70-200 mm |
| tele zoom | 70-300 mm |
| tele zoom | 70-300 mm |
| tele zoom | 70-200 mm |
| tele fijo | 70 mm |
| tele zoom | 70-300 mm |
| tele zoom | 70-200 mm |
| tele zoom | 80-400 mm |
| tele fijo | 85 mm |
| tele zoom | 100-300 mm |
| tele zoom | 100-300 mm |
| tele zoom | 100-300 mm |
| estándar fijo | 105 mm |
| tele zoom | 120-300 mm |
| supertele zoom | 120-400 mm |
| tele zoom | 120-300 mm |
| supertele zoom | 135-400 mm |
| supertele zoom | 135-400 mm |
| tele fijo | 150 mm |
| supertele zoom | 150-500 mm |
| tele fijo | 150 mm |
| supertele zoom | 170-500 mm |
| supertele zoom | 170-500 mm |
| tele fijo | 180 mm |
| supertele zoom | 300-800 mm |
| tele fijo | 300 mm |
| supertele zoom | 500 mm |
| supertele fijo | 600 mm |
79 filas (de 79) seleccionadas
T03.023- Nombre de los artículos cuyo precio sea mayor de 100 pero menor o igual que 200.
| nombre |
|---|
| PowerShot SX130 IS |
| Digital IXUS 130 |
| Digital IXUS 105 |
| PowerShot A3100 IS |
| PowerShot A3000 IS |
| PowerShot SX120 IS |
| Digital IXUS 200 IS |
| PowerShot SX200 IS |
| PowerShot A1100 IS |
| PowerShot A2100 IS |
| PowerShot SX1 IS |
| Digital IXUS 870 IS |
| PowerShot A2000 IS |
| Digital IXUS 960 IS |
| Coolpix S5100 |
| Coolpix S4000 |
| Coolpix S3000 |
| Coolpix S640 |
| 18-50 mm f3.5-5.6 DC (Pentax) |
| 18-200 mm f3.5-6.3 DC (Canon) |
| 18-200 mm f3.5-6.3 DC (Nikon) |
| 55-200 mm f4-5.6 DC (Canon) |
| 55-200 mm f4-5.6 DC (Pentax) |
| 55-200 mm f4-5.6 DC (Minolta) |
| 70-300 mm f4-5.6 Macro APO (Canon) |
| 70-300 mm f4-5.6 Macro APO (Nikon) |
| 70-300 mm f4-5.6 Macro APO (Minolta) |
| 70-300 mm f4-5.6 Macro (Canon) |
| 70-300 mm f4-5.6 Macro (Nikon) |
| 70-300 mm f4-5.6 Macro (Minolta) |
| 70-300 mm f4-5.6 Macro (Pentax) |
| CF 16GB EXTREME PRO |
| CF 32GB EXTREME |
| TS32GCF600 |
| TS16GCF300 |
35 filas (de 35) seleccionadas
T03.024- Nombre de los artículos cuyo precio sea mayor o igual que 100 pero menor o igual que 300.
| nombre |
|---|
| PowerShot SX130 IS |
| Digital IXUS 300 HS |
| PowerShot SX210 IS |
| Digital IXUS 210 IS |
| Digital IXUS 130 |
| Digital IXUS 105 |
| PowerShot A3100 IS |
| PowerShot A3000 IS |
| PowerShot S90 |
| PowerShot SX120 IS |
| PowerShot SX20 IS |
| Digital IXUS 120 IS |
| Digital IXUS 200 IS |
| Digital IXUS 95 IS |
| PowerShot D10 |
| PowerShot SX200 IS |
| PowerShot A1100 IS |
| PowerShot A2100 IS |
| Digital IXUS 100 IS |
| Digital IXUS 110 IS |
| PowerShot G10 |
| PowerShot SX1 IS |
| Digital IXUS 870 IS |
| PowerShot SX110 IS |
| PowerShot A2000 IS |
| Digital IXUS 90 IS |
| Digital IXUS 85 IS |
| PowerShot A590 IS |
| PowerShot A580 |
| Digital IXUS 960 IS |
| PowerShot A650 IS |
| Coolpix S5100 |
| Coolpix S8000 |
| Coolpix S4000 |
| Coolpix S3000 |
| Coolpix L110 |
| Coolpix S1000pj |
| Coolpix S640 |
| 17-70 mm f2.8-4.5 DC Macro (Nikon) |
| 17-70 mm f2.8-4.5 DC Macro (Canon) |
| 17-70 mm f2.8-4.5 DC Macro (Sony) |
| 18-50 mm f3.5-5.6 DC (Pentax) |
| 18-125 mm f3.5-5.6 DC (Canon) |
| 18-125 mm f3.5-5.6 DC (Nikon) |
| 18-200 mm f3.5-6.3 DC (Sony) |
| 18-50 mm f2.8-4.5 DC OS HSM (Canon) |
| 18-50 mm f2.8-4.5 DC OS HSM (Nikon) |
| 18-50 mm f2.8-4.5 DC OS HSM (Sony) |
| 18-200 mm f3.5-6.3 DC |
| 18-200 mm f3.5-6.3 DC (Canon) |
| 18-200 mm f3.5-6.3 DC (Nikon) |
| 18-200 mm f3.5-6.3 DC (Pentax) |
| 28-70 mm f2.8 DG EX (Nikon) |
| 28-300 mm f3.5-6.3 Macro (Nikon) |
| 28-300 mm f3.5-6.3 Macro (Minolta) |
| 28-300 mm f3.5-6.3 Macro (Pentax) |
| 28-300 mm f3.5-5.6 DG Macro (Canon) |
| 28-300 mm f3.5-5.6 DG Macro (Nikon) |
| 50 mm f2.8 DG EX Macro (Canon) |
| 50 mm f2.8 DG EX Macro (Nikon) |
| 50 mm f2.8 DG EX Macro (Minolta) |
| 50 mm f2.8 DG EX Macro (Pentax) |
| 50-200 mm f4-5.6 DC OS HSM (Canon) |
| 50-200 mm f4-5.6 DC OS HSM (Nikon) |
| 50-200 mm f4-5.6 DC OS HSM (Pentax) |
| 55-200 mm f4-5.6 DC (Canon) |
| 55-200 mm f4-5.6 DC (Pentax) |
| 55-200 mm f4-5.6 DC (Minolta) |
| 70-300 mm f4-5.6 Macro APO (Canon) |
| 70-300 mm f4-5.6 Macro APO (Nikon) |
| 70-300 mm f4-5.6 Macro APO (Minolta) |
| 70-300 mm f4-5.6 Macro APO (Pentax) |
| 70-300 mm f4-5.6 Macro (Canon) |
| 70-300 mm f4-5.6 Macro (Nikon) |
| 70-300 mm f4-5.6 Macro (Minolta) |
| 70-300 mm f4-5.6 Macro (Pentax) |
| UE22C4000 |
| CF 16GB EXTREME PRO |
| CF 32GB EXTREME |
| TS32GCF600 |
| TS16GCF300 |
| Megaoferta |
82 filas (de 82) seleccionadas
T03.025- Nombre de las cámaras cuya marca no comience por la letra S.
| nombre |
|---|
| PowerShot SX30 IS |
| PowerShot G12 |
| EOS 60D |
| PowerShot SX130 IS |
| IXUS 1000 HS |
| PowerShot S95 |
| Digital IXUS 300 HS |
| PowerShot SX210 IS |
| Digital IXUS 210 IS |
| Digital IXUS 130 |
| Digital IXUS 105 |
| EOS 550D |
| PowerShot A3100 IS |
| PowerShot A3000 IS |
| PowerShot A495 |
| PowerShot A490 |
| EOS-1D Mark IV |
| EOS 7D |
| PowerShot S90 |
| PowerShot G11 |
| PowerShot SX120 IS |
| PowerShot SX20 IS |
| Digital IXUS 120 IS |
| Digital IXUS 200 IS |
| EOS 500D |
| Digital IXUS 95 IS |
| PowerShot D10 |
| PowerShot SX200 IS |
| PowerShot A1100 IS |
| PowerShot A2100 IS |
| Digital IXUS 100 IS |
| Digital IXUS 110 IS |
| Digital IXUS 990 IS |
| PowerShot A480 |
| EOS 5D Mark II |
| PowerShot G10 |
| PowerShot SX1 IS |
| PowerShot SX10 IS |
| Digital IXUS 870 IS |
| Digital IXUS 980 IS |
| EOS 50D |
| PowerShot SX110 IS |
| PowerShot A2000 IS |
| PowerShot A1000 IS |
| PowerShot E1 |
| EOS 1000D |
| Digital IXUS 970 IS |
| Digital IXUS 90 IS |
| Digital IXUS 85 IS |
| EOS 450D |
| Digital IXUS 80 IS |
| PowerShot A590 IS |
| PowerShot A470 |
| PowerShot A580 |
| Digital IXUS 960 IS |
| PowerShot A720 IS |
| PowerShot A650 IS |
| PowerShot SX100 IS |
| Digital IXUS 860 IS |
| EOS-1Ds Mark III |
| PowerShot G9 |
| EOS 40D |
| Digital IXUS 950 IS |
| PowerShot S5 IS |
| Digital IXUS 70 |
| Digital IXUS 75 |
| PowerShot TX1 |
| PowerShot A560 |
| PowerShot A570 IS |
| EOS-1D Mark III |
| PowerShot A450 |
| PowerShot A460 |
| PowerShot A550 |
| Digital IXUS 850 IS |
| PowerShot G7 |
| Digital IXUS i7 zoom |
| Digital IXUS 900 Ti |
| PowerShot A710 IS |
| PowerShot A630 |
| PowerShot A640 |
| EOS 400D |
| PowerShot S3 IS |
| EOS 30D |
| Digital IXUS 60 |
| Digital IXUS 65 |
| Digital IXUS 800 IS |
| PowerShot A420 |
| PowerShot A430 |
| PowerShot A530 |
| PowerShot A540 |
| PowerShot A700 |
| Digital IXUS Wireless |
| PowerShot A620 |
| PowerShot A610 |
| PowerShot A410 |
| PowerShot S80 |
| EOS-1D Mark II N |
| EOS 5D |
| Digital IXUS 750 |
| Digital IXUS 55 |
100 filas (de 295) seleccionadas
T03.026- Dirección de correo de los usuarios cuyo dni termine en B, L o P.
| jmc@emtj.cof |
| kcdltb@colegas.com |
| jps@lamail.ar |
| jcf@upa.ej |
| mgs@colegas.com |
| jlag@bitoben.mus.es |
| mpfh@emtj.cof |
| mrm@agwab.com |
| jme@colegas.com |
| rcr@colegas.com |
| coc@cazurren.ma.de |
| fms@colegas.com |
| wgh@colegas.com |
| mam@lolipop.com |
| srl@upa.ej |
| bgc@agwab.com |
| acs@emtj.cof |
| pgsj@colegas.com |
| etp@colegas.com |
| acl@emtj.cof |
| amp@colegas.com |
| ldg@upa.ej |
| acm@upa.ej |
| aam@colegas.com |
| jccf@eps.upa.ej |
| lrdn@colegas.com |
| mfds@eps.upa.ej |
| mnrg@eps.upa.ej |
| cca@upa.ej |
29 filas (de 29) seleccionadas
T03.027- Código de los televisores que tengan un panel LCD o LED.
| cod |
|---|
| A0686 |
| A0688 |
| A0689 |
| A0690 |
| A0691 |
| A0692 |
| A0693 |
| A0694 |
| A0695 |
| A0696 |
| A0697 |
| A0698 |
| A0699 |
| A0700 |
| A0701 |
| A0702 |
| A0704 |
| A0705 |
| A0706 |
| A0708 |
| A0709 |
| A0710 |
| A0711 |
| A0714 |
| A0715 |
| A0716 |
| A0717 |
| A0718 |
| A0721 |
| A0722 |
| A0723 |
| A0724 |
| A0727 |
| A0728 |
| A0729 |
| A0730 |
| A0731 |
| A0732 |
| A0734 |
| A0735 |
| A0736 |
| A0738 |
| A0739 |
| A0741 |
| A0743 |
| A0744 |
| A0745 |
| A0746 |
| A0747 |
| A0748 |
| A0749 |
| A0758 |
| A0759 |
| A0760 |
| A0761 |
| A0762 |
| A0763 |
| A0764 |
| A0765 |
| A0766 |
| A0767 |
| A0768 |
| A0772 |
| A0773 |
| A0774 |
| A0775 |
| A0776 |
| A0777 |
| A0778 |
| A0779 |
| A0780 |
| A0781 |
| A0782 |
| A0783 |
| A0784 |
| A0785 |
| A0786 |
| A0787 |
| A0788 |
| A0789 |
| A0790 |
| A0791 |
| A0792 |
| A0793 |
| A0794 |
| A0795 |
| A0796 |
| A0797 |
| A0798 |
| A0799 |
| A0800 |
| A0801 |
| A0802 |
| A0803 |
| A0804 |
| A0805 |
| A0806 |
| A0807 |
| A0808 |
| A0809 |
100 filas (de 487) seleccionadas
T03.029- Nombre de los televisores que tengan una pantalla mayor que el televisor de código A0686.
| nombre |
|---|
| 60PG3000 |
| 60PC45 |
| 60PF95 Chocolate |
| MW-71PY10 |
| 60PY2R |
| Bravia KDL-60LX900 |
| Bravia KDL-70X3500 |
| Bravia KDS-70R2000 |
| PS63A756 |
| PS63P76FD |
| LE70F96BD |
| PS63P5H |
12 filas (de 12) seleccionadas
T03.035- Nombre de los artículos que hayan sido seleccionados en alguna cesta con fecha entre 01.11.2010 y 31.12.2010
| nombre |
|---|
| PowerShot A460 |
| 55LE8500 |
| 32PG6000 |
| Bravia KDL-37EX402 |
| 32PFL7603D/10 |
| UE40C6510 |
| UE46C7000 |
7 filas (de 7) seleccionadas
T03.036- Nombre de los artículos que hayan sido seleccionados en alguna cesta por usuarios de las provincias de Valencia o Alicante.
| nombre |
|---|
| Digital IXUS 200 IS |
| EOS 1000D |
| 17-70 mm f2.8-4 DC OS HSM Macro (Canon) |
| 55LE8500 |
| 32PG6000 |
| Bravia KDL-37EX402 |
| UE46C7000 |
7 filas (de 7) seleccionadas
T03.037- Número identificador de los pedidos en los que se han incluido artículos a un importe menor que su pvp, eliminando duplicados.
| numpedido |
|---|
| 1 |
| 2 |
| 6 |
| 9 |
| 12 |
| 13 |
| 22 |
| 27 |
| 28 |
| 29 |
| 31 |
| 34 |
| 36 |
| 40 |
| 41 |
| 42 |
| 43 |
| 45 |
| 48 |
| 14 |
| 20 |
| 23 |
| 30 |
| 35 |
| 44 |
| 47 |
| 50 |
| 3 |
| 5 |
| 24 |
| 38 |
| 39 |
| 46 |
33 filas (de 33) seleccionadas
T03.038- Número de pack, nombre y precio del mismo, y código, nombre y marca de los artículos que pertenezcan a ellos.
| cod | nombre | pvp | art2 | nombre2 | marca |
|---|---|---|---|---|---|
| A0685 | Pack Foto | 3699.00 | A0070 | EOS-1D Mark III | Canon |
| A0685 | Pack Foto | 3699.00 | A0528 | 50-150 mm f2.8 II EX DC APO HSM (Canon) | Sigma |
| A1234 | Pack FOTO 2 | 1499.99 | A0200 | D3100 | Nikon |
| A1234 | Pack FOTO 2 | 1499.99 | A0349 | 17-35 mm f2.8-4 DG EX HSM (Nikon) | Sigma |
| A1234 | Pack FOTO 2 | 1499.99 | A0557 | 70-200 mm f2.8 DG EX HSM (Nikon) | Sigma |
| A1234 | Pack FOTO 2 | 1499.99 | A1290 | SDHC-SD4/32GB | KINGSTON |
| A1291 | Megaoferta | 299.99 | A0023 | Digital IXUS 120 IS | Canon |
| A1291 | Megaoferta | 299.99 | A0027 | PowerShot D10 | Canon |
| A1291 | Megaoferta | 299.99 | A0037 | PowerShot SX1 IS | Canon |
9 filas (de 9) seleccionadas