How do I override PrestaShop's products class to limit the number of products returned in an SQL query?

How do I override PrestaShop's products class to limit the number of
products returned in an SQL query?

References

Reference NO 1

http://stackoverflow.com/questions/15206303/how-do-i-override-prestashops-products-class-to-limit-the-number-of-products-re

Reference NO 2

http://stackoverflow.com/questions/17898917/display-the-number-of-products-next-to-category-for-prestashop

Reference NO 3

http://doc.prestashop.com/display/PS15/DB+class+best+practices

Reference NO 4

http://www.prestashop.com/forums/index.php?/topic/201563-solvedsort-products-by-price-and-put-out-of-stock-products-at-the-end-of-list/

Reference NO 5

http://blog.belvg.com/new-products-in-prestashop.html

Reference NO 6

http://net.tutsplus.com/tutorials/prestashop-theming-explained/

Reference NO 7

http://bumbu.ru/tags-autocomplete-on-prestashop-product-edit-page/

Reference NO 8

#EANF#