SELECT `o`.`bpid` as `cid`, MAX(o.id) as varid, MAX(o.name) as name, MAX(o.linkname) as linkname, MAX(o.image) as img, `o`.`price` as `prices`, MAX(o.description) as description
FROM `oio_variation` `o`
LEFT JOIN `oio_businessprofile_var_products_to_category` `oc` ON `oc`.`product_id` = `o`.`id`
WHERE `oc`.`category_id` = '39156'
GROUP BY `o`.`bpid`
ORDER BY RAND()
 LIMIT 100