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
7277HNR
TMAPU81SADJ112423
Hyundai ix20
iX20 1.6 CRDI BLUED COMFORT 115CV
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
4058JYY
TMBEB6NJ8HZ152085
Skoda Fabia
FABIA 1.0 MPI Ambition 75
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
CNP8504RR
VF7BU9HD8EZ905606
Citroën C4
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
38194
38194
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
5259GWX
XMZXNZ32A9F068244
Mitsubishi Colt
COLT 1.1 12v Inform
66 €
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
7116GVH
XMCXNZ32A9F061198
Mitsubishi Colt
COLT 1.1 12v Inform
80 €
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
5779KRT
VF7YCTMFC12881367
Citroën Jumper
Jumper 35 L3H2 E-HDI 130 BUSINESS
455 €
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
7311GRG
WVWZZZ1KZAP053022
Volkswagen Golf VI
GOLF VI 2.0 TDI CR Advance 140 5p
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
CB360ZM
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
CB360ZM
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
CNP2295RP
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
DT040DZ
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
9729KJV
VF7UDRHB8DJ642918
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
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
6477KDG
VF1BT3H0647906043
Renault Laguna
LAGUNA 2.0 Dynamique
350 €
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
1FVS473
WAUZZZ4G2EN067103
Audi A7 Sportback
A7 Sportback 3.0 TDI Multitronic
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
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
1653KRK
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
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
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
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
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
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
5077KRW
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
4882KRP
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
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-