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 = 1201
Category: 3
Mastercategory:
Mastercategories: 4
Mastercategory: 4
Master: 154,155,170,204,300,1200
Mastercategories: 7
Mastercategory: 7