API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 15th, 2019
105
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.30 KB | None | 0 0
raw download clone embed print report
  1. SELECT DISTINCT P.TYPE as PROP_TYPE, UP.ID as ID, UP.USER_PROPS_ID as USER_PROPS_ID, UP.ORDER_PROPS_ID as ORDER_PROPS_ID, UP.NAME as NAME,
  2.  
  3. CASE
  4.  
  5.  
  6.  
  7. WHEN
  8.  
  9. P.TYPE = 'LOCATION'
  10.  
  11. THEN
  12.  
  13. CAST(L.ID as char(255))
  14.  
  15.  
  16.  
  17. ELSE
  18.  
  19. UP.VALUE
  20.  
  21. END
  22.  
  23. as VALUE, P.ID as PROP_ID, P.PERSON_TYPE_ID as PROP_PERSON_TYPE_ID, P.NAME as PROP_NAME, P.TYPE as PROP_TYPE, P.REQUIRED as PROP_REQUIED, P.DEFAULT_VALUE as PROP_DEFAULT_VALUE, P.SORT as PROP_SORT, P.USER_PROPS as PROP_USER_PROPS, P.IS_LOCATION as PROP_IS_LOCATION, P.PROPS_GROUP_ID as PROP_PROPS_GROUP_ID, P.DESCRIPTION as PROP_DESCRIPTION, P.IS_EMAIL as PROP_IS_EMAIL, P.IS_PROFILE_NAME as PROP_IS_PROFILE_NAME, P.IS_PAYER as PROP_IS_PAYER, P.IS_LOCATION4TAX as PROP_IS_LOCATION4TAX, P.IS_ZIP as PROP_IS_ZIP, P.CODE as PROP_CODE, PV.ID as VARIANT_ID, PV.ORDER_PROPS_ID as VARIANT_ORDER_PROPS_ID, PV.NAME as VARIANT_NAME, PV.VALUE as VARIANT_VALUE, PV.SORT as VARIANT_SORT, PV.DESCRIPTION as VARIANT_DESCRIPTION FROM b_sale_user_props_value UP INNER JOIN b_sale_order_props P ON (UP.ORDER_PROPS_ID = P.ID) LEFT JOIN b_sale_location L ON (P.TYPE = 'LOCATION' AND UP.VALUE IS NOT NULL AND UP.VALUE = L.CODE) LEFT JOIN b_sale_order_props_variant PV ON (UP.ORDER_PROPS_ID = PV.ORDER_PROPS_ID AND UP.VALUE = PV.VALUE) WHERE ((((UP.ORDER_PROPS_ID = 5 )))) AND ((((
  24.  
  25. CASE
  26.  
  27.  
  28.  
  29. WHEN
  30.  
  31. P.TYPE = 'LOCATION'
  32.  
  33. THEN
  34.  
  35. CAST(L.ID as char(255))
  36.  
  37.  
  38.  
  39. ELSE
  40.  
  41. UP.VALUE
  42.  
  43. END
  44.  
  45. IS NULL) OR (length(
  46.  
  47. CASE
  48.  
  49.  
  50.  
  51. WHEN
  52.  
  53. P.TYPE = 'LOCATION'
  54.  
  55. THEN
  56.  
  57. CAST(L.ID as char(255))
  58.  
  59.  
  60.  
  61. ELSE
  62.  
  63. UP.VALUE
  64.  
  65. END
  66.  
  67. ) <= 0) OR (
  68.  
  69. CASE
  70.  
  71.  
  72.  
  73. WHEN
  74.  
  75. P.TYPE = 'LOCATION'
  76.  
  77. THEN
  78.  
  79. CAST(L.ID as char(255))
  80.  
  81.  
  82.  
  83. ELSE
  84.  
  85. UP.VALUE
  86.  
  87. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!