database error
SELECT
orchids.id as id,
orchids.nom as nom,
orchids_image.url as image
FROM
orchids,
catalogue_index
LEFT JOIN
orchids_image
ON
orchids_image.id_orchids = orchids.id
WHERE
orchids.id = catalogue_index.id_orchids
GROUP BY
orchids.id
ORDER BY
catalogue_index.ordre