SELECT t2.`id` AS 'id_zamowienia', FROM_UNIXTIME( t2.`data` ) AS 'data zamówienia', t1.`nip`, t1.`imie`, t1.`nazwisko`, FROM_UNIXTIME( t1.`data` ) as 'data_rejestracji', t2.`kwota_platnosci`
FROM `kqs_rejestracja` AS t1
JOIN `kqs_zamowienia` AS t2 ON t1.`user_id` = t2.`u_id`
WHERE t1.`hurtownik` >0
AND MONTH( FROM_UNIXTIME( t2.`data` ) ) =4
AND YEAR( FROM_UNIXTIME( t2.`data` ) ) =2017
AND FROM_UNIXTIME( t1.`data` ) > DATE_ADD(FROM_UNIXTIME( t2.`data` ), INTERVAL -1 YEAR)