A PHP Error was encountered

Severity: 8192

Message: Function create_function() is deprecated

Filename: geshi/geshi.php

Line Number: 4698

Backtrace:

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 4698
Function: _error_handler

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 4621
Function: _optimize_regexp_list_tokens_to_string

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 1655
Function: optimize_regexp_list

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 2029
Function: optimize_keyword_group

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 2168
Function: build_parse_cache

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/Process.php
Line: 45
Function: parse_code

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/models/Pastes.php
Line: 517
Function: syntax

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/controllers/Main.php
Line: 693
Function: getPaste

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/index.php
Line: 315
Function: require_once

Re: Untitled - Stikked
Stikked

Re: Untitled

From Ivory Hedgehog, 11 Years ago, written in SQL.
This paste is a reply to Untitled from Insensitive Teal - view diff
URL http://geopaste.scratchbook.ch/view/c58ef101
Embed
Download Paste or View Raw
  1. SELECT --distinct LPBELNR,
  2. *
  3. --BPSTUECK,
  4. --aranummer,
  5. --BPPOSNR,
  6.  
  7. FROM mention.dbo.ael ael
  8. LEFT JOIN mention.dbo.AELLIEF lief ON ael.ARIDNR=lief.ALIDNR AND lief.ALMANKEY=1
  9. LEFT JOIN mention.dbo.BESTLP kp ON ael.ARIDNR=kp.LPBELNR AND kp.LPMANKEY=1
  10. LEFT JOIN mention.dbo.BESTLK rk ON kp.LPBELNR=rk.LBBELNR
  11. WHERE lief.ALLNUMMER='71000001'
  12. --and BSBELTYP='B' and bsoffen<>'R'

Reply to "Re: Untitled"