Menú

LISTADO REVISIÓN EXPOSICIÓN / ALBARÁN CHAPA-PINTURA

SELECT car_ficha.car_matricula, car_ficha.car_chasis, car_ficha.car_id, marca_ficha.marca_nombre as marca , modelo_ficha.modelo_modelo as modelo, boe_ficha.boe_modelo_version as version, localizacion_ficha.localizacion_nombre, revision_ficha.revision_id, revision_ficha.empresa_id, revision_ficha.revision_pvp, revision_ficha.revision_check, revision_ficha.revision_foto, empresa_ficha.empresa_nombre FROM revision_ficha LEFT OUTER JOIN car_ficha ON revision_ficha.car_id=car_ficha.car_id LEFT OUTER JOIN marca_ficha ON car_ficha.marca_id =marca_ficha.marca_id LEFT OUTER JOIN modelo_ficha ON car_ficha.modelo_id =modelo_ficha.modelo_id LEFT OUTER JOIN boe_ficha ON car_ficha.boe_id =boe_ficha.boe_id LEFT OUTER JOIN empresa_ficha ON revision_ficha.empresa_id =empresa_ficha.empresa_id LEFT OUTER JOIN localizacion_ficha ON revision_ficha.localidad_id=localizacion_ficha.localizacion_id WHERE revision_ficha.empresa_id!='' AND revision_ficha.revision_check=1 AND (car_ficha.car_estado!=5 OR car_ficha.car_comercial!=5) ORDER by revision_fechaout DESC

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
CNP8528RR
VF7BU9HD8EZ905701
Citroën C4 Aircross
C4 Aircross 1.6 HDI Seduction 2WD 115
40 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
5313KMK
VF7UDRHB8DJ642916
Citroën C4 Picasso
C4 PICASSO 2.0 HDI Millenium CMP 150
30 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
0080DKX
Renault Trafic
Trafic 2.5dCi Combi8 CN 140
30 €
Talleres Ernesto

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
7744JCH
SJNFAAJ11U1278625
Nissan Qashqai 1.5
Qashqai 1.5 dCi S&S Acenta 4x2
160 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
2123HBM
WAUZZZ4G9BN008500
Audi A7 Sportback
A7 Sportback 3.0 TDI Quattro S-T 245
320 €
Talleres Motosprint

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
0464FVY
Audi A6 Avant
A6 Avant A6 AVANT 2.7 TDI Multitronic DPF S-Line
40 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
CNP2023RR
VF73D9HC8EJ655690
Citroën C4 Picasso
C4 Picasso 1.6 e-HDI 115CV ETG6 Seduction
500 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
CNP2146RR
VF73D9HC8EJ662995
Citroën C4 Picasso
C4 Picasso 1.6 e-HDI 115CV ETG6 Seduction
500 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
CNP2145RR
VF73D9HC8EJ662994
Citroën C4 Picasso
C4 Picasso 1.6 e-HDI 115CV ETG6 Seduction
500 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
9675HSK
VF1FW14C549387886
Renault Kangoo
Kangoo Professional 1.5 DCi 75Cv
120 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
CD912PH
VF1JLA4AACY447432
Renault Trafic
80 €
TALLERES LOIMA

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
7179KBV
W0LGM6EL0D1010065
Opel Insignia
Insignia 2.0 CDTi Selective 130 4p-5p
160 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
2819KTL
WV1ZZZ2EZD6011468
Volkswagen Crafter
Crafter 2.0 TDI 163 35 L2H2
160 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
CNP2070RP
VF7UDRHB8DJ632599
Citroën C4 Picasso
C4 PICASSO 2.0 HDI Millenium CMP 150
600 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
1561KRW
WBAXX310400P90507
BMW X4
X4 xDrive 30d - - - - - - - - (F26)
120 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
CNP2136RR
VF73D9HC8EJ662985
Citroën C4 Picasso
C4 Picasso 1.6 e-HDI 115CV ETG6 Seduction
500 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
CNP2115RR
VF73D9HC8EJ662964
Citroën C4 Picasso
C4 Picasso 1.6 e-HDI 115CV ETG6 Seduction
500 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
CNP2112RR
VF73D9HC8EJ662961
Citroën C4 Picasso
C4 Picasso 1.6 e-HDI 115CV ETG6 Seduction
500 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
CNP2150RR
VF73D9HC8EJ666330
Citroën C4 Picasso
C4 Picasso 1.6 e-HDI 115CV ETG6 Seduction
500 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
8355GRW
IVECO Daily City Camión
DAILY CITY CAMIÓN Com.9 29L14CTra. 3000CRS 7.3 Ataq.
30 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
0000AAA
CHASISHCHASISCHASISC
Abarth 500
500 1.4 T-Jet
2 €
Novacentro

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
0000AAA
CHASISHCHASISCHASISC
Abarth 500
500 1.4 T-Jet
Novacentro

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
CNP8504RR
VF7BU9HD8EZ905606
Citroën C4 Aircross
C4 Aircross 1.6 HDI Seduction 2WD 115
500 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
2781KTL
WV1ZZZ2EZC6030154
Volkswagen Crafter
Crafter 50A BM TN 163CV
30 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
2781KTL
WV1ZZZ2EZC6030154
Volkswagen Crafter
Crafter 50A BM TN 163CV
330 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
0279KSJ
VF7UDRHB8DJ653796
Citroën C4 Picasso
C4 PICASSO 2.0 HDI Millenium CMP 150
500 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
5125KTP
WBA2C31030V468952
BMW 220
220 d Active Tourer Advantage Aut. (F45)
70 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
1571KHG
WBA6A61000DY87811
BMW 640 d
640 d Gran Coupé(F06)
70 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
4741KBH
VF3YD3MFC12D93157
Peugeot Boxer
Boxer Furgon 435 L4 H3 2.0 HDI 163Cv
385 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
6320GXK
WBAFW31000C557611
BMW 525 d
525 d Aut. (F10)
40 €
GUISATEC MOTOR. SL-

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
1640KRK
VF7UDRHB8DJ642913
Citroën C4 Picasso
C4 PICASSO 2.0 HDI Millenium CMP 150
500 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
1121HHB
W0LGS6EM2C1013496
Opel Insignia
INSIGNIA 2.0CDTI Sport 160 4p-5p
40 €
Talleres Ernesto

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
4994KTP
WAUZZZ8K9DA120304
Audi A4
A4 2.0 TDI 136Cv Advanced Edition
80 €
Talleres Ernesto

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
6320GXK
WBAFW31000C557611
BMW 525 d
525 d Aut. (F10)
40 €
GUISATEC MOTOR. SL-

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
4441GXJ
XMCXNZ32A9F070066
Mitsubishi Colt
COLT 1.1 12v Inform
30 €
GUISATEC MOTOR. SL-

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
4629GXJ
XMCXNZ32A9F069541
Mitsubishi Colt
35 €
Talleres Murillo

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
5280GWX
XMCXNZ32A9F068837
Mitsubishi Colt
COLT 1.1 12v Inform
30 €
GUISATEC MOTOR. SL-

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
4160KMP
WVWZZZ7NZDV028722
Volkswagen Sharan
SHARAN 2.0 TDI Advance BMT 140
50 €
Talleres Ernesto

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
5224KNX
WAUZZZ8K7DA254681
Audi A4 Allroad Quattro
A4 Allroad Quattro 2.0 TDI 177 (2013)
90 €
TALLERES LOIMA

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /usr/home/cochegestion/www/include/inc_sql.php on line 37
6320GXK
WBAFW31000C557611
BMW 525 d
525 d Aut. (F10)
30 €
GUISATEC MOTOR. SL-