SELECT nom, `tx_tmguidetri_domain_model_matiere`.`uid` AS `uid`, `tx_tmguidetri_domain_model_matiere`.`pid` AS `pid`, `tx_tmguidetri_domain_model_matiere`.`t3ver_state` AS `t3ver_state` FROM `tx_tmguidetri_domain_model_matiere` WHERE (`tx_tmguidetri_domain_model_matiere`.`pid` IN (1465)) AND (find_in_set('Verre de caf�� ou de th�� (en carton)',synonymes)>0 OR nom LIKE '%Verre de caf�� ou de th�� (en carton)%') AND (`tx_tmguidetri_domain_model_matiere`.`sys_language_uid` IN (0, -1)) AND ((`tx_tmguidetri_domain_model_matiere`.`deleted` = 0) AND (`tx_tmguidetri_domain_model_matiere`.`t3ver_state` <= 0) AND (`tx_tmguidetri_domain_model_matiere`.`pid` <> -1) AND (`tx_tmguidetri_domain_model_matiere`.`hidden` = 0) AND (`tx_tmguidetri_domain_model_matiere`.`starttime` <= 1670213580) AND ((`tx_tmguidetri_domain_model_matiere`.`endtime` = 0) OR (`tx_tmguidetri_domain_model_matiere`.`endtime` > 1670213580))) ORDER BY `nom` ASC