SELECT pg_header_pics.*, part_groups.desc_en
FROM pg_header_pics
LEFT JOIN part_groups
ON part_groups.catalog = pg_header_pics.catalog
AND part_groups.part_group = pg_header_pics.part_group
WHERE pg_header_pics.catalog = 'JP'
AND pg_header_pics.catalog_code = '431110'
AND pg_header_pics.main_group = '1';
SELECT pg_header_pics.*, part_groups.desc_en
FROM pg_header_pics
LEFT JOIN part_groups
ON part_groups.catalog = pg_header_pics.catalog
AND part_groups.part_group = pg_header_pics.part_group
WHERE pg_header_pics.catalog = 'JP'
AND pg_header_pics.catalog_code = '431110'
AND pg_header_pics.main_group = '2';
SELECT pg_header_pics.*, part_groups.desc_en
FROM pg_header_pics
LEFT JOIN part_groups
ON part_groups.catalog = pg_header_pics.catalog
AND part_groups.part_group = pg_header_pics.part_group
WHERE pg_header_pics.catalog = 'JP'
AND pg_header_pics.catalog_code = '431110'
AND pg_header_pics.main_group = '3';
SELECT pg_header_pics.*, part_groups.desc_en
FROM pg_header_pics
LEFT JOIN part_groups
ON part_groups.catalog = pg_header_pics.catalog
AND part_groups.part_group = pg_header_pics.part_group
WHERE pg_header_pics.catalog = 'JP'
AND pg_header_pics.catalog_code = '431110'
AND pg_header_pics.main_group = '4';