(SELECT SQL_CALC_FOUND_ROWS a.`agent`, v.`owner`, v.`make`, v.`model`, v.`year`, v.`version`, v.`price`, v.`pic1`, v.`id`, v.`doors`, v.`miles`, v.`transmission`, v.`title`, v.`typevend`, v.`telephone`, v.`date_listing`, '0' AS a_discuter FROM `vehicles` v LEFT JOIN `agents` a  ON v.`owner`=a.`id` WHERE v.`id` > '0'  AND ( `year` BETWEEN vendu/Hino-occasions AND vendu/Hino-occasions )) UNION (SELECT "" as agent, "0" AS owner, v2.`marque` as make, v2.`modele` as model, v2.`annee` as year, v2.`version`, v2.`prix` as price, v2.`photo1` as pic1, v2.`id`, v2.`porte` as doors, v2.`kilometrage` as miles, v2.`transmission`, v2.`titre` as title, "1" as typevend, a2.`telephone`, v2.`date_listing`,v2.`a_discuter` FROM `vehicule_particulier` v2 LEFT JOIN `particulier` a2 ON v2.`id_particulier`=a2.`id` WHERE v2.`id` > "0"  AND ( `annee` BETWEEN vendu/Hino-occasions AND vendu/Hino-occasions ))ORDER BY `price` DESC LIMIT 0,15->