Put LIMIT and ORDER in sql join?

PHP
1

I want put LIMIT and ORDER, in following query. how is it?

ORDER BY tour_foreign.id asc
LIMIT $offset, $coun_page

In the this query:

SELECT
		       @rownum := @rownum + 1 rownum,
		       tour_foreign.id, 
		       tour_foreign.name,
		       tour_foreign.airline,
		       MIN(tour_foreign_residence.name_re) AS name_re, 
		       tour_foreign.service, 
		       tour_foreign.date_go, 
		       tour_foreign.date_back, 
		       tour_foreign.term,
		       tour_foreign.useradmin_submit,
		       tour_foreign.date_submit,
		       GROUP_CONCAT( tour_foreign_residence.name_re 
				     ORDER BY tour_foreign_residence.name_re 
				     SEPARATOR '، '
				   ) AS name_re_all
		    FROM   tour_foreign 
		      INNER JOIN tour_foreign_residence 
			ON ( tour_foreign.id = tour_foreign_residence.relation )
		      JOIN (SELECT @rownum := 0) r
		    GROUP BY  tour_foreign.id		    
		    HAVING name LIKE '%" . $find . "%'
		    OR 	airline LIKE '%" . $find . "%'
		    OR 	name_re_all LIKE '%" . $find . "%'
		    OR 	service LIKE '%" . $find . "%'
		    OR 	date_go LIKE '%" . $find . "%'
		    OR 	date_back LIKE '%" . $find . "%'
		    OR 	term LIKE '%" . $find . "%'
		    OR 	useradmin_submit LIKE '%" . $find . "%'
		    OR 	date_submit LIKE '%" . $find . "%'
2

Put it at the end of the query.

3

Thanks, i have a other problem with rownum, i have in database tour_foreign three row and should rownum is this: 1, 2, 3 but it is: 12, 13, 14. Did you know how should fix it?