SELECT i.*,il.titulo,il.mini,il.descripcion,c.categoria,c.url,c.portada FROM items i LEFT JOIN categorias c ON i.id_categoria=c.id LEFT JOIN items_lang il ON i.id=il.id_item AND il.id_lang='1' WHERE i.id='18' AND i.activo='1'
Type of engine: Automatic Nº of Places: 5 Inside : Leather seats Franchise: 2.000 € Full Insurance: 50 €/ day **