SELECT D.category AS cat, C.id AS sid, A.id AS shid, B.id AS pid FROM w_shamail_data AS A
LEFT JOIN w_princess AS B ON A.princess = B.id
LEFT JOIN w_facilities AS C ON B.shop = C.id
LEFT JOIN w_category AS D ON C.category = D.id
 WHERE A.id = 134410

が実行できませんでした。理由：<br>