I need to select the popular products from a list of products. mshop_product is the database table name for the list of products. But here, there is no field marked as popular product or something like that. Is there a way to fetch the popular products from the database table? If so, which is that table and the corresponding table name?
Are you talking about Promotions? If yes, have a look at typo3conf/ext/aimeos/Resources/private/Extensions/ai-client-html/client/html/src/Client/Html/Catalog/Lists/Promo/Standard.php. There you find the filter params in the function setViewParams on the bottom of the code.
The related tables are mshop_catalog, mshop_catalog_list, mshop_catalog_list_type and mshop_product.