SHARE
TWEET

Untitled

a guest Dec 13th, 2018 59 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT p.id,from_unixtime(p.ido) AS Mikor, t.nev AS Penzmozgás, f.nev AS Fizetesimód, IFNULL(im2.nev, '') AS `Fogadó pénztár`, CONCAT(p.szoveg1, ' ', p.szoveg2) AS `Pénztár megjegyzés`, IFNULL(CONCAT(pf.szoveg, ' ', pf.szovegSzerk), '') AS `Foglalás megjegyzés`, p.forint, p.euro, p.dollar, p.netto, concat(u.lastname,' ',u.firstname) AS Beírta
  2.            FROM penztar AS p
  3.            LEFT JOIN program_foglalas AS pf ON pf.id=p.foglalas_id AND p.foglalas_tipus IN('H','E')
  4.            LEFT JOIN irodas_munkahely AS im2 ON im2.id=p.foglalas_id AND p.tipus=15
  5.            INNER JOIN irodas_munkahely AS im ON im.id=p.munkahely
  6.            INNER JOIN penztar_tipus AS t ON p.tipus=t.id
  7.            INNER JOIN foglalas_fizetes AS f ON p.fizetesimod=f.id
  8.            INNER JOIN utca_users AS u ON p.modositotta=u.userid
  9.            WHERE p.deleted=0 AND p.munkahely='11' AND from_unixtime(p.ido) >= '2016-01-01' AND from_unixtime(p.ido) <= '2016-08-31' ORDER BY p.ido DESC
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