-
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='35')
-- LEFT JOIN users ON(users.id = certifications.created_by)
WHERE 1 AND certifications.id IN(2,3,4,5,11,6,8,7,9,10,29,31,34,33,35,32,36,13,30,37,61,60,50,62) AND (certifications.created_by IN(0, 35) OR certifications.created_by IS NULL) GROUP BY certifications.id ORDER BY certifications.title ASC
Amfori
Better Cotton Initiative (BCI)
BSCI
CTPAT
DETOX
FDA
GOTS
GRS
GSV
GSV
Higg index
ISO
ISO 14001 TUV NORD
ISO 9001 TUV NORD
ISO 9001:2008
OEKO-TEX
SCAN
SEDEX
WCA
WRAP