Table JANE avec une chaise

select distinct(cr.id_cart_rule), cr.*, crpr.type, crprv.id_item from aw_cart_rule cr left join aw_cart_rule_product_rule_group crprg on(crprg.id_cart_rule=cr.id_cart_rule) left join aw_cart_rule_product_rule crpr on(crpr.id_product_rule_group=crprg.id_product_rule_group) left join aw_cart_rule_product_rule_value crprv on(crpr.id_product_rule=crprv.id_product_rule) where cr.active=1 and ( (crpr.type="categories" and crprv.id_item in ( select id_category from aw_category_product where id_product=11419 )) or (crpr.type="products" and crprv.id_item=11419)) and cr.description_produit!="" and ( cr.description!="" or cr.id_cart_rule=9836) and cr.date_from < "2022-05-19 00:55:51" and cr.date_to > "2022-05-19 00:55:51" order by cr.afficher_compteur desc, crpr.type desc 1

Array ( [0] => Array ( [id_cart_rule] => 10834 [id_customer] => 0 [date_from] => 2022-05-12 10:00:00 [date_to] => 2022-05-19 10:00:00 [description] => 500€ OFFERTS dès 5000€ d’achat [quantity] => 9998 [quantity_per_user] => 10 [priority] => 1 [partial_use] => 0 [code] => BOBO500 [minimum_amount] => 5000.00 [minimum_amount_tax] => 1 [minimum_amount_currency] => 1 [minimum_amount_shipping] => 0 [country_restriction] => 0 [carrier_restriction] => 0 [group_restriction] => 0 [cart_rule_restriction] => 1 [product_restriction] => 1 [shop_restriction] => 0 [free_shipping] => 0 [reduction_percent] => 0.00 [reduction_amount] => 500.00 [reduction_tax] => 1 [reduction_currency] => 1 [reduction_product] => 0 [gift_product] => 0 [gift_product_attribute] => 0 [highlight] => 0 [active] => 1 [date_add] => 2022-04-13 15:18:15 [date_upd] => 2022-05-16 14:15:36 [description_produit] => La semaine BOBO - Jusqu’au 19 mai à 10h :

100€ OFFERTS dès 1000€ d’achat avec le code : BOBO100
200€ OFFERTS dès 2000€ d’achat avec le code : BOBO200
300€ OFFERTS dès 3000€ d’achat avec le code : BOBO300
500€ OFFERTS dès 5000€ d’achat avec le code : BOBO500 [description_categorie] => [afficher_compteur] => 1 [compteur_description] => [bg_compteur] => #000000 [texte_blanc] => [imageA] => 20220512100701_background noir.jpg [imageB] => 20220512094424_Timer SB.gif [type] => products [id_item] => 11419 )[1] => Array ( [id_cart_rule] => 10836 [id_customer] => 0 [date_from] => 2022-05-12 10:00:00 [date_to] => 2022-05-19 10:00:00 [description] => 300€ OFFERTS dès 3000€ d’achat [quantity] => 9997 [quantity_per_user] => 10 [priority] => 2 [partial_use] => 0 [code] => BOBO300 [minimum_amount] => 3000.00 [minimum_amount_tax] => 1 [minimum_amount_currency] => 1 [minimum_amount_shipping] => 0 [country_restriction] => 0 [carrier_restriction] => 0 [group_restriction] => 0 [cart_rule_restriction] => 1 [product_restriction] => 1 [shop_restriction] => 0 [free_shipping] => 0 [reduction_percent] => 0.00 [reduction_amount] => 300.00 [reduction_tax] => 1 [reduction_currency] => 1 [reduction_product] => 0 [gift_product] => 0 [gift_product_attribute] => 0 [highlight] => 0 [active] => 1 [date_add] => 2022-04-13 15:44:59 [date_upd] => 2022-05-16 19:36:31 [description_produit] => La semaine BOBO - Jusqu’au 19 mai à 10h :

100€ OFFERTS dès 1000€ d’achat avec le code : BOBO100
200€ OFFERTS dès 2000€ d’achat avec le code : BOBO200
300€ OFFERTS dès 3000€ d’achat avec le code : BOBO300
500€ OFFERTS dès 5000€ d’achat avec le code : BOBO500 [description_categorie] => [afficher_compteur] => 1 [compteur_description] => [bg_compteur] => #000000 [texte_blanc] => [imageA] => 20220512100717_background noir.jpg [imageB] => 20220512093742_Timer SB.gif [type] => products [id_item] => 11419 )[2] => Array ( [id_cart_rule] => 10835 [id_customer] => 0 [date_from] => 2022-05-12 10:00:00 [date_to] => 2022-05-19 10:00:00 [description] => 200€ OFFERTS dès 2000€ d’achat [quantity] => 9982 [quantity_per_user] => 10 [priority] => 3 [partial_use] => 0 [code] => BOBO200 [minimum_amount] => 2000.00 [minimum_amount_tax] => 1 [minimum_amount_currency] => 1 [minimum_amount_shipping] => 0 [country_restriction] => 0 [carrier_restriction] => 0 [group_restriction] => 0 [cart_rule_restriction] => 1 [product_restriction] => 1 [shop_restriction] => 0 [free_shipping] => 0 [reduction_percent] => 0.00 [reduction_amount] => 200.00 [reduction_tax] => 1 [reduction_currency] => 1 [reduction_product] => 0 [gift_product] => 0 [gift_product_attribute] => 0 [highlight] => 0 [active] => 1 [date_add] => 2022-04-13 15:39:54 [date_upd] => 2022-05-18 23:43:45 [description_produit] => La semaine BOBO - Jusqu’au 19 mai à 10h :

100€ OFFERTS dès 1000€ d’achat avec le code : BOBO100
200€ OFFERTS dès 2000€ d’achat avec le code : BOBO200
300€ OFFERTS dès 3000€ d’achat avec le code : BOBO300
500€ OFFERTS dès 5000€ d’achat avec le code : BOBO500 [description_categorie] => [afficher_compteur] => 1 [compteur_description] => [bg_compteur] => #000000 [texte_blanc] => [imageA] => 20220512100821_background noir.jpg [imageB] => 20220512093105_Timer SB.gif [type] => products [id_item] => 11419 )[3] => Array ( [id_cart_rule] => 4950 [id_customer] => 0 [date_from] => 2022-05-12 10:00:00 [date_to] => 2022-05-19 10:00:00 [description] => 100€ OFFERTS dès 1000€ d’achat [quantity] => 9731 [quantity_per_user] => 10 [priority] => 4 [partial_use] => 0 [code] => BOBO100 [minimum_amount] => 1000.00 [minimum_amount_tax] => 1 [minimum_amount_currency] => 1 [minimum_amount_shipping] => 0 [country_restriction] => 0 [carrier_restriction] => 0 [group_restriction] => 0 [cart_rule_restriction] => 1 [product_restriction] => 1 [shop_restriction] => 0 [free_shipping] => 0 [reduction_percent] => 0.00 [reduction_amount] => 100.00 [reduction_tax] => 1 [reduction_currency] => 1 [reduction_product] => 0 [gift_product] => 0 [gift_product_attribute] => 0 [highlight] => 0 [active] => 1 [date_add] => 2020-12-21 15:59:49 [date_upd] => 2022-05-19 00:28:02 [description_produit] => La semaine BOBO - Jusqu’au 19 mai à 10h :

100€ OFFERTS dès 1000€ d’achat avec le code : BOBO100
200€ OFFERTS dès 2000€ d’achat avec le code : BOBO200
300€ OFFERTS dès 3000€ d’achat avec le code : BOBO300
500€ OFFERTS dès 5000€ d’achat avec le code : BOBO500 [description_categorie] => [afficher_compteur] => 1 [compteur_description] => [bg_compteur] => #000000 [texte_blanc] => [imageA] => 20220512100911_background noir.jpg [imageB] => 20220511050045_Timer SB.gif [type] => products [id_item] => 11419 )) 1