Trofeu Cristal C055

SELECT DISTINCT prod.no_mlm_credit_for_this,prod.is_voucher,
					   prod.ws_contact_for_price,prod.not_discountable,
					   prod.min_cant_um1_pr_comenzi_os,prod.oversell,prod.um2_factor,
					   prod.cod_varianta,
					   prod.product_group_title,
					   prod.product_group_title,
					   prod.meta_kw,
					   prod.meta_kw,
					   prod.is_new,
					   prod.ordercol,
					   prod.meta_description,
					   prod.meta_description,
					   img.rec_id as img_id,img.file_name,img_desc.description_text,
					   um.den as um1_txt,um2.den as um2_txt,
					   sts.status_text as sts_text,
					   prod.product_group_description,
					   prod.product_short_description,
					   prod.producator_txt,prod.producator_id,
					   pr_publ_index.is_promo,
					   prod.last_modified_ts,
					   prod.ws_badge_id,
					   IF(npnpromo.rec_id IS NOT NULL,1,0) AS has_npn_promo,
					   npnpromo.promo_name AS npn_promo_name,
					   npnpromo.nr_condition_products_in_cart AS npn_nr_condition_products_in_cart,
					   npnpromo.nr_produse_bonus AS npn_nr_produse_bonus,
					   warr.txt AS warranty_period
					   
					   ,ccind3.*
					   
					    ,cate.parents_cache AS cat_parents_cache,cate.category_name, cate.rec_id AS web_cat_id, cate.google_category_id 

				FROM product_groups_777 AS prod
				JOIN product_site_publication_index_777 AS pr_publ_index
					ON pr_publ_index.product_id=prod.cod_varianta AND pr_publ_index.is_published
						AND pr_publ_index.site_id = '81'
				LEFT JOIN cat_produse_web_index_777 as cwpi ON cwpi.product_id=prod.cod_varianta
				LEFT JOIN poze_produse_777 AS img ON prod.cod_varianta=img.produs_id 
															AND NOT img.hidden
															AND img.poza_principala
				LEFT JOIN images_descriptions_777 AS img_desc on img_desc.image_id=img.rec_id
				LEFT JOIN UM_777 AS um ON um.rec_id=prod.um1_id
				LEFT JOIN UM_777 AS um2 ON um2.rec_id=prod.um2_id
				LEFT JOIN fisademagazie_stoc_statuses_777 AS sts ON sts.rec_id=prod.status_id
				LEFT JOIN sale_promo_nplusone_condition_products_777 AS promo_cond_prod
					ON promo_cond_prod.cod_varianta = prod.cod_varianta
				LEFT JOIN sale_promo_nplusone_777 AS npnpromo
					ON npnpromo.rec_id = promo_cond_prod.promo_id
						AND npnpromo.active
						AND NOT npnpromo.archived
						AND NOW() BETWEEN npnpromo.promo_start AND npnpromo.promo_end
				LEFT JOIN warranty_periods_777 AS warr
					ON warr.rec_id = prod.warranty_period_id
				 JOIN categorii_produse_web_777 AS cate
					ON cwpi.cat_id=cate.rec_id 
						AND NOT cate.cat_deleted 

				WHERE NOT prod.deleted AND
				((1  AND cwpi.cat_id IN (36)) )
				GROUP BY prod.cod_varianta
				ORDER BY  RAND() LIMIT 0,5