I'm not quite sure I follow what you mean... you're linking all the tables (l, s, c1, and c2) by various columns, so limiting the rows from l where l.sno < 48 should just reduce the final result set returned after linking all the remaining rows. The ORDER BY clause sorts the final results of a query, and said sorting should really be done after that final result set is determined; i.e. AFTER the (l.sno < 48) row filter is applied.
So, i guess my question to you is, what query did you try, exactly, and what was wrong with your results?
If you need further assistance, perhaps you can dump the structure and contents of your tables, and perhaps give a more detailed description of the result set you want so that we can figure out your query.