API tools faq
paste
Advertisement
ADrobkov

Untitled

ADrobkov
Jul 1st, 2019
230
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 32.63 KB | None | 0 0
raw download clone embed print report
  1.  
  2. /usr/sbin/mysqld, Version: 10.3.14-MariaDB-log (MariaDB Server). started with:
  3. Tcp port: 0 Unix socket: (null)
  4. Time Id Command Argument
  5. # Time: 190624 15:27:29
  6. # User@Host: root[root] @ localhost []
  7. # Thread_id: 864 Schema: bitrix_64 QC_hit: No
  8. # Query_time: 37.371610 Lock_time: 0.004766 Rows_sent: 1 Rows_examined: 23688
  9. # Rows_affected: 0 Bytes_sent: 56
  10. use bitrix_64;
  11. SET timestamp=1561379249;
  12. SELECT COUNT('x') as C
  13. FROM
  14. b_iblock B
  15. INNER JOIN b_lang L ON B.LID=L.LID
  16. INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID
  17. INNER JOIN b_iblock_element_prop_s2 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = BE.ID
  18. left join b_catalog_product CAT_PR on (CAT_PR.ID = BE.ID) left join b_catalog_iblock CAT_IB on ((CAT_PR.VAT_ID IS NULL OR CAT_PR.VAT_ID = 0) AND CAT_IB.IBLOCK_ID = BE.IBLOCK_ID) left join b_catalog_vat CAT_VAT on (CAT_VAT.ID = IF((CAT_PR.VAT_ID IS NULL OR CAT_PR.VAT_ID = 0), CAT_IB.VAT_ID, CAT_PR.VAT_ID))
  19.  
  20.  
  21. WHERE 1=1
  22. AND (
  23.  
  24. (EXISTS (
  25. SELECT IBLOCK_ID FROM b_iblock_site WHERE IBLOCK_ID = B.ID
  26. AND (((SITE_ID='s1')))
  27. ))
  28. AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL)))
  29. AND ((((BE.ACTIVE='Y'))))
  30. AND ((((BE.IBLOCK_ID = '2'))))
  31. AND ((((
  32. (upper(FPS0.PROPERTY_275) like upper('%2940001250%') and FPS0.PROPERTY_275 is not null)
  33. )) OR ((
  34. (upper(FPS0.PROPERTY_275) like upper('%1460A058%') and FPS0.PROPERTY_275 is not null)
  35. )) OR ((
  36. (upper(FPS0.PROPERTY_275) like upper('%1460A022%') and FPS0.PROPERTY_275 is not null)
  37. )) OR ((
  38. (upper(FPS0.PROPERTY_275) like upper('%1460A003%') and FPS0.PROPERTY_275 is not null)
  39. )) OR ((
  40. (upper(FPS0.PROPERTY_275) like upper('%DCRP301250%') and FPS0.PROPERTY_275 is not null)
  41. )) OR ((
  42. (upper(FPS0.PROPERTY_275) like upper('%2940001251%') and FPS0.PROPERTY_275 is not null)
  43. )) OR ((
  44. (upper(FPS0.PROPERTY_275) like upper('%2940001252%') and FPS0.PROPERTY_275 is not null)
  45. )) OR ((
  46. (upper(FPS0.PROPERTY_275) like upper('%2940001253%') and FPS0.PROPERTY_275 is not null)
  47. )) OR ((
  48. (upper(FPS0.PROPERTY_275) like upper('%2940001254%') and FPS0.PROPERTY_275 is not null)
  49. )) OR ((
  50. (upper(FPS0.PROPERTY_275) like upper('%2940001255%') and FPS0.PROPERTY_275 is not null)
  51. )) OR ((
  52. (upper(FPS0.PROPERTY_275) like upper('%2940001256%') and FPS0.PROPERTY_275 is not null)
  53. )) OR ((
  54. (upper(FPS0.PROPERTY_275) like upper('%2940001257%') and FPS0.PROPERTY_275 is not null)
  55. )) OR ((
  56. (upper(FPS0.PROPERTY_275) like upper('%2940001258%') and FPS0.PROPERTY_275 is not null)
  57. )) OR ((
  58. (upper(FPS0.PROPERTY_275) like upper('%2940001259%') and FPS0.PROPERTY_275 is not null)
  59. )) OR ((
  60. (upper(FPS0.PROPERTY_275) like upper('%2940000340%') and FPS0.PROPERTY_275 is not null)
  61. )) OR ((
  62. (upper(FPS0.PROPERTY_275) like upper('%2940000341%') and FPS0.PROPERTY_275 is not null)
  63. )) OR ((
  64. (upper(FPS0.PROPERTY_275) like upper('%2940000342%') and FPS0.PROPERTY_275 is not null)
  65. )) OR ((
  66. (upper(FPS0.PROPERTY_275) like upper('%2940000343%') and FPS0.PROPERTY_275 is not null)
  67. )) OR ((
  68. (upper(FPS0.PROPERTY_275) like upper('%2940000344%') and FPS0.PROPERTY_275 is not null)
  69. )) OR ((
  70. (upper(FPS0.PROPERTY_275) like upper('%2940000345%') and FPS0.PROPERTY_275 is not null)
  71. )) OR ((
  72. (upper(FPS0.PROPERTY_275) like upper('%2940000346%') and FPS0.PROPERTY_275 is not null)
  73. )) OR ((
  74. (upper(FPS0.PROPERTY_275) like upper('%2940000347%') and FPS0.PROPERTY_275 is not null)
  75. )) OR ((
  76. (upper(FPS0.PROPERTY_275) like upper('%2940000348%') and FPS0.PROPERTY_275 is not null)
  77. )) OR ((
  78. (upper(FPS0.PROPERTY_275) like upper('%2940000349%') and FPS0.PROPERTY_275 is not null)
  79. )) OR ((
  80. (upper(FPS0.PROPERTY_275) like upper('%1460A058%') and FPS0.PROPERTY_275 is not null)
  81. )) OR ((
  82. (upper(FPS0.PROPERTY_275) like upper('%1460A022%') and FPS0.PROPERTY_275 is not null)
  83. )) OR ((
  84. (upper(FPS0.PROPERTY_275) like upper('%1460A003%') and FPS0.PROPERTY_275 is not null)
  85. )) OR ((
  86. (upper(FPS0.PROPERTY_275) like upper('%DCRP301250%') and FPS0.PROPERTY_275 is not null)
  87. )) OR ((
  88. (upper(FPS0.PROPERTY_275) like upper('%2940001251%') and FPS0.PROPERTY_275 is not null)
  89. )) OR ((
  90. (upper(FPS0.PROPERTY_275) like upper('%2940001252%') and FPS0.PROPERTY_275 is not null)
  91. )) OR ((
  92. (upper(FPS0.PROPERTY_275) like upper('%2940001253%') and FPS0.PROPERTY_275 is not null)
  93. )) OR ((
  94. (upper(FPS0.PROPERTY_275) like upper('%2940001254%') and FPS0.PROPERTY_275 is not null)
  95. )) OR ((
  96. (upper(FPS0.PROPERTY_275) like upper('%2940001255%') and FPS0.PROPERTY_275 is not null)
  97. )) OR ((
  98. (upper(FPS0.PROPERTY_275) like upper('%2940001256%') and FPS0.PROPERTY_275 is not null)
  99. )) OR ((
  100. (upper(FPS0.PROPERTY_275) like upper('%2940001257%') and FPS0.PROPERTY_275 is not null)
  101. )) OR ((
  102. (upper(FPS0.PROPERTY_275) like upper('%2940001258%') and FPS0.PROPERTY_275 is not null)
  103. )) OR ((
  104. (upper(FPS0.PROPERTY_275) like upper('%2940001259%') and FPS0.PROPERTY_275 is not null)
  105. )) OR ((
  106. (upper(FPS0.PROPERTY_275) like upper('%2940000340%') and FPS0.PROPERTY_275 is not null)
  107. )) OR ((
  108. (upper(FPS0.PROPERTY_275) like upper('%2940000341%') and FPS0.PROPERTY_275 is not null)
  109. )) OR ((
  110. (upper(FPS0.PROPERTY_275) like upper('%2940000342%') and FPS0.PROPERTY_275 is not null)
  111. )) OR ((
  112. (upper(FPS0.PROPERTY_275) like upper('%2940000343%') and FPS0.PROPERTY_275 is not null)
  113. )) OR ((
  114. (upper(FPS0.PROPERTY_275) like upper('%2940000344%') and FPS0.PROPERTY_275 is not null)
  115. )) OR ((
  116. (upper(FPS0.PROPERTY_275) like upper('%2940000345%') and FPS0.PROPERTY_275 is not null)
  117. )) OR ((
  118. (upper(FPS0.PROPERTY_275) like upper('%2940000346%') and FPS0.PROPERTY_275 is not null)
  119. )) OR ((
  120. (upper(FPS0.PROPERTY_275) like upper('%2940000347%') and FPS0.PROPERTY_275 is not null)
  121. )) OR ((
  122. (upper(FPS0.PROPERTY_275) like upper('%2940000348%') and FPS0.PROPERTY_275 is not null)
  123. )) OR ((
  124. (upper(FPS0.PROPERTY_275) like upper('%2940000349%') and FPS0.PROPERTY_275 is not null)
  125. )) OR ((
  126. (upper(FPS0.PROPERTY_275) like upper('%1460A058%') and FPS0.PROPERTY_275 is not null)
  127. )) OR ((
  128. (upper(FPS0.PROPERTY_275) like upper('%1460A022%') and FPS0.PROPERTY_275 is not null)
  129. )) OR ((
  130. (upper(FPS0.PROPERTY_275) like upper('%1460A003%') and FPS0.PROPERTY_275 is not null)
  131. )) OR ((
  132. (upper(FPS0.PROPERTY_275) like upper('%DCRP301250%') and FPS0.PROPERTY_275 is not null)
  133. )) OR ((
  134. (upper(FPS0.PROPERTY_275) like upper('%2940001251%') and FPS0.PROPERTY_275 is not null)
  135. )) OR ((
  136. (upper(FPS0.PROPERTY_275) like upper('%2940001252%') and FPS0.PROPERTY_275 is not null)
  137. )) OR ((
  138. (upper(FPS0.PROPERTY_275) like upper('%2940001253%') and FPS0.PROPERTY_275 is not null)
  139. )) OR ((
  140. (upper(FPS0.PROPERTY_275) like upper('%2940001254%') and FPS0.PROPERTY_275 is not null)
  141. )) OR ((
  142. (upper(FPS0.PROPERTY_275) like upper('%2940001255%') and FPS0.PROPERTY_275 is not null)
  143. )) OR ((
  144. (upper(FPS0.PROPERTY_275) like upper('%2940001256%') and FPS0.PROPERTY_275 is not null)
  145. )) OR ((
  146. (upper(FPS0.PROPERTY_275) like upper('%2940001257%') and FPS0.PROPERTY_275 is not null)
  147. )) OR ((
  148. (upper(FPS0.PROPERTY_275) like upper('%2940001258%') and FPS0.PROPERTY_275 is not null)
  149. )) OR ((
  150. (upper(FPS0.PROPERTY_275) like upper('%2940001259%') and FPS0.PROPERTY_275 is not null)
  151. )) OR ((
  152. (upper(FPS0.PROPERTY_275) like upper('%2940000340%') and FPS0.PROPERTY_275 is not null)
  153. )) OR ((
  154. (upper(FPS0.PROPERTY_275) like upper('%2940000341%') and FPS0.PROPERTY_275 is not null)
  155. )) OR ((
  156. (upper(FPS0.PROPERTY_275) like upper('%2940000342%') and FPS0.PROPERTY_275 is not null)
  157. )) OR ((
  158. (upper(FPS0.PROPERTY_275) like upper('%2940000343%') and FPS0.PROPERTY_275 is not null)
  159. )) OR ((
  160. (upper(FPS0.PROPERTY_275) like upper('%2940000344%') and FPS0.PROPERTY_275 is not null)
  161. )) OR ((
  162. (upper(FPS0.PROPERTY_275) like upper('%2940000345%') and FPS0.PROPERTY_275 is not null)
  163. )) OR ((
  164. (upper(FPS0.PROPERTY_275) like upper('%2940000346%') and FPS0.PROPERTY_275 is not null)
  165. )) OR ((
  166. (upper(FPS0.PROPERTY_275) like upper('%2940000347%') and FPS0.PROPERTY_275 is not null)
  167. )) OR ((
  168. (upper(FPS0.PROPERTY_275) like upper('%2940000348%') and FPS0.PROPERTY_275 is not null)
  169. )) OR ((
  170. (upper(FPS0.PROPERTY_275) like upper('%2940000349%') and FPS0.PROPERTY_275 is not null)
  171. )) OR ((
  172. (upper(FPS0.PROPERTY_275) like upper('%1460A058%') and FPS0.PROPERTY_275 is not null)
  173. )) OR ((
  174. (upper(FPS0.PROPERTY_275) like upper('%1460A022%') and FPS0.PROPERTY_275 is not null)
  175. )) OR ((
  176. (upper(FPS0.PROPERTY_275) like upper('%1460A003%') and FPS0.PROPERTY_275 is not null)
  177. )) OR ((
  178. (upper(FPS0.PROPERTY_275) like upper('%DCRP301250%') and FPS0.PROPERTY_275 is not null)
  179. )) OR ((
  180. (upper(FPS0.PROPERTY_275) like upper('%2940001251%') and FPS0.PROPERTY_275 is not null)
  181. )) OR ((
  182. (upper(FPS0.PROPERTY_275) like upper('%2940001252%') and FPS0.PROPERTY_275 is not null)
  183. )) OR ((
  184. (upper(FPS0.PROPERTY_275) like upper('%2940001253%') and FPS0.PROPERTY_275 is not null)
  185. )) OR ((
  186. (upper(FPS0.PROPERTY_275) like upper('%2940001254%') and FPS0.PROPERTY_275 is not null)
  187. )) OR ((
  188. (upper(FPS0.PROPERTY_275) like upper('%2940001255%') and FPS0.PROPERTY_275 is not null)
  189. )) OR ((
  190. (upper(FPS0.PROPERTY_275) like upper('%2940001256%') and FPS0.PROPERTY_275 is not null)
  191. )) OR ((
  192. (upper(FPS0.PROPERTY_275) like upper('%2940001257%') and FPS0.PROPERTY_275 is not null)
  193. )) OR ((
  194. (upper(FPS0.PROPERTY_275) like upper('%2940001258%') and FPS0.PROPERTY_275 is not null)
  195. )) OR ((
  196. (upper(FPS0.PROPERTY_275) like upper('%2940001259%') and FPS0.PROPERTY_275 is not null)
  197. )) OR ((
  198. (upper(FPS0.PROPERTY_275) like upper('%2940000340%') and FPS0.PROPERTY_275 is not null)
  199. )) OR ((
  200. (upper(FPS0.PROPERTY_275) like upper('%2940000341%') and FPS0.PROPERTY_275 is not null)
  201. )) OR ((
  202. (upper(FPS0.PROPERTY_275) like upper('%2940000342%') and FPS0.PROPERTY_275 is not null)
  203. )) OR ((
  204. (upper(FPS0.PROPERTY_275) like upper('%2940000343%') and FPS0.PROPERTY_275 is not null)
  205. )) OR ((
  206. (upper(FPS0.PROPERTY_275) like upper('%2940000344%') and FPS0.PROPERTY_275 is not null)
  207. )) OR ((
  208. (upper(FPS0.PROPERTY_275) like upper('%2940000345%') and FPS0.PROPERTY_275 is not null)
  209. )) OR ((
  210. (upper(FPS0.PROPERTY_275) like upper('%2940000346%') and FPS0.PROPERTY_275 is not null)
  211. )) OR ((
  212. (upper(FPS0.PROPERTY_275) like upper('%2940000347%') and FPS0.PROPERTY_275 is not null)
  213. )) OR ((
  214. (upper(FPS0.PROPERTY_275) like upper('%2940000348%') and FPS0.PROPERTY_275 is not null)
  215. )) OR ((
  216. (upper(FPS0.PROPERTY_275) like upper('%2940000349%') and FPS0.PROPERTY_275 is not null)
  217. )) OR ((
  218. (upper(FPS0.PROPERTY_275) like upper('%1460A058%') and FPS0.PROPERTY_275 is not null)
  219. )) OR ((
  220. (upper(FPS0.PROPERTY_275) like upper('%1460A022%') and FPS0.PROPERTY_275 is not null)
  221. )) OR ((
  222. (upper(FPS0.PROPERTY_275) like upper('%1460A003%') and FPS0.PROPERTY_275 is not null)
  223. )) OR ((
  224. (upper(FPS0.PROPERTY_275) like upper('%DCRP301250%') and FPS0.PROPERTY_275 is not null)
  225. )) OR ((
  226. (upper(FPS0.PROPERTY_275) like upper('%2940001251%') and FPS0.PROPERTY_275 is not null)
  227. )) OR ((
  228. (upper(FPS0.PROPERTY_275) like upper('%2940001252%') and FPS0.PROPERTY_275 is not null)
  229. )) OR ((
  230. (upper(FPS0.PROPERTY_275) like upper('%2940001253%') and FPS0.PROPERTY_275 is not null)
  231. )) OR ((
  232. (upper(FPS0.PROPERTY_275) like upper('%2940001254%') and FPS0.PROPERTY_275 is not null)
  233. )) OR ((
  234. (upper(FPS0.PROPERTY_275) like upper('%2940001255%') and FPS0.PROPERTY_275 is not null)
  235. )) OR ((
  236. (upper(FPS0.PROPERTY_275) like upper('%2940001256%') and FPS0.PROPERTY_275 is not null)
  237. )) OR ((
  238. (upper(FPS0.PROPERTY_275) like upper('%2940001257%') and FPS0.PROPERTY_275 is not null)
  239. )) OR ((
  240. (upper(FPS0.PROPERTY_275) like upper('%2940001258%') and FPS0.PROPERTY_275 is not null)
  241. )) OR ((
  242. (upper(FPS0.PROPERTY_275) like upper('%2940001259%') and FPS0.PROPERTY_275 is not null)
  243. )) OR ((
  244. (upper(FPS0.PROPERTY_275) like upper('%2940000340%') and FPS0.PROPERTY_275 is not null)
  245. )) OR ((
  246. (upper(FPS0.PROPERTY_275) like upper('%2940000341%') and FPS0.PROPERTY_275 is not null)
  247. )) OR ((
  248. (upper(FPS0.PROPERTY_275) like upper('%2940000342%') and FPS0.PROPERTY_275 is not null)
  249. )) OR ((
  250. (upper(FPS0.PROPERTY_275) like upper('%2940000343%') and FPS0.PROPERTY_275 is not null)
  251. )) OR ((
  252. (upper(FPS0.PROPERTY_275) like upper('%2940000344%') and FPS0.PROPERTY_275 is not null)
  253. )) OR ((
  254. (upper(FPS0.PROPERTY_275) like upper('%2940000345%') and FPS0.PROPERTY_275 is not null)
  255. )) OR ((
  256. (upper(FPS0.PROPERTY_275) like upper('%2940000346%') and FPS0.PROPERTY_275 is not null)
  257. )) OR ((
  258. (upper(FPS0.PROPERTY_275) like upper('%2940000347%') and FPS0.PROPERTY_275 is not null)
  259. )) OR ((
  260. (upper(FPS0.PROPERTY_275) like upper('%2940000348%') and FPS0.PROPERTY_275 is not null)
  261. )) OR ((
  262. (upper(FPS0.PROPERTY_275) like upper('%2940000349%') and FPS0.PROPERTY_275 is not null)
  263. )) OR ((
  264. (upper(FPS0.PROPERTY_275) like upper('%1460A058%') and FPS0.PROPERTY_275 is not null)
  265. )) OR ((
  266. (upper(FPS0.PROPERTY_275) like upper('%1460A022%') and FPS0.PROPERTY_275 is not null)
  267. )) OR ((
  268. (upper(FPS0.PROPERTY_275) like upper('%1460A003%') and FPS0.PROPERTY_275 is not null)
  269. )) OR ((
  270. (upper(FPS0.PROPERTY_275) like upper('%DCRP301250%') and FPS0.PROPERTY_275 is not null)
  271. )) OR ((
  272. (upper(FPS0.PROPERTY_275) like upper('%2940001251%') and FPS0.PROPERTY_275 is not null)
  273. )) OR ((
  274. (upper(FPS0.PROPERTY_275) like upper('%2940001252%') and FPS0.PROPERTY_275 is not null)
  275. )) OR ((
  276. (upper(FPS0.PROPERTY_275) like upper('%2940001253%') and FPS0.PROPERTY_275 is not null)
  277. )) OR ((
  278. (upper(FPS0.PROPERTY_275) like upper('%2940001254%') and FPS0.PROPERTY_275 is not null)
  279. )) OR ((
  280. (upper(FPS0.PROPERTY_275) like upper('%2940001255%') and FPS0.PROPERTY_275 is not null)
  281. )) OR ((
  282. (upper(FPS0.PROPERTY_275) like upper('%2940001256%') and FPS0.PROPERTY_275 is not null)
  283. )) OR ((
  284. (upper(FPS0.PROPERTY_275) like upper('%2940001257%') and FPS0.PROPERTY_275 is not null)
  285. )) OR ((
  286. (upper(FPS0.PROPERTY_275) like upper('%2940001258%') and FPS0.PROPERTY_275 is not null)
  287. )) OR ((
  288. (upper(FPS0.PROPERTY_275) like upper('%2940001259%') and FPS0.PROPERTY_275 is not null)
  289. )) OR ((
  290. (upper(FPS0.PROPERTY_275) like upper('%2940000340%') and FPS0.PROPERTY_275 is not null)
  291. )) OR ((
  292. (upper(FPS0.PROPERTY_275) like upper('%2940000341%') and FPS0.PROPERTY_275 is not null)
  293. )) OR ((
  294. (upper(FPS0.PROPERTY_275) like upper('%2940000342%') and FPS0.PROPERTY_275 is not null)
  295. )) OR ((
  296. (upper(FPS0.PROPERTY_275) like upper('%2940000343%') and FPS0.PROPERTY_275 is not null)
  297. )) OR ((
  298. (upper(FPS0.PROPERTY_275) like upper('%2940000344%') and FPS0.PROPERTY_275 is not null)
  299. )) OR ((
  300. (upper(FPS0.PROPERTY_275) like upper('%2940000345%') and FPS0.PROPERTY_275 is not null)
  301. )) OR ((
  302. (upper(FPS0.PROPERTY_275) like upper('%2940000346%') and FPS0.PROPERTY_275 is not null)
  303. )) OR ((
  304. (upper(FPS0.PROPERTY_275) like upper('%2940000347%') and FPS0.PROPERTY_275 is not null)
  305. )) OR ((
  306. (upper(FPS0.PROPERTY_275) like upper('%2940000348%') and FPS0.PROPERTY_275 is not null)
  307. )) OR ((
  308. (upper(FPS0.PROPERTY_275) like upper('%2940000349%') and FPS0.PROPERTY_275 is not null)
  309. )) OR ((
  310. (upper(FPS0.PROPERTY_275) like upper('%1460A058%') and FPS0.PROPERTY_275 is not null)
  311. )) OR ((
  312. (upper(FPS0.PROPERTY_275) like upper('%1460A022%') and FPS0.PROPERTY_275 is not null)
  313. )) OR ((
  314. (upper(FPS0.PROPERTY_275) like upper('%1460A003%') and FPS0.PROPERTY_275 is not null)
  315. )) OR ((
  316. (upper(FPS0.PROPERTY_275) like upper('%DCRP301250%') and FPS0.PROPERTY_275 is not null)
  317. )) OR ((
  318. (upper(FPS0.PROPERTY_275) like upper('%2940001251%') and FPS0.PROPERTY_275 is not null)
  319. )) OR ((
  320. (upper(FPS0.PROPERTY_275) like upper('%2940001252%') and FPS0.PROPERTY_275 is not null)
  321. )) OR ((
  322. (upper(FPS0.PROPERTY_275) like upper('%2940001253%') and FPS0.PROPERTY_275 is not null)
  323. )) OR ((
  324. (upper(FPS0.PROPERTY_275) like upper('%2940001254%') and FPS0.PROPERTY_275 is not null)
  325. )) OR ((
  326. (upper(FPS0.PROPERTY_275) like upper('%2940001255%') and FPS0.PROPERTY_275 is not null)
  327. )) OR ((
  328. (upper(FPS0.PROPERTY_275) like upper('%2940001256%') and FPS0.PROPERTY_275 is not null)
  329. )) OR ((
  330. (upper(FPS0.PROPERTY_275) like upper('%2940001257%') and FPS0.PROPERTY_275 is not null)
  331. )) OR ((
  332. (upper(FPS0.PROPERTY_275) like upper('%2940001258%') and FPS0.PROPERTY_275 is not null)
  333. )) OR ((
  334. (upper(FPS0.PROPERTY_275) like upper('%2940001259%') and FPS0.PROPERTY_275 is not null)
  335. )) OR ((
  336. (upper(FPS0.PROPERTY_275) like upper('%2940000340%') and FPS0.PROPERTY_275 is not null)
  337. )) OR ((
  338. (upper(FPS0.PROPERTY_275) like upper('%2940000341%') and FPS0.PROPERTY_275 is not null)
  339. )) OR ((
  340. (upper(FPS0.PROPERTY_275) like upper('%2940000342%') and FPS0.PROPERTY_275 is not null)
  341. )) OR ((
  342. (upper(FPS0.PROPERTY_275) like upper('%2940000343%') and FPS0.PROPERTY_275 is not null)
  343. )) OR ((
  344. (upper(FPS0.PROPERTY_275) like upper('%2940000344%') and FPS0.PROPERTY_275 is not null)
  345. )) OR ((
  346. (upper(FPS0.PROPERTY_275) like upper('%2940000345%') and FPS0.PROPERTY_275 is not null)
  347. )) OR ((
  348. (upper(FPS0.PROPERTY_275) like upper('%2940000346%') and FPS0.PROPERTY_275 is not null)
  349. )) OR ((
  350. (upper(FPS0.PROPERTY_275) like upper('%2940000347%') and FPS0.PROPERTY_275 is not null)
  351. )) OR ((
  352. (upper(FPS0.PROPERTY_275) like upper('%2940000348%') and FPS0.PROPERTY_275 is not null)
  353. )) OR ((
  354. (upper(FPS0.PROPERTY_275) like upper('%2940000349%') and FPS0.PROPERTY_275 is not null)
  355. )) OR ((
  356. (upper(FPS0.PROPERTY_275) like upper('%1460A058%') and FPS0.PROPERTY_275 is not null)
  357. )) OR ((
  358. (upper(FPS0.PROPERTY_275) like upper('%1460A022%') and FPS0.PROPERTY_275 is not null)
  359. )) OR ((
  360. (upper(FPS0.PROPERTY_275) like upper('%1460A003%') and FPS0.PROPERTY_275 is not null)
  361. )) OR ((
  362. (upper(FPS0.PROPERTY_275) like upper('%DCRP301250%') and FPS0.PROPERTY_275 is not null)
  363. )) OR ((
  364. (upper(FPS0.PROPERTY_275) like upper('%2940001251%') and FPS0.PROPERTY_275 is not null)
  365. )) OR ((
  366. (upper(FPS0.PROPERTY_275) like upper('%2940001252%') and FPS0.PROPERTY_275 is not null)
  367. )) OR ((
  368. (upper(FPS0.PROPERTY_275) like upper('%2940001253%') and FPS0.PROPERTY_275 is not null)
  369. )) OR ((
  370. (upper(FPS0.PROPERTY_275) like upper('%2940001254%') and FPS0.PROPERTY_275 is not null)
  371. )) OR ((
  372. (upper(FPS0.PROPERTY_275) like upper('%2940001255%') and FPS0.PROPERTY_275 is not null)
  373. )) OR ((
  374. (upper(FPS0.PROPERTY_275) like upper('%2940001256%') and FPS0.PROPERTY_275 is not null)
  375. )) OR ((
  376. (upper(FPS0.PROPERTY_275) like upper('%2940001257%') and FPS0.PROPERTY_275 is not null)
  377. )) OR ((
  378. (upper(FPS0.PROPERTY_275) like upper('%2940001258%') and FPS0.PROPERTY_275 is not null)
  379. )) OR ((
  380. (upper(FPS0.PROPERTY_275) like upper('%2940001259%') and FPS0.PROPERTY_275 is not null)
  381. )) OR ((
  382. (upper(FPS0.PROPERTY_275) like upper('%2940000340%') and FPS0.PROPERTY_275 is not null)
  383. )) OR ((
  384. (upper(FPS0.PROPERTY_275) like upper('%2940000341%') and FPS0.PROPERTY_275 is not null)
  385. )) OR ((
  386. (upper(FPS0.PROPERTY_275) like upper('%2940000342%') and FPS0.PROPERTY_275 is not null)
  387. )) OR ((
  388. (upper(FPS0.PROPERTY_275) like upper('%2940000343%') and FPS0.PROPERTY_275 is not null)
  389. )) OR ((
  390. (upper(FPS0.PROPERTY_275) like upper('%2940000344%') and FPS0.PROPERTY_275 is not null)
  391. )) OR ((
  392. (upper(FPS0.PROPERTY_275) like upper('%2940000345%') and FPS0.PROPERTY_275 is not null)
  393. )) OR ((
  394. (upper(FPS0.PROPERTY_275) like upper('%2940000346%') and FPS0.PROPERTY_275 is not null)
  395. )) OR ((
  396. (upper(FPS0.PROPERTY_275) like upper('%2940000347%') and FPS0.PROPERTY_275 is not null)
  397. )) OR ((
  398. (upper(FPS0.PROPERTY_275) like upper('%2940000348%') and FPS0.PROPERTY_275 is not null)
  399. )) OR ((
  400. (upper(FPS0.PROPERTY_275) like upper('%2940000349%') and FPS0.PROPERTY_275 is not null)
  401. )) OR ((
  402. (upper(FPS0.PROPERTY_275) like upper('%1460A058%') and FPS0.PROPERTY_275 is not null)
  403. )) OR ((
  404. (upper(FPS0.PROPERTY_275) like upper('%1460A022%') and FPS0.PROPERTY_275 is not null)
  405. )) OR ((
  406. (upper(FPS0.PROPERTY_275) like upper('%1460A003%') and FPS0.PROPERTY_275 is not null)
  407. )) OR ((
  408. (upper(FPS0.PROPERTY_275) like upper('%DCRP301250%') and FPS0.PROPERTY_275 is not null)
  409. )) OR ((
  410. (upper(FPS0.PROPERTY_275) like upper('%2940001251%') and FPS0.PROPERTY_275 is not null)
  411. )) OR ((
  412. (upper(FPS0.PROPERTY_275) like upper('%2940001252%') and FPS0.PROPERTY_275 is not null)
  413. )) OR ((
  414. (upper(FPS0.PROPERTY_275) like upper('%2940001253%') and FPS0.PROPERTY_275 is not null)
  415. )) OR ((
  416. (upper(FPS0.PROPERTY_275) like upper('%2940001254%') and FPS0.PROPERTY_275 is not null)
  417. )) OR ((
  418. (upper(FPS0.PROPERTY_275) like upper('%2940001255%') and FPS0.PROPERTY_275 is not null)
  419. )) OR ((
  420. (upper(FPS0.PROPERTY_275) like upper('%2940001256%') and FPS0.PROPERTY_275 is not null)
  421. )) OR ((
  422. (upper(FPS0.PROPERTY_275) like upper('%2940001257%') and FPS0.PROPERTY_275 is not null)
  423. )) OR ((
  424. (upper(FPS0.PROPERTY_275) like upper('%2940001258%') and FPS0.PROPERTY_275 is not null)
  425. )) OR ((
  426. (upper(FPS0.PROPERTY_275) like upper('%2940001259%') and FPS0.PROPERTY_275 is not null)
  427. )) OR ((
  428. (upper(FPS0.PROPERTY_275) like upper('%2940000340%') and FPS0.PROPERTY_275 is not null)
  429. )) OR ((
  430. (upper(FPS0.PROPERTY_275) like upper('%2940000341%') and FPS0.PROPERTY_275 is not null)
  431. )) OR ((
  432. (upper(FPS0.PROPERTY_275) like upper('%2940000342%') and FPS0.PROPERTY_275 is not null)
  433. )) OR ((
  434. (upper(FPS0.PROPERTY_275) like upper('%2940000343%') and FPS0.PROPERTY_275 is not null)
  435. )) OR ((
  436. (upper(FPS0.PROPERTY_275) like upper('%2940000344%') and FPS0.PROPERTY_275 is not null)
  437. )) OR ((
  438. (upper(FPS0.PROPERTY_275) like upper('%2940000345%') and FPS0.PROPERTY_275 is not null)
  439. )) OR ((
  440. (upper(FPS0.PROPERTY_275) like upper('%2940000346%') and FPS0.PROPERTY_275 is not null)
  441. )) OR ((
  442. (upper(FPS0.PROPERTY_275) like upper('%2940000347%') and FPS0.PROPERTY_275 is not null)
  443. )) OR ((
  444. (upper(FPS0.PROPERTY_275) like upper('%2940000348%') and FPS0.PROPERTY_275 is not null)
  445. )) OR ((
  446. (upper(FPS0.PROPERTY_275) like upper('%2940000349%') and FPS0.PROPERTY_275 is not null)
  447. )) OR ((
  448. (upper(FPS0.PROPERTY_275) like upper('%1460A058%') and FPS0.PROPERTY_275 is not null)
  449. )) OR ((
  450. (upper(FPS0.PROPERTY_275) like upper('%1460A022%') and FPS0.PROPERTY_275 is not null)
  451. )) OR ((
  452. (upper(FPS0.PROPERTY_275) like upper('%1460A003%') and FPS0.PROPERTY_275 is not null)
  453. )) OR ((
  454. (upper(FPS0.PROPERTY_275) like upper('%DCRP301250%') and FPS0.PROPERTY_275 is not null)
  455. )) OR ((
  456. (upper(FPS0.PROPERTY_275) like upper('%2940001251%') and FPS0.PROPERTY_275 is not null)
  457. )) OR ((
  458. (upper(FPS0.PROPERTY_275) like upper('%2940001252%') and FPS0.PROPERTY_275 is not null)
  459. )) OR ((
  460. (upper(FPS0.PROPERTY_275) like upper('%2940001253%') and FPS0.PROPERTY_275 is not null)
  461. )) OR ((
  462. (upper(FPS0.PROPERTY_275) like upper('%2940001254%') and FPS0.PROPERTY_275 is not null)
  463. )) OR ((
  464. (upper(FPS0.PROPERTY_275) like upper('%2940001255%') and FPS0.PROPERTY_275 is not null)
  465. )) OR ((
  466. (upper(FPS0.PROPERTY_275) like upper('%2940001256%') and FPS0.PROPERTY_275 is not null)
  467. )) OR ((
  468. (upper(FPS0.PROPERTY_275) like upper('%2940001257%') and FPS0.PROPERTY_275 is not null)
  469. )) OR ((
  470. (upper(FPS0.PROPERTY_275) like upper('%2940001258%') and FPS0.PROPERTY_275 is not null)
  471. )) OR ((
  472. (upper(FPS0.PROPERTY_275) like upper('%2940001259%') and FPS0.PROPERTY_275 is not null)
  473. )) OR ((
  474. (upper(FPS0.PROPERTY_275) like upper('%2940000340%') and FPS0.PROPERTY_275 is not null)
  475. )) OR ((
  476. (upper(FPS0.PROPERTY_275) like upper('%2940000341%') and FPS0.PROPERTY_275 is not null)
  477. )) OR ((
  478. (upper(FPS0.PROPERTY_275) like upper('%2940000342%') and FPS0.PROPERTY_275 is not null)
  479. )) OR ((
  480. (upper(FPS0.PROPERTY_275) like upper('%2940000343%') and FPS0.PROPERTY_275 is not null)
  481. )) OR ((
  482. (upper(FPS0.PROPERTY_275) like upper('%2940000344%') and FPS0.PROPERTY_275 is not null)
  483. )) OR ((
  484. (upper(FPS0.PROPERTY_275) like upper('%2940000345%') and FPS0.PROPERTY_275 is not null)
  485. )) OR ((
  486. (upper(FPS0.PROPERTY_275) like upper('%2940000346%') and FPS0.PROPERTY_275 is not null)
  487. )) OR ((
  488. (upper(FPS0.PROPERTY_275) like upper('%2940000347%') and FPS0.PROPERTY_275 is not null)
  489. )) OR ((
  490. (upper(FPS0.PROPERTY_275) like upper('%2940000348%') and FPS0.PROPERTY_275 is not null)
  491. )) OR ((
  492. (upper(FPS0.PROPERTY_275) like upper('%2940000349%') and FPS0.PROPERTY_275 is not null)
  493. )) OR ((
  494. (upper(FPS0.PROPERTY_275) like upper('%1460A058%') and FPS0.PROPERTY_275 is not null)
  495. )) OR ((
  496. (upper(FPS0.PROPERTY_275) like upper('%1460A022%') and FPS0.PROPERTY_275 is not null)
  497. )) OR ((
  498. (upper(FPS0.PROPERTY_275) like upper('%1460A003%') and FPS0.PROPERTY_275 is not null)
  499. )) OR ((
  500. (upper(FPS0.PROPERTY_275) like upper('%DCRP301250%') and FPS0.PROPERTY_275 is not null)
  501. )) OR ((
  502. (upper(FPS0.PROPERTY_275) like upper('%2940001251%') and FPS0.PROPERTY_275 is not null)
  503. )) OR ((
  504. (upper(FPS0.PROPERTY_275) like upper('%2940001252%') and FPS0.PROPERTY_275 is not null)
  505. )) OR ((
  506. (upper(FPS0.PROPERTY_275) like upper('%2940001253%') and FPS0.PROPERTY_275 is not null)
  507. )) OR ((
  508. (upper(FPS0.PROPERTY_275) like upper('%2940001254%') and FPS0.PROPERTY_275 is not null)
  509. )) OR ((
  510. (upper(FPS0.PROPERTY_275) like upper('%2940001255%') and FPS0.PROPERTY_275 is not null)
  511. )) OR ((
  512. (upper(FPS0.PROPERTY_275) like upper('%2940001256%') and FPS0.PROPERTY_275 is not null)
  513. )) OR ((
  514. (upper(FPS0.PROPERTY_275) like upper('%2940001257%') and FPS0.PROPERTY_275 is not null)
  515. )) OR ((
  516. (upper(FPS0.PROPERTY_275) like upper('%2940001258%') and FPS0.PROPERTY_275 is not null)
  517. )) OR ((
  518. (upper(FPS0.PROPERTY_275) like upper('%2940001259%') and FPS0.PROPERTY_275 is not null)
  519. )) OR ((
  520. (upper(FPS0.PROPERTY_275) like upper('%2940000340%') and FPS0.PROPERTY_275 is not null)
  521. )) OR ((
  522. (upper(FPS0.PROPERTY_275) like upper('%2940000341%') and FPS0.PROPERTY_275 is not null)
  523. )) OR ((
  524. (upper(FPS0.PROPERTY_275) like upper('%2940000342%') and FPS0.PROPERTY_275 is not null)
  525. )) OR ((
  526. (upper(FPS0.PROPERTY_275) like upper('%2940000343%') and FPS0.PROPERTY_275 is not null)
  527. )) OR ((
  528. (upper(FPS0.PROPERTY_275) like upper('%2940000344%') and FPS0.PROPERTY_275 is not null)
  529. )) OR ((
  530. (upper(FPS0.PROPERTY_275) like upper('%2940000345%') and FPS0.PROPERTY_275 is not null)
  531. )) OR ((
  532. (upper(FPS0.PROPERTY_275) like upper('%2940000346%') and FPS0.PROPERTY_275 is not null)
  533. )) OR ((
  534. (upper(FPS0.PROPERTY_275) like upper('%2940000347%') and FPS0.PROPERTY_275 is not null)
  535. )) OR ((
  536. (upper(FPS0.PROPERTY_275) like upper('%2940000348%') and FPS0.PROPERTY_275 is not null)
  537. )) OR ((
  538. (upper(FPS0.PROPERTY_275) like upper('%2940000349%') and FPS0.PROPERTY_275 is not null)
  539. )) OR ((
  540. (upper(FPS0.PROPERTY_275) like upper('%1460A058%') and FPS0.PROPERTY_275 is not null)
  541. )) OR ((
  542. (upper(FPS0.PROPERTY_275) like upper('%1460A022%') and FPS0.PROPERTY_275 is not null)
  543. )) OR ((
  544. (upper(FPS0.PROPERTY_275) like upper('%1460A003%') and FPS0.PROPERTY_275 is not null)
  545. )) OR ((
  546. (upper(FPS0.PROPERTY_275) like upper('%DCRP301250%') and FPS0.PROPERTY_275 is not null)
  547. )) OR ((
  548. (upper(FPS0.PROPERTY_275) like upper('%2940001251%') and FPS0.PROPERTY_275 is not null)
  549. )) OR ((
  550. (upper(FPS0.PROPERTY_275) like upper('%2940001252%') and FPS0.PROPERTY_275 is not null)
  551. )) OR ((
  552. (upper(FPS0.PROPERTY_275) like upper('%2940001253%') and FPS0.PROPERTY_275 is not null)
  553. )) OR ((
  554. (upper(FPS0.PROPERTY_275) like upper('%2940001254%') and FPS0.PROPERTY_275 is not null)
  555. )) OR ((
  556. (upper(FPS0.PROPERTY_275) like upper('%2940001255%') and FPS0.PROPERTY_275 is not null)
  557. )) OR ((
  558. (upper(FPS0.PROPERTY_275) like upper('%2940001256%') and FPS0.PROPERTY_275 is not null)
  559. )) OR ((
  560. (upper(FPS0.PROPERTY_275) like upper('%2940001257%') and FPS0.PROPERTY_275 is not null)
  561. )) OR ((
  562. (upper(FPS0.PROPERTY_275) like upper('%2940001258%') and FPS0.PROPERTY_275 is not null)
  563. )) OR ((
  564. (upper(FPS0.PROPERTY_275) like upper('%2940001259%') and FPS0.PROPERTY_275 is not null)
  565. )) OR ((
  566. (upper(FPS0.PROPERTY_275) like upper('%2940000340%') and FPS0.PROPERTY_275 is not null)
  567. )) OR ((
  568. (upper(FPS0.PROPERTY_275) like upper('%2940000341%') and FPS0.PROPERTY_275 is not null)
  569. )) OR ((
  570. (upper(FPS0.PROPERTY_275) like upper('%2940000342%') and FPS0.PROPERTY_275 is not null)
  571. )) OR ((
  572. (upper(FPS0.PROPERTY_275) like upper('%2940000343%') and FPS0.PROPERTY_275 is not null)
  573. )) OR ((
  574. (upper(FPS0.PROPERTY_275) like upper('%2940000344%') and FPS0.PROPERTY_275 is not null)
  575. )) OR ((
  576. (upper(FPS0.PROPERTY_275) like upper('%2940000345%') and FPS0.PROPERTY_275 is not null)
  577. )) OR ((
  578. (upper(FPS0.PROPERTY_275) like upper('%2940000346%') and FPS0.PROPERTY_275 is not null)
  579. )) OR ((
  580. (upper(FPS0.PROPERTY_275) like upper('%2940000347%') and FPS0.PROPERTY_275 is not null)
  581. )) OR ((
  582. (upper(FPS0.PROPERTY_275) like upper('%2940000348%') and FPS0.PROPERTY_275 is not null)
  583. )) OR ((
  584. (upper(FPS0.PROPERTY_275) like upper('%2940000349%') and FPS0.PROPERTY_275 is not null)
  585. )) OR ((
  586. (upper(FPS0.PROPERTY_275) like upper('%1460A058%') and FPS0.PROPERTY_275 is not null)
  587. )) OR ((
  588. (upper(FPS0.PROPERTY_275) like upper('%1460A022%') and FPS0.PROPERTY_275 is not null)
  589. )) OR ((
  590. (upper(FPS0.PROPERTY_275) like upper('%1460A003%') and FPS0.PROPERTY_275 is not null)
  591. )) OR ((
  592. (upper(FPS0.PROPERTY_275) like upper('%DCRP301250%') and FPS0.PROPERTY_275 is not null)
  593. )) OR ((
  594. (upper(FPS0.PROPERTY_275) like upper('%2940001251%') and FPS0.PROPERTY_275 is not null)
  595. )) OR ((
  596. (upper(FPS0.PROPERTY_275) like upper('%2940001252%') and FPS0.PROPERTY_275 is not null)
  597. )) OR ((
  598. (upper(FPS0.PROPERTY_275) like upper('%2940001253%') and FPS0.PROPERTY_275 is not null)
  599. )) OR ((
  600. (upper(FPS0.PROPERTY_275) like upper('%2940001254%') and FPS0.PROPERTY_275 is not null)
  601. )) OR ((
  602. (upper(FPS0.PROPERTY_275) like upper('%2940001255%') and FPS0.PROPERTY_275 is not null)
  603. )) OR ((
  604. (upper(FPS0.PROPERTY_275) like upper('%2940001256%') and FPS0.PROPERTY_275 is not null)
  605. )) OR ((
  606. (upper(FPS0.PROPERTY_275) like upper('%2940001257%') and FPS0.PROPERTY_275 is not null)
  607. )) OR ((
  608. (upper(FPS0.PROPERTY_275) like upper('%2940001258%') and FPS0.PROPERTY_275 is not null)
  609. )) OR ((
  610. (upper(FPS0.PROPERTY_275) like upper('%2940001259%') and FPS0.PROPERTY_275 is not null)
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!