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
1HJH301
WVWZZZ7NZEV002630
Volkswagen Sharan
SHARAN 2.0 TDI Advance BMT 140
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
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
CNP2281RP
VF7UDRHB8DJ651529
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
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
5512GND
XMCMNZ34A9F003929
Mitsubishi Colt
COLT 1.3 ClearTec Intense - 3p
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
CNP2168RP
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
5512GND
XMCMNZ34A9F003929
Mitsubishi Colt
COLT 1.3 ClearTec Intense - 3p
140 €
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
6536GNJ
XMCXNZ32A9F037344
Mitsubishi Colt
COLT 1.1 12v Inform
99 €
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
9003KJX
WBA1C11040VV08441
BMW 118
118 d Essential Plus Edition Aut. - 5p (F20)
200 €
EXTREMOTOR

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
8050GNK
XMCXNZ32A9F037552
Mitsubishi Colt
COLT 1.1 12v Inform
175 €
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
8047GNK
XMCXNZ32A9F037478
Mitsubishi Colt
COLT 1.1 12v Inform
175 €
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
1HJH301
WVWZZZ7NZEV002630
Volkswagen Sharan
SHARAN 2.0 TDI Advance BMT 140
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
3605KGD
WVGZZZ1TZDW056134
Volkswagen Touran
Touran 1.6 TDi 105 DSG7 Trendline Business BMT
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
9307GXN
XMCXNZ32A9F070219
Mitsubishi Colt
COLT 1.1 12v Inform
45 €
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
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
0168KPP
WVWZZZ3CZFP415901
Volkswagen Passat Variant
PASSAT VARIANT 2.0 TDI BMT Edition 150
185 €
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
CL117KN
WBA1C11030VU90255
BMW 118
118 d Essential Plus Edition - 5p (F20)
450 €
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
1HJH301
WVWZZZ7NZEV002630
Volkswagen Sharan
SHARAN 2.0 TDI Advance BMT 140
80 €
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
46XXS2
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
CR401DX
WBA3E11090J708869
BMW 320 d
320 d Efficient Dynamics Edition Essential Plus(F30)
485 €
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
1EAV660
WVWZZZ7NZDV011340
Volkswagen Sharan
SHARAN 2.0 TDI Edition BMT
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
6711GNJ
XMCXNZ32A9F037222
Mitsubishi Colt
210 €
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
2981GXG
KL1SF48DJAB122277
Chevrolet Aveo
AVEO 1.2 16v LS (5p)
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
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
8322KNK
WAUZZZ8V6DA068673
Audi A3 Sportback
A3 Sportback 2.0 TDI Ambition - Ambiente
260 €
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-

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
2613KNW
VF7YASMFB12729508
Citroën Jumper
175 €
Talleres Murillo