Towel Manufacturers Association of Pakistan

ARTISTIC TOWEL MILLS

Welcome to TMA B2b Exchange Gateway!

Premium Subscription Premium Plus

About Artistic Towel Mills Read more

Company Name: Artistic Towel Mills

Artistic Towel Mills. Artistic is well known as a manufacturer & exporter of superior quality terry towels, bath robes & allied terry products, directly working with the leading importers, retailers & whole sellers, in Europe and USA.

Member Product Line view more

Baby hooded Towel
Baby Towels
Striped Towel
Ribbed Towel

Member Tech Line view more

Dyeing Setup-Continuous Dyeing
Warping Machine
Weaving

Member Certification view more

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 )
    -- LEFT JOIN users ON(users.id = certifications.created_by)
    WHERE 1  AND certifications.id IN(17) GROUP BY certifications.id ORDER BY certifications.id DESC LIMIT 0, 3