||cw
public sql v1 · immutableSELECT chrome.hand_ht45 AS chrome, blade.hand_ht45 AS blade, diff.hand_ht45 AS diffFROM tab_diff_all_cuts chrome LEFT OUTER JOIN tab_diff_all_cuts blade ON (chrome.all_counter = blade.all_counter AND chrome.cuts_to = blade.cuts_to) LEFT OUTER JOIN tab_diff_all_cuts diff ON (chrome.all_counter = diff.all_counter AND chrome.cuts_to = diff.cuts_to)WHERE chrome.all_counter = 10602 AND chrome.cuts_to = 'LINER' AND chrome.item = 'CHROME' AND blade.item = 'BA' AND diff.item = 'HARD'