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