Safety and Risk Management
SELECT *
FROM `product`
INNER JOIN product_pricing ON pricing_product_id = product_id
INNER JOIN country ON product_country_id=country.iso
WHERE product_published = '1' AND product_latest = '1' AND
(
product_subject_id LIKE '3,%'
OR product_subject_id LIKE '%,3,%'
) GROUP BY product_id ORDER BY product_ordering ASC
SELECT *
FROM `product`
INNER JOIN product_pricing ON pricing_product_id = product_id
INNER JOIN country ON product_country_id=country.iso
WHERE product_published = '1' AND product_latest = '1' AND
(
product_subject_id LIKE '1,%'
OR product_subject_id LIKE '%,1,%'
) GROUP BY product_id ORDER BY product_ordering ASC
SELECT *
FROM `product`
INNER JOIN product_pricing ON pricing_product_id = product_id
INNER JOIN country ON product_country_id=country.iso
WHERE product_published = '1' AND product_latest = '1' AND
(
product_subject_id LIKE '8,%'
OR product_subject_id LIKE '%,8,%'
) GROUP BY product_id ORDER BY product_ordering ASC
Quality and Compliance Monitoring
SELECT *
FROM `product`
INNER JOIN product_pricing ON pricing_product_id = product_id
INNER JOIN country ON product_country_id=country.iso
WHERE product_published = '1' AND product_latest = '1' AND
(
product_subject_id LIKE '2,%'
OR product_subject_id LIKE '%,2,%'
) GROUP BY product_id ORDER BY product_ordering ASC
SELECT *
FROM `product`
INNER JOIN product_pricing ON pricing_product_id = product_id
INNER JOIN country ON product_country_id=country.iso
WHERE product_published = '1' AND product_latest = '1' AND
(
product_subject_id LIKE '7,%'
OR product_subject_id LIKE '%,7,%'
) GROUP BY product_id ORDER BY product_ordering ASC
SELECT *
FROM `product`
INNER JOIN product_pricing ON pricing_product_id = product_id
INNER JOIN country ON product_country_id=country.iso
WHERE product_published = '1' AND product_latest = '1' AND
(
product_subject_id LIKE '13,%'
OR product_subject_id LIKE '%,13,%'
) GROUP BY product_id ORDER BY product_ordering ASC
SELECT *
FROM `product`
INNER JOIN product_pricing ON pricing_product_id = product_id
INNER JOIN country ON product_country_id=country.iso
WHERE product_published = '1' AND product_latest = '1' AND
(
product_subject_id LIKE '14,%'
OR product_subject_id LIKE '%,14,%'
) GROUP BY product_id ORDER BY product_ordering ASC
SELECT *
FROM `product`
INNER JOIN product_pricing ON pricing_product_id = product_id
INNER JOIN country ON product_country_id=country.iso
WHERE product_published = '1' AND product_latest = '1' AND
(
product_subject_id LIKE '15,%'
OR product_subject_id LIKE '%,15,%'
) GROUP BY product_id ORDER BY product_ordering ASC
To understand more about how we run our in company courses Click Here
To understand more about how we run our Open Courses Click Here
All of our courses can be adapted and presented to you at your own office or facility. Please call us for more details on
Tel: +44 (0)1276 859519 or email
training@bainessimmons.com