Платформа StreamDat

SELECT `modx_products_certificates`.`code`, `modx_products_certificates`.name, `tb_cert`.`id`, `tb_cert`.`nameLink`, `tb_cert`.`title`, `tb_cert`.`descr`, `tb_cert`.`nameProducts`, `tb_cert`.`hashName`, `modx_products_certificates`.`pos` AS `prod_cert`, `modx_type_certificates`.`pos` AS `type_sort`, `tb_cert`.`pos` AS `cert_sort` FROM `modx_products_certificates` RIGHT JOIN `modx_certificates` as `tb_cert` ON `code` REGEXP CONCAT("(^|,)", REPLACE(`nameProducts`, ",", "|"), "(,|$)") RIGHT JOIN `modx_type_certificates` ON `type` = `modx_type_certificates`.`id` WHERE `nameProducts` REGEXP "(^|,)streamdat(,|$)" AND `code` REGEXP "(^|,)streamdat(,|$)" AND `groups` REGEXP "(^|,)(prog)(,|$)" GROUP BY `tb_cert`.`id` ORDER BY `modx_type_certificates`.`pos` ASC, `tb_cert`.`pos` ASC