 |
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` = 'Swivel Adapter'
AND p.`part_number` NOT LIKE 'fake%'
ORDER BY FIELD(p.`part_number`,'AC1770','AC1771','AC1775','AC1775R','AC1776',
'AC1189','AC1760','AC1761','AC1762','AC1763','AC1765')
|
|
|
