---

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='34')
    -- LEFT JOIN users ON(users.id = certifications.created_by)
    WHERE 1  AND certifications.id IN(4,8,16,5,9,13,48,49,50,51,52,54,53,55,60,63,17,7,69) AND (certifications.created_by IN(0, 34) OR certifications.created_by IS NULL) GROUP BY certifications.id ORDER BY certifications.title ASC

 

Better Cotton Initiative (BCI)

 

BSCI

 

CTPAT

 

Egyptian Cotton

 

FPCCI

 

GOTS

 

GRS

 

ISO 14001 2015 EMS

 

ISO 45001 2018 OHSAS

 

ISO 9001 2015 QMS

 

ISO 9001:2008

 

KCCI

 

OCS

 

OEKO-TEX

 

oekotex-100

 

SEDEX

 

STeP by OEKO-TEX

 

Workplace Condition Assessment (WCA)