---

TMA

SELECT SQL_CALC_FOUND_ROWS certifications.id
        , certifications.title
         , certifications.image
         , certifications.keywords
         , certifications.description
         , certifications.created_by
         , IF(customer_certifications.ordering > 0, customer_certifications.ordering, certifications.ordering) AS ordering
                -- , CONCAT_WS(' ', users.first_name, users.last_name) AS created_by
    FROM certifications
    LEFT JOIN customer_certifications ON(customer_certifications.certification_id = certifications.id  AND customer_id='469')
    -- LEFT JOIN users ON(users.id = certifications.created_by)
    WHERE 1  AND certifications.id IN(57,21,62,50,4,8,17,63,9,69,13,48,46,60,64) AND (certifications.created_by IN(0, 469) OR certifications.created_by IS NULL) GROUP BY certifications.id ORDER BY certifications.title ASC

 

Amfori

 

Amfori

 

APTMA

 

Better Cotton Initiative (BCI)

 

BSCI

 

GOTS

 

GRS

 

KCCI

 

OCS

 

OEKO-TEX

 

oekotex-100

 

RCS

 

SEDEX

 

STeP by OEKO-TEX

 

UKAS-Accredited ISO Certification