All pastes #500318 Raw Edit

Miscellany

public text v1 · immutable
·published 2007-05-21 15:19 UTC
rendered paste body
    SELECT c.id, v.id
      FROM (countries c LEFT JOIN item_country_map i1 ON c.id=i1.country_id)
CROSS JOIN (variables v LEFT JOIN item_variable_map i2 ON v.id=i2.variable_id)
  GROUP BY c.id, v.id
    HAVING COUNT(IF(i1.item_id=i2.item_id,1,null))=0