daily pastebin goal
24%
SHARE
TWEET

Untitled

a guest Feb 19th, 2019 76 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT ma.name, ma.id as stagingId, mat.id as testshopId
  2. FROM s_media_album ma
  3. LEFT JOIN s_media_album_testshop mat ON ma.name = mat.name
  4. WHERE ma.name = 'Sideboard Freisteller'
  5.  
  6. UPDATE s_media m
  7. SET m.albumID = 38
  8. WHERE m.name IN (
  9.     SELECT mt.name
  10.     FROM s_media_testshop mt
  11.     LEFT JOIN s_media_album_testshop mat ON mt.albumID = mat.id
  12.     WHERE mat.id = 46
  13. )
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top