---

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='15')
    -- LEFT JOIN users ON(users.id = certifications.created_by)
    WHERE 1  AND certifications.id IN(7,9,4,22,3,8,2,5,13,43,44,50,52,55,54,48,11,10,79) AND (certifications.created_by IN(0, 15) OR certifications.created_by IS NULL) GROUP BY certifications.id ORDER BY certifications.title ASC

 

Better Cotton Initiative (BCI)

 

BSCI

 

Cradle to Cradle

 

CTPAT

 

Egyptian Cotton

 

Egyptian Cotton Association

 

FSC

 

GOTS

 

ISO 14001 2015 EMS

 

ISO 14001 TUV NORD

 

ISO 45001

 

ISO 9001 2015 QMS

 

ISO 9001 TUV NORD

 

ISO 9001:2008

 

OEKO-TEX

 

SEDEX

 

STeP by OEKO-TEX

 

WRAP