In this blog post, you will be presented with MySQL booking database schema. You will also see examples of SQL calls to insert and validate a new booking request. At the end of this post, you will find the post on the logic behind this database and SQL queries...
Report 1 – Query sum of the products sold each month for each category in PrestaShop. Prestashop tabels: [ps_order_detail], [ps_orders], [ps_product], [ps_order_history] Combine aggregation function such as COCNAT and YEAR and DATE with multiple GROUP BY...
The above diagram can not fully represent JOIN charasteristicks due to its limitations. MySQL JOIN – (INNER JOIN) query result description characteristics:sequence – dos not matterchaining – dos not mater MySQL LEFT JOIN – (LEFT OUTER JOIN)...
Reading this article you will learn what are default prestashop module and how to disable non default modules or any module of your choice using simple SQL query. Default modules list installed with PrestaShop 1.7.7.5 SELECT GROUP_CONCAT(name ORDER BY id_module...
Trying to move all products from one category to another in PrestaShop? Play with this sql: https://paiza.io/projects/ujEXdIzx008UEPYKziQWkQ?language=mysql. (Note to remove comments as they may trigger SQL errors in this online application) /* author: Wiktor...