Denumiri piese
core_mysql (error no: 1030) : Got error 28 from storage engine
SELECT c.TYP_PCON_START, c.TYP_PCON_END, h.MAKENAME, g.RANGENAME, e.TYPENAME, c.TYP_HP_FROM, c.TYP_CCM, c.TYP_KW_FROM, d.TCDTYPE,
f.TCDRANGE, i.TCDMAKE,
i.MAKEID, f.RANGEID, d.TYPEID
FROM tecdoc_tof_link_la_typ a,
tecdoc_tof_link_art b,
tecdoc_tof_types c,
audacon_tb_treetype d,
audacon_tb_treetypetext e,
audacon_tb_treerange f,
audacon_tb_treerangetext g,
audacon_tb_treemaketext h,
audacon_tb_treemake i
WHERE d.SHOWASCAR = 1 AND
a.LAT_LA_ID = b.LA_ID AND
c.TYP_ID = a.LAT_TYP_ID AND
d.TCDTYPE = c.TYP_ID AND
e.TYPEID = d.TYPEID AND
(e.COUNTRYID = 50 OR e.COUNTRYID = 0) AND
f.RANGEID = d.RANGEID AND
g.RANGEID = d.RANGEID AND
h.MAKEID = f.MAKEID AND
i.MAKEID = f.MAKEID AND
b.LA_ART_ID = "1"
GROUP BY d.TYPEID
LIMIT 1000