a guest Dec 13th, 2018 59 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT,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 AND p.foglalas_tipus IN('H','E')
  4.            LEFT JOIN irodas_munkahely AS im2 ON AND p.tipus=15
  5.            INNER JOIN irodas_munkahely AS im ON
  6.            INNER JOIN penztar_tipus AS t ON
  7.            INNER JOIN foglalas_fizetes AS f ON
  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