JavaScript seems to be disabled in your browser.
You must have JavaScript enabled in your browser to utilize the functionality of this website.

Pakistan Chemical Manufacturers Association

Most Viewed Business Sectors

SELECT SQL_CALC_FOUND_ROWS sectors.id
        , sectors.title
         , sectors.image
        , customer_sectors.id AS rel_id
         , customer_sectors.image AS customer_image
         , sectors.description
         , sectors.keywords
         , sectors.created_by
         , IF(customer_sectors.ordering > 0, customer_sectors.ordering, sectors.ordering) AS ordering
                -- , CONCAT_WS(' ', users.first_name, users.last_name) AS created_by
FROM sectors
LEFT JOIN customer_sectors ON(customer_sectors.sector_id = sectors.id )
        -- LEFT JOIN users ON(users.id = sectors.created_by)
WHERE 1  GROUP BY sectors.id ORDER BY RAND()