SELECT DISTINCT
a.*,
h.name as hersteller,
h.img as hersteller_img
FROM
shop4_artikel a,
shop4_artikel_kategorie ak,
shop4_kategorie k,
shop4_hersteller h
WHERE
a.public IN(1)
AND k.id=ak.kategorie_id
AND a.id=ak.artikel_id
AND a.shop_id='1'
AND a.schleife='bestseller.gif'
AND a.hersteller_id=h.id
ORDER BY
RAND()
LIMIT 9
Got error 28 from storage engine
SELECT DISTINCT
a.*,
h.name as hersteller,
h.img as hersteller_img
FROM
shop4_artikel a,
shop4_artikel_kategorie ak,
shop4_kategorie k,
shop4_hersteller h
WHERE
a.public IN(1)
AND k.id=ak.kategorie_id
AND a.id=ak.artikel_id
AND a.shop_id='1'
AND a.hersteller_id=h.id
AND ak.kategorie_id='8329'
ORDER BY
h.name,
a.bezeichnung_de
LIMIT 0,12