Query: SELECT * FROM #__virtuemart_cdp WHERE ((end = "0000-00-00 00:00:00") OR (NOW() BETWEEN start AND end)) AND state = 1

Master: 162

Mastercategories:

Query getCategoriesByProductID: SELECT virtuemart_category_id FROM #__virtuemart_product_categories WHERE virtuemart_product_id = 161

Category: 4

Mastercategory:

Mastercategories: 4

Mastercategory: 4

Master: 154,155,170,204,300,1200

Mastercategories: 7

Mastercategory: 7

Query: SELECT * FROM #__virtuemart_cdp WHERE id = 2

Products: ["1212"]

Calling reorder by SKU:

Reorder by query: SELECT virtuemart_product_id FROM #__virtuemart_products_en_gb WHERE virtuemart_product_id IN (1212) ORDER BY product_name ASC

Query for discount by rule: SELECT discount FROM #__virtuemart_cdp WHERE id = 2

Query for discount type by rule: SELECT discount_type FROM #__virtuemart_cdp WHERE id = 2

Query: SELECT p.`product_name`,ps.`product_sku`,m.`virtuemart_media_id`,mu.`file_url` FROM `#__virtuemart_products_en_gb` AS p LEFT JOIN #__virtuemart_products AS ps ON ps.`virtuemart_product_id`= p.`virtuemart_product_id` LEFT JOIN #__virtuemart_product_medias AS m ON m.`virtuemart_product_id`= p.`virtuemart_product_id` LEFT JOIN #__virtuemart_medias AS mu ON mu.`virtuemart_media_id`= m.`virtuemart_media_id` WHERE p.virtuemart_product_id ='1212' AND ps.published = 1 LIMIT 1