Array
(
    [status] => 1
    [message] => Event Product List
    [event_details] => Array
        (
            [id] => 61
            [event_name] => Personalised
            [event_description] => 
            [event_banner_img] => 
            [colorcode] => 
            [events_message] => Array
                (
                    [0] => Array
                        (
                            [id] => 1585
                            [event_id] => 61
                            [message] => Personalised
                            [status] => 1
                            [added_by] => 1
                            [added_on] => 2025-10-29 17:18:47
                        )

                )

        )

    [productlist] => Array
        (
            [0] => Array
                (
                    [store_id] => 1
                    [stock] => 1000
                    [varient_id] => 444
                    [product_id] => 444
                    [product_name] => Blueberry Almond and California Pistachio Crisps
                    [product_image] => /images/bulk_product/56/Blueberry-Almond-and-California-Pistachio-Crisps.png
                    [thumbnail] => 
                    [description] => <p>Introducing our dynamic duo of California Pistachio Crunch and Blueberry Almond Crisps:&nbsp;</p><p>California Pistachio Crunch offers a crispy, protein-packed delight with freshly selected green pistachios, infused with sweet brown rice syrup and sprinkled with mineral-rich Himalayan salt. Meanwhile, Blueberry Almond Crisps bring together juicy blueberries and crunchy California almonds, boasting Vitamin E and antioxidants, accented with authentic Himalayan Pink Salt.</p><p>Indulge guilt-free in these preservative-free, cholesterol-less snacks, each offering a burst of flavor and nutrition. Don't miss out on this perfect pairing of wholesome goodness and delightful taste sensations!</p>
                    [price] => 45
                    [mrp] => 50
                    [varient_image] => N/A
                    [unit] => 0.17
                    [quantity] => 2
                    [type] => Regular
                    [delivery] => 3
                    [discountper] => 10
                    [avgrating] => 0
                    [countrating] => 0
                    [is_subscription] => 1
                    [isFavourite] => false
                    [cart_qty] => 0
                    [images] => Array
                        (
                            [0] => Array
                                (
                                    [product_id] => 444
                                    [image] => /images/bulk_product/56/Blueberry-Almond-and-California-Pistachio-Crisps.png
                                )

                            [1] => Array
                                (
                                    [product_id] => 444
                                    [image] => /images/product/22-04-2024/California-pistachio.jpg
                                )

                            [2] => Array
                                (
                                    [product_id] => 444
                                    [image] => /images/product/22-04-2024/Blueberry-almond.jpg
                                )

                        )

                    [tags] => Array
                        (
                            [0] => Array
                                (
                                    [tag_id] => 2240
                                    [product_id] => 444
                                    [tag] => Blueberry
                                )

                            [1] => Array
                                (
                                    [tag_id] => 2241
                                    [product_id] => 444
                                    [tag] =>  almonds
                                )

                            [2] => Array
                                (
                                    [tag_id] => 2242
                                    [product_id] => 444
                                    [tag] =>  dry fruits
                                )

                            [3] => Array
                                (
                                    [tag_id] => 2243
                                    [product_id] => 444
                                    [tag] =>  crunch
                                )

                            [4] => Array
                                (
                                    [tag_id] => 2244
                                    [product_id] => 444
                                    [tag] =>  crisps
                                )

                            [5] => Array
                                (
                                    [tag_id] => 2245
                                    [product_id] => 444
                                    [tag] =>  pistachio
                                )

                        )

                )

            [1] => Array
                (
                    [store_id] => 23
                    [stock] => 1000
                    [varient_id] => 1077
                    [product_id] => 1077
                    [product_name] => Acqua Di Parisis Delanoe
                    [product_image] => /images/bulk_product/126/Acqua-Di-Parisis-Delanoe-EDP-100-ml.jpg
                    [thumbnail] => 
                    [description] => Acqua Di Parisis Delanoe Eau de Parfum for Women 100ml
                    [price] => 62
                    [mrp] => 78
                    [varient_image] => N/A
                    [unit] => 1
                    [quantity] => 1
                    [type] => Regular
                    [delivery] => 3
                    [discountper] => 20.512820512821
                    [avgrating] => 0
                    [countrating] => 0
                    [is_subscription] => 1
                    [isFavourite] => false
                    [cart_qty] => 0
                    [images] => Array
                        (
                            [0] => Array
                                (
                                    [product_id] => 1077
                                    [image] => /images/bulk_product/126/Acqua-Di-Parisis-Delanoe-EDP-100-ml.jpg
                                )

                        )

                    [tags] => Array
                        (
                            [0] => Array
                                (
                                    [tag_id] => 3881
                                    [product_id] => 1077
                                    [tag] => perfumes
                                )

                            [1] => Array
                                (
                                    [tag_id] => 3882
                                    [product_id] => 1077
                                    [tag] =>  perfume
                                )

                        )

                )

            [2] => Array
                (
                    [store_id] => 23
                    [stock] => 1000
                    [varient_id] => 1236
                    [product_id] => 1236
                    [product_name] => Amouroud Safran Rare EDP 100 ml
                    [product_image] => /images/bulk_product/142/Amouroud-Safran-Rare-EDP-100-ml.jpg
                    [thumbnail] => 
                    [description] => Amouroud Safran Rare by Amouroud EAU DE PARFUM SPRAY UNISEX
                    [price] => 287
                    [mrp] => 300
                    [varient_image] => N/A
                    [unit] => 1
                    [quantity] => 1
                    [type] => Regular
                    [delivery] => 3
                    [discountper] => 4.3333333333333
                    [avgrating] => 0
                    [countrating] => 0
                    [is_subscription] => 1
                    [isFavourite] => false
                    [cart_qty] => 0
                    [images] => Array
                        (
                            [0] => Array
                                (
                                    [product_id] => 1236
                                    [image] => /images/bulk_product/142/Amouroud-Safran-Rare-EDP-100-ml.jpg
                                )

                        )

                    [tags] => Array
                        (
                            [0] => Array
                                (
                                    [tag_id] => 4309
                                    [product_id] => 1236
                                    [tag] => perfumes
                                )

                        )

                )

            [3] => Array
                (
                    [store_id] => 23
                    [stock] => 1000
                    [varient_id] => 1287
                    [product_id] => 1287
                    [product_name] => Women Secret Eau My Delice 2pcs Set
                    [product_image] => /images/bulk_product/143/103.jpg
                    [thumbnail] => 
                    [description] => Women Secret Eau My Delice 2pcs (EDT 100ml+B/L 200ml) Set
                    [price] => 63
                    [mrp] => 72
                    [varient_image] => N/A
                    [unit] => 1
                    [quantity] => 1
                    [type] => Regular
                    [delivery] => 3
                    [discountper] => 12.5
                    [avgrating] => 0
                    [countrating] => 0
                    [is_subscription] => 1
                    [isFavourite] => false
                    [cart_qty] => 0
                    [images] => Array
                        (
                            [0] => Array
                                (
                                    [product_id] => 1287
                                    [image] => /images/bulk_product/143/103.jpg
                                )

                        )

                    [tags] => Array
                        (
                            [0] => Array
                                (
                                    [tag_id] => 4364
                                    [product_id] => 1287
                                    [tag] => women perfume
                                )

                        )

                )

            [4] => Array
                (
                    [store_id] => 23
                    [stock] => 1000
                    [varient_id] => 1333
                    [product_id] => 1333
                    [product_name] => My Burberry Blush EDP 90 ml
                    [product_image] => /images/bulk_product/144/Burberry-My-Burberry-Blush-EDP-W-90-ml.jpg
                    [thumbnail] => 
                    [description] => My Burberry Blush by Burberry EDP For Women.
                    [price] => 281
                    [mrp] => 300
                    [varient_image] => N/A
                    [unit] => 1
                    [quantity] => 1
                    [type] => Regular
                    [delivery] => 3
                    [discountper] => 6.3333333333333
                    [avgrating] => 0
                    [countrating] => 0
                    [is_subscription] => 1
                    [isFavourite] => false
                    [cart_qty] => 0
                    [images] => Array
                        (
                            [0] => Array
                                (
                                    [product_id] => 1333
                                    [image] => /images/bulk_product/144/Burberry-My-Burberry-Blush-EDP-W-90-ml.jpg
                                )

                        )

                    [tags] => Array
                        (
                            [0] => Array
                                (
                                    [tag_id] => 4411
                                    [product_id] => 1333
                                    [tag] => perfumes
                                )

                            [1] => Array
                                (
                                    [tag_id] => 6488
                                    [product_id] => 1333
                                    [tag] => My Burberry Blush EDP 90 ml
                                )

                        )

                )

            [5] => Array
                (
                    [store_id] => 23
                    [stock] => 1000
                    [varient_id] => 1334
                    [product_id] => 1334
                    [product_name] => Burberry Touch EDT 100 ml
                    [product_image] => /images/bulk_product/144/Burberry-Touch-M-EDT-100-ml.jpg
                    [thumbnail] => 
                    [description] => Burberry Touch by Burberry EDT For Men.
                    [price] => 125
                    [mrp] => 145
                    [varient_image] => N/A
                    [unit] => 1
                    [quantity] => 1
                    [type] => Regular
                    [delivery] => 3
                    [discountper] => 13.793103448276
                    [avgrating] => 0
                    [countrating] => 0
                    [is_subscription] => 1
                    [isFavourite] => false
                    [cart_qty] => 0
                    [images] => Array
                        (
                            [0] => Array
                                (
                                    [product_id] => 1334
                                    [image] => /images/bulk_product/144/Burberry-Touch-M-EDT-100-ml.jpg
                                )

                        )

                    [tags] => Array
                        (
                            [0] => Array
                                (
                                    [tag_id] => 4412
                                    [product_id] => 1334
                                    [tag] => perfumes
                                )

                            [1] => Array
                                (
                                    [tag_id] => 6487
                                    [product_id] => 1334
                                    [tag] => Burberry Touch EDT 100 ml
                                )

                        )

                )

            [6] => Array
                (
                    [store_id] => 23
                    [stock] => 1000
                    [varient_id] => 1336
                    [product_id] => 1336
                    [product_name] => Burberry Weekend EDT 100 ml
                    [product_image] => /images/bulk_product/144/Burberry-Weekend-M-EDT-100-ml.jpg
                    [thumbnail] => 
                    [description] => Weekend by Burberry EDT For Men.
                    [price] => 118
                    [mrp] => 130
                    [varient_image] => N/A
                    [unit] => 1
                    [quantity] => 1
                    [type] => Regular
                    [delivery] => 3
                    [discountper] => 9.2307692307692
                    [avgrating] => 0
                    [countrating] => 0
                    [is_subscription] => 1
                    [isFavourite] => false
                    [cart_qty] => 0
                    [images] => Array
                        (
                            [0] => Array
                                (
                                    [product_id] => 1336
                                    [image] => /images/bulk_product/144/Burberry-Weekend-M-EDT-100-ml.jpg
                                )

                        )

                    [tags] => Array
                        (
                            [0] => Array
                                (
                                    [tag_id] => 4414
                                    [product_id] => 1336
                                    [tag] => perfumes
                                )

                            [1] => Array
                                (
                                    [tag_id] => 6485
                                    [product_id] => 1336
                                    [tag] => Burberry Weekend EDT 100 ml
                                )

                        )

                )

            [7] => Array
                (
                    [store_id] => 23
                    [stock] => 1000
                    [varient_id] => 1392
                    [product_id] => 1392
                    [product_name] => Carolina Herrera Bad Boy Extreme EDP 100ml
                    [product_image] => /images/bulk_product/147/Carolina-Herrera-Bad-Boy-Extreme-EDP-100ml.jpg
                    [thumbnail] => 
                    [description] => Ch Bad Boy Extreme by Carolina Herrera EDP For Men.
                    [price] => 275
                    [mrp] => 289
                    [varient_image] => N/A
                    [unit] => 1
                    [quantity] => 1
                    [type] => Regular
                    [delivery] => 3
                    [discountper] => 4.8442906574394
                    [avgrating] => 0
                    [countrating] => 0
                    [is_subscription] => 1
                    [isFavourite] => false
                    [cart_qty] => 0
                    [images] => Array
                        (
                            [0] => Array
                                (
                                    [product_id] => 1392
                                    [image] => /images/bulk_product/147/Carolina-Herrera-Bad-Boy-Extreme-EDP-100ml.jpg
                                )

                        )

                    [tags] => Array
                        (
                            [0] => Array
                                (
                                    [tag_id] => 4482
                                    [product_id] => 1392
                                    [tag] => perfumes
                                )

                            [1] => Array
                                (
                                    [tag_id] => 6442
                                    [product_id] => 1392
                                    [tag] => Carolina Herrera Bad Boy Extreme EDP 100ml
                                )

                        )

                )

            [8] => Array
                (
                    [store_id] => 23
                    [stock] => 1000
                    [varient_id] => 1393
                    [product_id] => 1393
                    [product_name] => Carolina Herrera Bad Boy Gold Fantasy EDT 100 ml
                    [product_image] => /images/bulk_product/147/Carolina-Herrera-Bad-Boy-Gold-Fantasy-EDT-M-100-ml.jpg
                    [thumbnail] => 
                    [description] => Ch Bad Boy Gold Fantasy by Carolina Herrera EDT For Men.
                    [price] => 281
                    [mrp] => 295
                    [varient_image] => N/A
                    [unit] => 1
                    [quantity] => 1
                    [type] => Regular
                    [delivery] => 3
                    [discountper] => 4.7457627118644
                    [avgrating] => 0
                    [countrating] => 0
                    [is_subscription] => 1
                    [isFavourite] => false
                    [cart_qty] => 0
                    [images] => Array
                        (
                            [0] => Array
                                (
                                    [product_id] => 1393
                                    [image] => /images/bulk_product/147/Carolina-Herrera-Bad-Boy-Gold-Fantasy-EDT-M-100-ml.jpg
                                )

                        )

                    [tags] => Array
                        (
                            [0] => Array
                                (
                                    [tag_id] => 4483
                                    [product_id] => 1393
                                    [tag] => perfumes
                                )

                            [1] => Array
                                (
                                    [tag_id] => 6441
                                    [product_id] => 1393
                                    [tag] => Carolina Herrera Bad Boy Gold Fantasy EDT 100 ml
                                )

                        )

                )

            [9] => Array
                (
                    [store_id] => 23
                    [stock] => 1000
                    [varient_id] => 1394
                    [product_id] => 1394
                    [product_name] => Carolina Herrera Bad Boy Le Parfum EDP 100 ml
                    [product_image] => /images/bulk_product/147/Carolina-Herrera-Bad-Boy-Le-Parfum-EDP-100-ml.jpg
                    [thumbnail] => 
                    [description] => CH Bad Boy Le Parfum by Carolina Herrera EDP For Men.
                    [price] => 268
                    [mrp] => 280
                    [varient_image] => N/A
                    [unit] => 1
                    [quantity] => 1
                    [type] => Regular
                    [delivery] => 3
                    [discountper] => 4.2857142857143
                    [avgrating] => 0
                    [countrating] => 0
                    [is_subscription] => 1
                    [isFavourite] => false
                    [cart_qty] => 0
                    [images] => Array
                        (
                            [0] => Array
                                (
                                    [product_id] => 1394
                                    [image] => /images/bulk_product/147/Carolina-Herrera-Bad-Boy-Le-Parfum-EDP-100-ml.jpg
                                )

                        )

                    [tags] => Array
                        (
                            [0] => Array
                                (
                                    [tag_id] => 4484
                                    [product_id] => 1394
                                    [tag] => perfumes
                                )

                            [1] => Array
                                (
                                    [tag_id] => 6440
                                    [product_id] => 1394
                                    [tag] => Carolina Herrera Bad Boy Le Parfum EDP 100 ml
                                )

                        )

                )

            [10] => Array
                (
                    [store_id] => 23
                    [stock] => 1000
                    [varient_id] => 1395
                    [product_id] => 1395
                    [product_name] => Carolina Herrera CH EDT 100 ml
                    [product_image] => /images/bulk_product/147/Carolina-Herrera-CH-EDT-W-100-ml.jpg
                    [thumbnail] => 
                    [description] => CH by Carolina Herrera EDT For Women.
                    [price] => 231
                    [mrp] => 242
                    [varient_image] => N/A
                    [unit] => 1
                    [quantity] => 1
                    [type] => Regular
                    [delivery] => 3
                    [discountper] => 4.5454545454545
                    [avgrating] => 0
                    [countrating] => 0
                    [is_subscription] => 1
                    [isFavourite] => false
                    [cart_qty] => 0
                    [images] => Array
                        (
                            [0] => Array
                                (
                                    [product_id] => 1395
                                    [image] => /images/bulk_product/147/Carolina-Herrera-CH-EDT-W-100-ml.jpg
                                )

                        )

                    [tags] => Array
                        (
                            [0] => Array
                                (
                                    [tag_id] => 4485
                                    [product_id] => 1395
                                    [tag] => perfumes
                                )

                            [1] => Array
                                (
                                    [tag_id] => 6439
                                    [product_id] => 1395
                                    [tag] => Carolina Herrera CH EDT 100 ml
                                )

                        )

                )

        )

    [queryresponse] => select `store_products`.`store_id`, `store_products`.`stock`, `product_varient`.`varient_id`, `product`.`product_id`, `product`.`product_name`, `product`.`product_image`, `product`.`thumbnail`, `product_varient`.`description`, `store_products`.`price`, `store_products`.`mrp`, `product_varient`.`varient_image`, `product_varient`.`unit`, `product_varient`.`quantity`, `product`.`type`, `product`.`delivery`, 100-((store_products.price*100)/store_products.mrp) as discountper, COALESCE(ratings.avgrating,0) as avgrating, COALESCE(ratings.countrating,0) as countrating, `product`.`is_subscription` from `store_products` inner join `product_varient` on `store_products`.`varient_id` = `product_varient`.`varient_id` inner join `product` on `product_varient`.`product_id` = `product`.`product_id` left join (select `varient_id`, AVG(rating) as avgrating, COUNT(rating) as countrating from `product_rating` group by `varient_id`) as `ratings` on `ratings`.`varient_id` = `store_products`.`varient_id` left join `store` on `store_products`.`store_id` = `store`.`id` where `product`.`product_id` in ('444', '1077', '1236', '1287', '1333', '1334', '1336', '1392', '1393', '1394', '1395') and not `product`.`hide` = 1 and `product`.`approved` = 1 and `store`.`store_status` != 0
)