API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2019
61
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.92 KB | None | 0 0
raw download clone embed print report
  1. SELECT
  2. account_code, customers.name, code, quote_total, quantity as qty_grp_doors
  3. FROM
  4. quotes
  5. JOIN
  6. quote_products ON quote_id = quotes.id AND product_id = 5
  7. AND quantity > 0
  8. JOIN
  9. customers ON customers.id = customer_id
  10. WHERE quotes.created_at > '2018-11-05' and
  11. quotes.deleted_at IS NULL
  12. AND quote_products.deleted_at IS NULL
  13. AND customers.deleted_at IS NULL
  14. AND inserted
  15. AND account_code IN ('40WESTW' , '30OAKST',
  16. 'A3420T',
  17. 'A536S',
  18. '20DUFFY',
  19. '40STONE',
  20. 'ALBION',
  21. 'WILSON',
  22. '115ALANS',
  23. 'ALANMCCO',
  24. 'ALANDUNC',
  25. '320ALANB',
  26. '320LITTL',
  27. '30ACAWI',
  28. '105LAXFO',
  29. '20BROWN',
  30. '103ALEXS',
  31. 'MJDEL01',
  32. 'LAA001',
  33. '334AONPR',
  34. '30TMGLL',
  35. '40PREST',
  36. '1009',
  37. '202ANDRQ',
  38. '40AMILL',
  39. 'D&MCONTR',
  40. 'ACUTHILL',
  41. 'JMGROUND',
  42. '50HEWI',
  43. '40NUAGE',
  44. '332ASCOT',
  45. '30ADVAN',
  46. '530HOMES',
  47. 'MMRLIMIT',
  48. 'DMCLAUGL',
  49. 'ANTHONYB',
  50. ' JOIN',
  51. '30WADSW',
  52. '20FOWLE',
  53. '206MMCLA',
  54. '126BENGU',
  55. 'BERNIEGA',
  56. '30PREST',
  57. 'WSZJOINE',
  58. 'WILLMORR',
  59. '332MACKA',
  60. '320BREND',
  61. '332WINDO',
  62. '104BLIND',
  63. '108BANDE',
  64. 'J.B.MKIT',
  65. 'BWDOORS',
  66. '105CLELA',
  67. '20LEEMC',
  68. '50STARG',
  69. '40ENHAC',
  70. 'EBJ001',
  71. 'M&LBUILD',
  72. 'MILLERJO',
  73. '550CHARQ',
  74. '40HOMES',
  75. '520SASHS',
  76. '20DOODY',
  77. 'CHRISWAL',
  78. '20WILDW',
  79. '20HAYHU',
  80. '20CHRI',
  81. '40CBBUU',
  82. 'COBRABUI',
  83. 'CHRISBEL',
  84. '422CHRIS',
  85. '332CHRIS',
  86. 'EASTLOTH',
  87. 'CTDJOINE',
  88. '206CHRIR',
  89. 'DAINT01',
  90. '660WOOLL',
  91. 'C&GWIN',
  92. '20CNHJO',
  93. 'CLIFFJON',
  94. '40HEWIS',
  95. '423COLIN',
  96. '212CRAIG',
  97. 'CRAIGJOH',
  98. '320BRUNT',
  99. '103MASPI',
  100. '330ALLPV',
  101. '40SPECI',
  102. '30DHWIN',
  103. '318DDDEC',
  104. '20MONKD',
  105. '20MITRE',
  106. 'LIMONDPR',
  107. 'DLCONTRA',
  108. '212DRJOI',
  109. 'TRADELIN',
  110. '115DARR6',
  111. 'TAYPORTW',
  112. '319PREMI',
  113. 'DALBY',
  114. '05SPECT',
  115. '20SANDD',
  116. '550DAVID',
  117. '40DDOWN',
  118. '40RIDIN',
  119. '103DNASH',
  120. '103DAVIU',
  121. 'AKMOYES',
  122. 'WALKERJO',
  123. 'HOMECARE',
  124. 'JJVASS&S',
  125. '209STIRR',
  126. 'AYRSHIRD',
  127. 'DCDOUBLE',
  128. '212DAVII',
  129. '331DCMBU',
  130. '321TFSDE',
  131. 'BONNING',
  132. 'FAIRBAIR',
  133. 'WSDUNSIR',
  134. 'J&DLOWRI',
  135. 'CRUSEDAV',
  136. 'BROW01',
  137. '320DAVIH',
  138. '40HAYES',
  139. '50DEANH',
  140. '30DEATS',
  141. 'MCGREGWI',
  142. '211CRAIZ',
  143. 'YATESDER',
  144. 'DEREKHAG',
  145. '20MELCO',
  146. '209DESMC',
  147. '213DONAL',
  148. '206ONSIT',
  149. 'DONALDGO',
  150. '101RDUNC',
  151. 'DCLJOINE',
  152. 'FOSTEREU',
  153. 'EWANMURR',
  154. '115FORBE',
  155. 'WSSGROUP',
  156. '50FRAN',
  157. 'BROUGHTY',
  158. '206FRANZ',
  159. 'FJSJOIN',
  160. 'GARRYCAI',
  161. '101GBGLA',
  162. 'GARYFOWL',
  163. '330GMAGL',
  164. 'GSOWERBY',
  165. '211SRBUI',
  166. '212GARYB',
  167. 'GARYLYON',
  168. '321GARYC',
  169. '206GWATS',
  170. '30MERED',
  171. 'GBREMNER',
  172. '30PROVI',
  173. 'GAYLEMCE',
  174. '640PUBLI',
  175. 'GBMCLEOD',
  176. 'KEYHOMES',
  177. '214GEORG',
  178. 'DUNDEETI',
  179. '206GERRY',
  180. '40LOWTE',
  181. '40PRECI',
  182. '202GOPIS',
  183. 'PROPERMA',
  184. 'GORDONW',
  185. 'GMACJOIN',
  186. '108GORDO',
  187. 'GRLPROFI',
  188. 'NATURALW',
  189. 'EXELJOIN',
  190. 'G.RWIDNO',
  191. '20HILIT',
  192. '211GMDLL',
  193. '30GLDCO',
  194. 'CUTHBERT',
  195. '331NOBLE',
  196. 'GCFJOINE',
  197. '115MEGRY',
  198. '211IAINT',
  199. '101BRAND',
  200. '20IPHILI',
  201. 'CRAIGIEV',
  202. '211CLEAR',
  203. '30MOSBO',
  204. '30ISWIN',
  205. 'TEL001',
  206. 'MANTAS',
  207. '650EWBSE',
  208. '331COTTI',
  209. 'PETERHEJ',
  210. '211JDJOI',
  211. '211DAWSO',
  212. 'HEARTLAN',
  213. '21212GJO',
  214. '213CIJOI',
  215. 'J&AFISHE',
  216. 'SHIRECON',
  217. 'MACMILLA',
  218. 'JAMIEROB',
  219. 'JAMIEPRE',
  220. '321SUREB',
  221. 'ALLTECBU',
  222. 'CHA001',
  223. '103ALLIJ',
  224. '209JIMYO',
  225. '211JIMDR',
  226. 'JSGLAZIN',
  227. '103JOEMC',
  228. 'JOHNDUFF',
  229. '610JOHNJ',
  230. '40STEAM',
  231. '40ENHAN',
  232. '40JAME',
  233. '40CANNO',
  234. '104JOHNF',
  235. '104JOHNH',
  236. 'JOHNANDE',
  237. '108JOHNM',
  238. '209JOHNC',
  239. 'ARMOURHO',
  240. '211JOHNH',
  241. '213JOHNR',
  242. '213NXGWI',
  243. '206JMCDO',
  244. '30JOHNR',
  245. 'NORLAND',
  246. '115JOHNB',
  247. 'JOHNMCLE',
  248. '50MJWIN',
  249. 'JEH001',
  250. '321JONHU',
  251. '20TRANS',
  252. '212PJGRE',
  253. '320KARIN',
  254. '332PAULM',
  255. '40AKWIN',
  256. '211KDJOI',
  257. '320KEITP',
  258. '320KEITH',
  259. '50KENNE',
  260. 'KENMESSE',
  261. '320SANDY',
  262. '540KENNE',
  263. 'KENNYSHA',
  264. 'KEVINWHY',
  265. '50KCIMP',
  266. '40BOSOM',
  267. '105KEVIN',
  268. 'RWC001',
  269. 'CH001',
  270. 'KYLEBRAC',
  271. 'DHI001',
  272. '40L&DWI',
  273. 'LHCO01',
  274. '20BOYSL',
  275. '20DICKS',
  276. '540RESID',
  277. 'HARRISON',
  278. 'MARKSGLA',
  279. '30LCSER',
  280. '30GODBE',
  281. '30LFJOI',
  282. '530LEEAI',
  283. 'ADVAN01',
  284. '331SMALL',
  285. 'LESBUCHA',
  286. '320LESLI',
  287. 'LIAMMCGI',
  288. 'LBPROPER',
  289. 'SHEY01',
  290. 'GRAEMEWC',
  291. '30GREEE',
  292. '214MALCO',
  293. '40SUPEI',
  294. '1031',
  295. '520MARKW',
  296. '103MARKC',
  297. '423WCPPI',
  298. '209MARKR',
  299. '530CHEST',
  300. '320LEAWA',
  301. 'MONO01',
  302. 'JC001S',
  303. '320CITYC',
  304. '20BARRO',
  305. '209MARTJ',
  306. '115MARTW',
  307. '50UPVCW',
  308. '50PETED',
  309. '505CEDAT',
  310. 'M.D.BUIL',
  311. 'OUTSIDEI',
  312. '20MABUI',
  313. 'MIKEWATT',
  314. 'KINLOCHB',
  315. 'MTPD001',
  316. '317SELEC',
  317. 'CU001',
  318. '50SHELU',
  319. '30GEMIN',
  320. 'MIKESMIT',
  321. '101RYDEL',
  322. 'MIKEGALL',
  323. 'JMC',
  324. '209SWDGJ',
  325. '211MIKET',
  326. 'BRUN01',
  327. 'DJMS',
  328. '321NATHS',
  329. 'BALFOURP',
  330. 'A2718S',
  331. '50SUREE',
  332. '40NEILS',
  333. '40NEILB',
  334. '103NEILA',
  335. '211MORAY',
  336. 'NEILREID',
  337. 'MACRAEBR',
  338. 'NEILYOUN',
  339. '126NEILH',
  340. 'ADENSPEC',
  341. 'MCBURNEY',
  342. 'DENGIELT',
  343. '20BROOK',
  344. '20CGSGL',
  345. '50NICKW',
  346. '540NICKB',
  347. '317YORKS',
  348. 'NICKMAUN',
  349. '30CLARE',
  350. '30D&N01',
  351. '50XCLUI',
  352. '40CLASS',
  353. '30NEDOU',
  354. 'NORMANBR',
  355. '20WILSO',
  356. '101PAULH',
  357. '202GPSJO',
  358. '520BOLTO',
  359. '20PAULA',
  360. '20ALLCL',
  361. 'P&RJOINE',
  362. '103FAXJO',
  363. '104PAULS',
  364. 'YOUNGJOI',
  365. 'PJACKSON',
  366. 'TENNCONS',
  367. 'PBGCONTR',
  368. '213ZESTB',
  369. '30PFDOO',
  370. '30RODGE',
  371. 'LOVE',
  372. 'PAULMUIR',
  373. '320PAUL7',
  374. 'PGM01',
  375. '320MANOR',
  376. '320CONST',
  377. '20HAMPT',
  378. '213PMWJO',
  379. 'PROGERS',
  380. 'PSTOW',
  381. 'PETERMCG',
  382. '20MAUGH',
  383. '30PJWIN',
  384. '5054DESI',
  385. 'KINS01',
  386. 'COOPERMA',
  387. '332LANGF',
  388. 'PORTLETH',
  389. 'RAYMOND',
  390. '104KINGD',
  391. '214STRAT',
  392. '20RHJOI',
  393. 'CLIFFE',
  394. '317TBOYL',
  395. '3335TRAD',
  396. '30BALLR',
  397. '530RSCON',
  398. '30BENCH',
  399. '214ARGYL',
  400. 'RICHIETH',
  401. '540COOKE',
  402. 'RBJOINER',
  403. 'BLACKROB',
  404. 'DWWI01',
  405. 'RTHOMSON',
  406. 'APPLEYAR',
  407. 'MCLEODIN',
  408. '104ROSSQ',
  409. '317ROSSP',
  410. '50KNUTS',
  411. '103RYANB',
  412. 'SANDYROB',
  413. 'SANDYLAW',
  414. 'HOMETECH',
  415. 'TAINJOIN',
  416. 'SDGRANTJ',
  417. '126SBATC',
  418. '1011',
  419. '20EGANS',
  420. 'A1945S',
  421. 'WOODLAND',
  422. 'A2952S',
  423. '40 UA',
  424. '50CHESR',
  425. '40GLAZE',
  426. '317PROGL',
  427. '211THERM',
  428. '550CARTW',
  429. 'JPC001',
  430. '331DOVET',
  431. '202MAXWE',
  432. '20SJPJ',
  433. 'STEPHENL',
  434. ' KNIGH',
  435. 'SCCCONTR',
  436. 'RALSTONP',
  437. 'GATEHOUS',
  438. '334SUREI',
  439. '20CWBUB',
  440. '540BIRCH',
  441. 'A3612S',
  442. 'WINMAN',
  443. '423STEPH',
  444. '425M D',
  445. 'STEVEAST',
  446. 'SSWANSON',
  447. 'ISLAND',
  448. '505HEADS',
  449. '505STEVE',
  450. 'TWIC01',
  451. '3204HEAT',
  452. 'STEVESJO',
  453. 'STEVENFO',
  454. 'RSMJOINE',
  455. '640STEVB',
  456. 'SBGJOINE',
  457. 'CTDL001',
  458. '108ASKHO',
  459. '321MSWIN',
  460. 'STEWROBE',
  461. '50LLOYS',
  462. '209MAXWE',
  463. '211PENTL',
  464. 'EDINKITC',
  465. '101SJRJO',
  466. '50TOTAC',
  467. 'SGCWIND',
  468. '212STUAR',
  469. 'LINDSAYC',
  470. '530DAVES',
  471. '332ABLEC',
  472. '640TERRY',
  473. '30TJASS',
  474. '20LEVEL',
  475. 'ASPENJOI',
  476. '650TIMAY',
  477. '330TPCAR',
  478. '20PDSWI',
  479. '321TOMCU',
  480. 'MACK01',
  481. 'A3564T',
  482. 'WINDOWCA',
  483. '40TDHAN',
  484. 'ABWINDOW',
  485. 'THEGLASS',
  486. 'TREVORBL',
  487. 'G&JWADDE',
  488. '105ROSEB',
  489. '540WAYNE',
  490. '333WSWIN',
  491. 'JD001',
  492. 'WDJOINER',
  493. '101WILLI',
  494. 'BRUDON',
  495. 'WILLISMI',
  496. '108THIST',
  497. 'WILLIAMC',
  498. '101CASTL',
  499. 'VANHODD',
  500. 'ZABJOINE',
  501. '630ZANEK',
  502. 'STEVIENI',
  503. 'NEILPICK',
  504. 'GCORDINE',
  505. 'PAULMITC',
  506. 'WJBJOINE',
  507. 'MACUMMIN',
  508. 'COLINLEW',
  509. 'DAVIDMAS',
  510. 'GRAEMEMU',
  511. 'ALANDONA',
  512. 'GARYTAYL',
  513. 'ABERDEEN',
  514. 'MCGREGOR',
  515. 'SANDAYPR',
  516. 'A.G.GREI',
  517. 'CLARKCON',
  518. 'JOHNGRAY',
  519. 'WGPATERS',
  520. 'GORDONMI',
  521. 'FOTHERIN',
  522. 'ANGUSHOM',
  523. 'BJCJOINE',
  524. 'AMJOINE',
  525. 'NEILMACL',
  526. 'A2016S',
  527. 'A4070S',
  528. 'A2753S',
  529. 'A3920S',
  530. 'A4567S',
  531. 'A1906S',
  532. 'A3922S',
  533. 'A2694S',
  534. 'DOUGIETO',
  535. 'MAXWELLJ',
  536. 'JIMSORLE',
  537. 'ALLGLASS',
  538. 'ROBERTAD',
  539. 'STEVENGR',
  540. 'SAFEHOME',
  541. 'ALECLEE',
  542. 'KRISYULE',
  543. 'NEILGHER',
  544. 'EASTMECK',
  545. 'DAVIDCAR',
  546. 'LUNDIE',
  547. 'DAROBERT',
  548. 'MOIRCONS',
  549. 'COLINLA',
  550. 'PETEMCAR',
  551. 'HOGGANDR',
  552. 'PREMIERA',
  553. 'TOYNTONJ',
  554. 'ADDONDEV',
  555. 'WOODPROP',
  556. 'SCLJOINE',
  557. 'CALDERCO',
  558. 'GRANTSHE',
  559. 'MBWJOINE',
  560. 'A1139S',
  561. 'A1274S',
  562. 'A3701S',
  563. 'PP001',
  564. 'WCSL001',
  565. '7DSCANNE',
  566. 'KING',
  567. 'BVIEW001',
  568. 'MM001',
  569. 'KBJOINER',
  570. '2CJOINER',
  571. 'JOHNST&K',
  572. 'DOUBLGL&',
  573. 'KYLECAIR',
  574. 'GEORGEDI',
  575. 'HUGHRICH',
  576. 'DELUXERO',
  577. 'DOUGLACR',
  578. 'MAUTRA',
  579. 'EUANGRAN',
  580. 'WTAGGART',
  581. 'DUNCANCR',
  582. 'GAWINDOW',
  583. 'GEORGEBA',
  584. 'MCGJOINE',
  585. 'ARMITAGE',
  586. 'WILLIAMK',
  587. 'GTMCONST',
  588. 'JOHNTUR',
  589. 'BUILDIT',
  590. 'JOHNNYDY',
  591. 'JKJOINER',
  592. 'CRAVENIM',
  593. 'WESTLOTH',
  594. 'MARKWHYT',
  595. 'LANARKW&',
  596. 'EWANMACL',
  597. 'ANDREWCO',
  598. 'WILLMOFF',
  599. 'TBISHOP',
  600. 'RIGHTMOV',
  601. 'RGJOINER',
  602. 'CALUMKER',
  603. 'GARRIOCK',
  604. 'AREIDBUI',
  605. 'TCJOINER',
  606. 'W.F.BARK',
  607. 'JOHNBROW',
  608. 'GARLAND',
  609. 'BMDEVELO',
  610. 'WINDOWPL',
  611. 'CLASSWIN',
  612. 'VIEWFORT',
  613. 'COLINSCO',
  614. 'AIRLIES',
  615. 'DEREKBRO',
  616. 'J.W.GLAZ',
  617. 'DBSPEEDG',
  618. 'ALLIANCE',
  619. 'DREVERJO',
  620. 'ANDREWCH',
  621. 'DARRENMU',
  622. 'ALANHERO',
  623. 'RYANWOOD',
  624. 'LOTHGLAS',
  625. 'J.AGLASS',
  626. 'SOUTHGLA',
  627. 'B&NMORRI',
  628. 'ANDYDURH',
  629. 'LSCOBIEJ',
  630. 'RSJOINSE',
  631. 'TAYVALLE',
  632. 'ESHARPJO',
  633. 'GRANTJOI',
  634. 'IANWALL',
  635. 'LAMBERTP',
  636. 'SJRENOVA',
  637. 'W.ANDERS',
  638. 'DICKSONJ',
  639. 'JWOODCON',
  640. 'O\'DONNEL',
  641. 'JTELFERJ',
  642. 'DEREKDAL',
  643. 'AULDROOF',
  644. 'HUGGANJO',
  645. 'HOMETRAD',
  646. 'GHRENOV',
  647. 'MICHAMIL',
  648. 'RUMANREN',
  649. 'RITCHIE',
  650. 'CLAR01',
  651. 'A2397T',
  652. '30SPIR',
  653. '40DECRA',
  654. '20HARWO',
  655. 'WHKNIGHT',
  656. 'A613S',
  657. 'BUSYBUIL',
  658. 'MORRIS01',
  659. 'WINDOWAN',
  660. 'GRAEMEWI',
  661. '108CDNTE',
  662. 'GRL001',
  663. 'A1784S',
  664. 'A1194S',
  665. 'KEITHMAC',
  666. 'BONNYVIE',
  667. 'A3668S',
  668. '40KYLEG',
  669. 'ZIPC01',
  670. '40YORKS',
  671. 'A1747S',
  672. '550WRIGH',
  673. 'RJDB',
  674. 'A2688T',
  675. 'DEESIDET',
  676. '105STUAR',
  677. 'VIC001',
  678. 'COASTALG',
  679. 'A4034S',
  680. 'ELMARJOI',
  681. 'JOCKCHAL',
  682. 'FAIRDEWI',
  683. 'GLENDONC',
  684. 'FOURDESI',
  685. '50ADTIN')
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!