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 40
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 40
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 40
5276GWX
XMCXNZ32A9F068853
Mitsubishi Colt
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 40
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 40
9347GXN
XMCXNZ32A9F070079
Mitsubishi Colt
COLT 1.1 12v Inform
105 €
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 40
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 40
DX389BX
WDD2052121F292717
Mercedes C 300
C 300 Estate BT HYBRID (CO2 99)(S205)
210 €
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 40
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 40
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 40
3752KMW
VF7UDRHB8DJ630948
Citroën C4 Picasso
C4 PICASSO 2.0 HDI Millenium CMP 150
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 40
2934GNH
XMCXNZ32A9F036678
Mitsubishi Colt
COLT 1.1 12v Inform
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 40
6665HMF
ZFA19900000857730
Fiat Punto
Punto Van 1.3 Multijet 75Cv E5
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 40
3005KMK
VF7UDRHB8DJ634202
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 40
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 40
3018HKB
6FPPXXMJ2PCB29429
Ford Ranger
Ranger 2.2 TDCi 150Cv 4x4 Doble Cabina XL
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 40
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 40
8284KNK
WAUZZZ8K5FA040503
Audi A4 Avant
A4 AVANT 2.0 TDI DPF Advanced Ed. 136
210 €
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 40
ES213EZ
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 40
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 40
DN432JX
VF7YASMFB12729508
Citroën Jumper
175 €
Talleres Murillo