Warranty Registration

SELECT tree_node.*, tree_node.last_update as tree_node_last_update, translation_name_fr.content AS name_fr, translation_name_en.content AS name_en, boa_stain.*, boa_stain.last_update as boa_stain_last_update FROM boa_stain INNER JOIN tree_node ON boa_stain.cp = tree_node.cp LEFT JOIN translation as translation_name_fr ON (translation_name_fr.cp = tree_node.name AND  translation_name_fr.language = 'fr') LEFT JOIN translation as translation_name_en ON (translation_name_en.cp = tree_node.name AND  translation_name_en.language = 'en') WHERE parent != '904c6e5701621a78b00b80a2cd178b46' AND usable = 1  ORDER BY name_en ASC