 |
SELECT p.`part_number`, p.`description`,
if(p.`color` IS NULL, j.`color`, p.`color`) AS `adapter_color`,
if(p.`material` IS NULL, j.`material`,p.`material`) AS `adapter_material`,
j2.`color` AS `swivel_color`, j2.`material` AS `swivel_material`,
CONCAT(if(p.`color` IS NULL, j.`color`, p.`color`), ' ', if(p.material IS NULL, j.`material`,p.material)) AS `adaptermat`,
CONCAT(j2.`color`, ' ', j2.`material`) AS `swivelmat`,
p.`type`, p.`thumbnail_outlines`
FROM `product` p
LEFT JOIN `product` j ON p.`adapter` = j.`part_number`
LEFT JOIN `product` j2 ON p.`swivel` = j2.`part_number`
WHERE p.`type` LIKE '"T" Adapter%'
AND p.`part_number` NOT LIKE 'fake%'
|
|
|
