Inicio > EMBRAGUES > EMBRAGUES
DETALLES
MarcaCORVEN EMBRAGUES
Aplicacion 1.9 D, 1.8 D - 1.9 D / SD, 1.8 D - 1.9 D
Desde 1998
Marca Vehículo PEUGEOT, CITROEN
Modelo PARTNER, 306, XSARA PICASSO, XSARA, BERLINGO
Descripción del producto
-

SELECT mg.*, mbt.type FROM mods_groups mg LEFT JOIN mods_block_types AS mbt on mg.block_type_id = mbt.id WHERE mg.group_key like 'POPUP_INICIO' AND mg.enabled = 1 AND mg.screen_type = 1 AND (IF(mbt.is_banner = 0, 1, (SELECT count(1) AS cantidad FROM banners b WHERE b.group_id = mg.id AND b.status= 1)) ) > 0

[TEP STOP]

 -

select count(1) as total from sessions where sesskey = ''

[TEP STOP]