string(0) "" string(7315) "SELECT ( SELECT customizations_code_value FROM customizations_code WHERE customizations_code_id = P.customizations_code_id ) as codigo_maquina, P.products_id, PD.products_name, PD.products_description, PD.ai, PD.publicar, P.products_quantity, P.products_type, P.products_cost_price, IFNULL(s.specials_new_products_price, P.products_price_text) precio_final, P.products_price_text, P.barcode, P.es_promocion, P.btn_visible_solo_comerciales, P.barcodeGenerate, P.manufacturers_id, ( SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id=P.manufacturers_id LIMIT 1 ) manufacturers_name, P.products_reorder_level, P.ref_fabricante, P.customization, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_med, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_lrg, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_sm_1, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_xl_1, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=2 LIMIT 1), NULL) as products_image_sm_2, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=2 LIMIT 1), NULL) as products_image_xl_2, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=3 LIMIT 1), NULL) as products_image_sm_3, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=3 LIMIT 1), NULL) as products_image_xl_3, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=4 LIMIT 1), NULL) as products_image_sm_4, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=4 LIMIT 1), NULL) as products_image_xl_4, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=5 LIMIT 1), NULL) as products_image_sm_5, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=5 LIMIT 1), NULL) as products_image_xl_5, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=6 LIMIT 1), NULL) as products_image_sm_6, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=6 LIMIT 1), NULL) as products_image_xl_6, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=7 LIMIT 1), NULL) as products_image_sm_7, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=7 LIMIT 1), NULL) as products_image_xl_7, IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_list, IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_detail, NULL as products_image_video, P.products_embed_video, P.showPreview, P.is_exclusive, P.products_production_days, P.dias_produccion_a_causa_de, DATE_FORMAT(P.products_date_available, '%Y-%m-%d') products_date_available, P.products_model, P.products_status, P.products_date_added, P.customizations_code_id, P.products_color_rgb, P.products_tax_class_id, s.status as specstat, s.specials_new_products_price specials_new_products_price, P.products_tasks, P.puntos, P.sumar_personalizacion, P.ref_catalogo, ISNULL(fp.products_id) as disponibleFueraUE, P.es_dropshipping, P.meses_min, P.meses_max, 0 discount, P.es_producto_manufacturado as PERSONALIZADO, ROUND((1 - s.specials_new_products_price / P.products_price_text) * 100, -1) AS descuento FROM products P INNER JOIN products_description PD ON P.products_id = '97826' AND PD.language_id = '9' AND PD.products_id = P.products_id LEFT JOIN filtros_products fp ON P.products_id = fp.products_id AND fp.filtros_id = '97' #Filtro 97 = 'soloDisponibleEnUE' LEFT JOIN specials s ON P.products_id = s.products_id AND s.status=1 AND (s.expires_date>now() OR s.expires_date='0000-00-00 00:00:00') AND s.es_vip = 0 LEFT JOIN specials svip ON P.products_id = svip.products_id AND svip.status=1 AND (svip.expires_date>now() OR svip.expires_date='0000-00-00 00:00:00') AND svip.es_vip = 1 WHERE P.products_type!='4' AND P.products_type!='8' group by P.products_id "
The day has arrived, the digging moles must prove their skills and succeed in extracting the best gems. Use your intention and don't get distracted chatting with the other moles!
How to play:
During the round, all players observe the gems available in each mine and, therefore, the potential points they can earn. Then, simultaneously, each player chooses which mine to dig, using one of the five cards of their choice, placing it face down on their side of the table.
Once everyone has chosen, the cards are flipped over simultaneously and two situations can occur:
Unique choice: if a player has chosen a mine that no one else has selected, they are lucky! They had a productive workday and take all the gems from that mine to their side of the table.
Coincidence: if two or more players choose the same mine, they are distracted moles who do not get any gems.
To finish the round, players will retrieve their Mine Choice card and draw from the envelope the gems from the mines they need. And remember, always without looking!
- Material: cardboard
- Number of players: from 2 to 4
- Playtime approximately: 20 minutes
- Package dimensions: 13.5 x 29 x 6.5 cm
- Author: Raúl López
- Illustrator: Lorena Gestido
- Available languages: ESP/EN/FR/PT/IT
- From 6 years old