---

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='147')
    -- LEFT JOIN users ON(users.id = certifications.created_by)
    WHERE 1  AND certifications.id IN(50,4,5,16,55,54,53,14,7,17,69,2) AND (certifications.created_by IN(0, 147) OR certifications.created_by IS NULL) GROUP BY certifications.id ORDER BY certifications.title ASC

 

Better Cotton Initiative (BCI)

 

BSCI

 

CTPAT

 

FPCCI

 

ISO 14001 2015 EMS

 

ISO 1828 bureau veritas

 

ISO 45001 2018 OHSAS

 

ISO 9001 2015 QMS

 

ISO 9001:2008

 

KCCI

 

oekotex-100

 

WRAP