Query Joins

<?php
$query = "
			SELECT
				flowers.id AS fid
				flowers.artikelnrg AS ag,
				flowers.artikelnrk as ak,
				flowers.qty1, 
				flowers.qty2,
				flowers.price1,
				flowers.price2,
				flowers.special,
				flowers.price12,
				flowers.price22,
				payments.id AS pid,
				payments.quantitysmall,
				payments.quantitybig,
				payments.date,
				paymentsnote.note,
				paymentsnote.datum
			FROM
				payments
			LEFT JOIN
				flowers
			ON 
				(flowers.id = payments.flower_id)
			LEFT JOIN
				paymentsnote
			ON
				(paymentsnote.customer_id = ".$id."),
				(paymentsnote.datum = payments.date)
			WHERE
				done = 0
			AND
				date = NOW()
			AND
				customer_id = ".$id);
?>

<?php
$query = "
			SELECT
				flowers.id AS fid
				flowers.artikelnrg AS ag,
				flowers.artikelnrk as ak,
				flowers.qty1, 
				flowers.qty2,
				flowers.price1,
				flowers.price2,
				flowers.special,
				flowers.price12,
				flowers.price22,
				payments.id AS pid,
				payments.quantitysmall,
				payments.quantitybig,
				payments.date,
				paymentsnote.note,
				paymentsnote.datum
			FROM
				payments
			LEFT JOIN
				flowers
			ON 
				(flowers.id = payments.flower_id)
			LEFT JOIN
				paymentsnote
			ON
				(paymentsnote.customer_id = ".$id."),
				(paymentsnote.datum = payments.date)
			WHERE
				done = 0
			AND
				date = NOW()
			AND
				customer_id = ".$id);
?>

            FROM
                payments
            LEFT JOIN
                flowers
            ON 
                 (flowers.id = payments.flower_id)
            LEFT JOIN
                paymentsnote
            ON
                (paymentsnote.customer_id = payments.customer_id
                    AND
                 paymentsnote.datum = payments.date)
            WHERE
                done = 0
            AND
                date = NOW()
            AND
                payments.customer_id = ".$id);

FROM
                payments
            LEFT JOIN
                flowers
            ON 
                 (flowers.id = payments.flower_id)
            LEFT JOIN
                paymentsnote
            ON
                (paymentsnote.customer_id = payments.customer_id
                    AND
                 paymentsnote.datum = payments.date)
            WHERE
                done = 0
            AND
                date = NOW()
            AND
                payments.customer_id = ".$id);