SHARE
TWEET

query_definition

a guest May 27th, 2019 134 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. explain
  2. select
  3. tabdt0_.name as col_0_0_, tabdt0_.rid as col_1_0_, tabdt0_.id as col_2_0_,
  4. vwsf2_.sval as col_3_0_,
  5. vwsf3_.sval as col_4_0_,
  6. vwsf4_.sval as col_5_0_,
  7. vwsf5_.sval as col_6_0_,
  8. vwsf6_.sval as col_7_0_,
  9. vwsf7_.sval as col_8_0_,
  10. vwsf8_.sval as col_9_0_,
  11. vwsf9_.sval as col_10_0_,
  12. vwsf10_.sval as col_11_0_,
  13. vwsf11_.sval as col_12_0_,
  14. vwsf12_.sval as col_13_0_,
  15. vwsf13_.sval as col_14_0_,
  16. vwsf14_.sval as col_15_0_,
  17. vwsf15_.sval as col_16_0_,
  18. vwsf16_.sval as col_17_0_,
  19. vwsf17_.sval as col_18_0_,
  20. vwsf18_.sval as col_19_0_,
  21. vwsf19_.sval as col_20_0_,
  22. vwsf20_.sval as col_21_0_,
  23. vwsf21_.sval as col_22_0_,
  24. vwsf22_.sval as col_23_0_,
  25. vwsf23_.sval as col_24_0_,
  26. vwsf24_.sval as col_25_0_,
  27. vwsf25_.sval as col_26_0_,
  28. vwsf26_.sval as col_27_0_,
  29. vwsf27_.sval as col_28_0_,
  30. vwsf28_.sval as col_29_0_,
  31. vwsf29_.sval as col_30_0_,
  32. vwsf30_.sval as col_31_0_
  33. -- ,vwsf31_.sval as col_32_0_
  34. from
  35. tab_dt tabdt0_ inner join tab_inf tabinf1_ on tabdt0_.bid=tabinf1_.id
  36. left join vw_sf vwsf2_ on tabinf1_.id=vwsf2_.bid and (vwsf2_.name="field1")
  37. left join vw_sf vwsf3_ on tabinf1_.id=vwsf3_.bid and (vwsf3_.name="field2")
  38. left join vw_sf vwsf4_ on tabinf1_.id=vwsf4_.bid and (vwsf4_.name="field3")
  39. left join vw_sf vwsf5_ on tabinf1_.id=vwsf5_.bid and (vwsf5_.name="field4")
  40. left join vw_sf vwsf6_ on tabinf1_.id=vwsf6_.bid and (vwsf6_.name="field5")
  41. left join vw_sf vwsf7_ on tabinf1_.id=vwsf7_.bid and (vwsf7_.name="field6")
  42. left join vw_sf vwsf8_ on tabinf1_.id=vwsf8_.bid and (vwsf8_.name="field7")
  43. left join vw_sf vwsf9_ on tabinf1_.id=vwsf9_.bid and (vwsf9_.name="field8")
  44. left join vw_sf vwsf10_ on tabinf1_.id=vwsf10_.bid and (vwsf10_.name="field9")
  45. left join vw_sf vwsf11_ on tabinf1_.id=vwsf11_.bid and (vwsf11_.name="field10")
  46. left join vw_sf vwsf12_ on tabinf1_.id=vwsf12_.bid and (vwsf12_.name="field11")
  47. left join vw_sf vwsf13_ on tabinf1_.id=vwsf13_.bid and (vwsf13_.name="field12")
  48. left join vw_sf vwsf14_ on tabinf1_.id=vwsf14_.bid and (vwsf14_.name="field13")
  49. left join vw_sf vwsf15_ on tabinf1_.id=vwsf15_.bid and (vwsf15_.name="field14")
  50. left join vw_sf vwsf16_ on tabinf1_.id=vwsf16_.bid and (vwsf16_.name="field15")
  51. left join vw_sf vwsf17_ on tabinf1_.id=vwsf17_.bid and (vwsf17_.name="field16")
  52. left join vw_sf vwsf18_ on tabinf1_.id=vwsf18_.bid and (vwsf18_.name="field17")
  53. left join vw_sf vwsf19_ on tabinf1_.id=vwsf19_.bid and (vwsf19_.name="field18")
  54. left join vw_sf vwsf20_ on tabinf1_.id=vwsf20_.bid and (vwsf20_.name="field19")
  55. left join vw_sf vwsf21_ on tabinf1_.id=vwsf21_.bid and (vwsf21_.name="field20")
  56. left join vw_sf vwsf22_ on tabinf1_.id=vwsf22_.bid and (vwsf22_.name="field21")
  57. left join vw_sf vwsf23_ on tabinf1_.id=vwsf23_.bid and (vwsf23_.name="field22")
  58. left join vw_sf vwsf24_ on tabinf1_.id=vwsf24_.bid and (vwsf24_.name="field23")
  59. left join vw_sf vwsf25_ on tabinf1_.id=vwsf25_.bid and (vwsf25_.name="field24")
  60. left join vw_sf vwsf26_ on tabinf1_.id=vwsf26_.bid and (vwsf26_.name="field25")
  61. left join vw_sf vwsf27_ on tabinf1_.id=vwsf27_.bid and (vwsf27_.name="field26")
  62. left join vw_sf vwsf28_ on tabinf1_.id=vwsf28_.bid and (vwsf28_.name="field27")
  63. left join vw_sf vwsf29_ on tabinf1_.id=vwsf29_.bid and (vwsf29_.name="field28")
  64. left join vw_sf vwsf30_ on tabinf1_.id=vwsf30_.bid and (vwsf30_.name="field29")
  65. -- left join vw_sf vwsf31_ on tabinf1_.id=vwsf31_.bid and (vwsf31_.name="field30")
  66. where
  67. tabdt0_.bid in (1,2,3,4,5)
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