I link a crash report, it append everytime I exec this kind of request.
Another query :
Query (0x5645a0188020): SELECT p.`id_product`, product_shop.`condition`, p.`id_manufacturer`, sa.`quantity`, p.`weight`

FROM cj_product p INNER JOIN cj_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)

INNER JOIN cj_category_product cp ON (cp.id_product = p.id_product)
INNER JOIN cj_category c ON (c.id_category = cp.id_category AND
c.nleft >= 4
AND c.nright <= 5
AND c.active = 1) LEFT JOIN `cj_stock_available` sa
ON (sa.id_product = p.id_product AND sa.id_shop = 1)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_product IN (SELECT id_product FROM cj_feature_product fp WHERE fp.`id_feature_value` = 605) AND p.id_product IN (SELECT id_product FROM cj_feature_product fp WHERE fp.`id_feature_value` = 562 OR fp.`id_feature_value` = 558) AND p.id_product IN (SELECT id_product FROM cj_feature_product fp WHERE fp.`id_feature_value` = 338)
GROUP BY p.id_product

I can reproduce the bug by running it in PhpMyAdmin :
If I remove the LEFT here : "LEFT JOIN `cj_stock_available`". The query don't crash the server.
I repaired the table with
mysqlcheck -u USER -p --check -A --auto-repair
But same problem.