Array ( [status] => 1 [message] => Event Product List [event_details] => Array ( [id] => 73 [event_name] => National Day [event_description] => [event_banner_img] => [colorcode] => [events_message] => Array ( [0] => Array ( [id] => 1599 [event_id] => 73 [message] => Happy UAE National Day [status] => 1 [added_by] => 1 [added_on] => 2025-11-17 17:00:47 ) ) ) [productlist] => Array ( [0] => Array ( [store_id] => 1 [stock] => 1000 [varient_id] => 2526 [product_id] => 2393 [product_name] => Unity Colors Balloon Bundle [product_image] => /images/bulk_product/261/4.jpg [thumbnail] => [description] => Des - Sweet of 40 Helium filled Balloons in Red White Green & Black [price] => 419 [mrp] => 419 [varient_image] => N/A [unit] => Pc [quantity] => 1 [type] => Regular [delivery] => 1 [discountper] => 0 [avgrating] => 0 [countrating] => 0 [is_subscription] => 1 [isFavourite] => false [cart_qty] => 0 [images] => Array ( [0] => Array ( [product_id] => 2393 [image] => /images/bulk_product/261/4.jpg ) ) [tags] => Array ( [0] => Array ( [tag_id] => 7364 [product_id] => 2393 [tag] => National day ) ) ) [1] => Array ( [store_id] => 1 [stock] => 1000 [varient_id] => 2527 [product_id] => 2394 [product_name] => Unity Colors Layer Cake [product_image] => /images/bulk_product/261/5.jpg [thumbnail] => [description] => Des - National Day cake 1 Kg in Vanilla Flavor. [price] => 209 [mrp] => 209 [varient_image] => N/A [unit] => kg [quantity] => 1 [type] => Regular [delivery] => 1 [discountper] => 0 [avgrating] => 0 [countrating] => 0 [is_subscription] => 1 [isFavourite] => false [cart_qty] => 0 [images] => Array ( [0] => Array ( [product_id] => 2394 [image] => /images/bulk_product/261/5.jpg ) ) [tags] => Array ( [0] => Array ( [tag_id] => 7365 [product_id] => 2394 [tag] => National day ) ) ) [2] => Array ( [store_id] => 1 [stock] => 1000 [varient_id] => 2528 [product_id] => 2395 [product_name] => National Day Celebration Cake [product_image] => /images/bulk_product/261/6.jpg [thumbnail] => [description] => Des - I Love UAE Cake 1 KG. [price] => 199 [mrp] => 199 [varient_image] => N/A [unit] => Pc [quantity] => 1 [type] => Regular [delivery] => 1 [discountper] => 0 [avgrating] => 0 [countrating] => 0 [is_subscription] => 1 [isFavourite] => false [cart_qty] => 0 [images] => Array ( [0] => Array ( [product_id] => 2395 [image] => /images/bulk_product/261/6.jpg ) ) [tags] => Array ( [0] => Array ( [tag_id] => 7366 [product_id] => 2395 [tag] => National day ) ) ) [3] => Array ( [store_id] => 1 [stock] => 1000 [varient_id] => 2529 [product_id] => 2396 [product_name] => Spirit of the Union Cake [product_image] => /images/bulk_product/261/7.jpg [thumbnail] => [description] => Des - Spirirt symbol cake 1 Kg ( Vanilla Flavor ) [price] => 209 [mrp] => 209 [varient_image] => N/A [unit] => Pc [quantity] => 1 [type] => Regular [delivery] => 1 [discountper] => 0 [avgrating] => 0 [countrating] => 0 [is_subscription] => 1 [isFavourite] => false [cart_qty] => 0 [images] => Array ( [0] => Array ( [product_id] => 2396 [image] => /images/bulk_product/261/7.jpg ) ) [tags] => Array ( [0] => Array ( [tag_id] => 7367 [product_id] => 2396 [tag] => National day ) ) ) [4] => Array ( [store_id] => 1 [stock] => 1000 [varient_id] => 2530 [product_id] => 2397 [product_name] => National Harmony Vase [product_image] => /images/bulk_product/261/8.jpg [thumbnail] => [description] => Des - Glass Vase arrangement of 1 Green Hydrangea 5 Red Carnations 5 White Carnations 1 Black Sprayed chrysanthemum 3 stems eucalyptus 5 Stems Green ruscase in Square glass vase 12x12cm [price] => 149 [mrp] => 149 [varient_image] => N/A [unit] => Pc [quantity] => 1 [type] => Regular [delivery] => 1 [discountper] => 0 [avgrating] => 0 [countrating] => 0 [is_subscription] => 1 [isFavourite] => false [cart_qty] => 0 [images] => Array ( [0] => Array ( [product_id] => 2397 [image] => /images/bulk_product/261/8.jpg ) ) [tags] => Array ( [0] => Array ( [tag_id] => 7368 [product_id] => 2397 [tag] => National day ) ) ) [5] => Array ( [store_id] => 1 [stock] => 1000 [varient_id] => 2531 [product_id] => 2398 [product_name] => Union Day Vase Arrangement [product_image] => /images/bulk_product/261/9.jpg [thumbnail] => [description] => Des - Round Glass Vase arrangement of 6 Red Carnations 2 White Chrysanthemum 3 Green Button Chrysanthemum 4 Stems Eucalyptus Black sprayed & 3 Stem Green Ruscas. [price] => 129 [mrp] => 129 [varient_image] => N/A [unit] => Pc [quantity] => 1 [type] => Regular [delivery] => 1 [discountper] => 0 [avgrating] => 0 [countrating] => 0 [is_subscription] => 1 [isFavourite] => false [cart_qty] => 0 [images] => Array ( [0] => Array ( [product_id] => 2398 [image] => /images/bulk_product/261/9.jpg ) ) [tags] => Array ( [0] => Array ( [tag_id] => 7369 [product_id] => 2398 [tag] => National day ) ) ) [6] => Array ( [store_id] => 1 [stock] => 1000 [varient_id] => 2532 [product_id] => 2399 [product_name] => Legacy of Zayed Arrangement [product_image] => /images/bulk_product/261/10.jpg [thumbnail] => [description] => Des - Black Round Box arrangement of 1 Black sprayed Hydrangea 9 Red Rose 7 White Rose 5 Green Button Chrysanthemum & 4 Stems Green Ruscas. [price] => 209 [mrp] => 209 [varient_image] => N/A [unit] => Pc [quantity] => 1 [type] => Regular [delivery] => 1 [discountper] => 0 [avgrating] => 0 [countrating] => 0 [is_subscription] => 1 [isFavourite] => false [cart_qty] => 0 [images] => Array ( [0] => Array ( [product_id] => 2399 [image] => /images/bulk_product/261/10.jpg ) ) [tags] => Array ( [0] => Array ( [tag_id] => 7370 [product_id] => 2399 [tag] => National day ) ) ) [7] => Array ( [store_id] => 1 [stock] => 1000 [varient_id] => 2533 [product_id] => 2400 [product_name] => Pearl of the Emirates Arrangement [product_image] => /images/bulk_product/261/11.jpg [thumbnail] => [description] => Des - Black Round Box of 10 White Roses 10 Red Roses 5 Stems Green Button Chrysanthemums. [price] => 199 [mrp] => 199 [varient_image] => N/A [unit] => Pc [quantity] => 1 [type] => Regular [delivery] => 1 [discountper] => 0 [avgrating] => 0 [countrating] => 0 [is_subscription] => 1 [isFavourite] => false [cart_qty] => 0 [images] => Array ( [0] => Array ( [product_id] => 2400 [image] => /images/bulk_product/261/11.jpg ) ) [tags] => Array ( [0] => Array ( [tag_id] => 7371 [product_id] => 2400 [tag] => National day ) ) ) [8] => Array ( [store_id] => 1 [stock] => 1000 [varient_id] => 2534 [product_id] => 2401 [product_name] => UAE Prestige Box [product_image] => /images/bulk_product/261/12.jpg [thumbnail] => [description] => Des - White Square box arrangement of 10 Red Roses 4 White Carnation 2 Black Sprayed chrysanthemums 6 Stems Green Ruscas * 8 Pcs Ferrerorocher. [price] => 229 [mrp] => 229 [varient_image] => N/A [unit] => Pc [quantity] => 1 [type] => Regular [delivery] => 1 [discountper] => 0 [avgrating] => 0 [countrating] => 0 [is_subscription] => 1 [isFavourite] => false [cart_qty] => 0 [images] => Array ( [0] => Array ( [product_id] => 2401 [image] => /images/bulk_product/261/12.jpg ) ) [tags] => Array ( [0] => Array ( [tag_id] => 7372 [product_id] => 2401 [tag] => National day ) ) ) [9] => Array ( [store_id] => 1 [stock] => 1000 [varient_id] => 2535 [product_id] => 2402 [product_name] => Freedom Petals Bouquet [product_image] => /images/bulk_product/261/13.jpg [thumbnail] => [description] => Des - Bouquet of 4 Red Roses 3 White Rose 2 Green Button Chrysanthemum 2 Stems Black Sprayed chrysanthemum 5 Stems Green Ruscas 2 Stems Baby Breath wrapped in White Black and Red Wrapping. [price] => 99 [mrp] => 99 [varient_image] => N/A [unit] => Pc [quantity] => 1 [type] => Regular [delivery] => 1 [discountper] => 0 [avgrating] => 0 [countrating] => 0 [is_subscription] => 1 [isFavourite] => false [cart_qty] => 0 [images] => Array ( [0] => Array ( [product_id] => 2402 [image] => /images/bulk_product/261/13.jpg ) ) [tags] => Array ( [0] => Array ( [tag_id] => 7373 [product_id] => 2402 [tag] => National day ) ) ) [10] => Array ( [store_id] => 1 [stock] => 1000 [varient_id] => 2536 [product_id] => 2403 [product_name] => Emirati Pride Balloon Set [product_image] => /images/bulk_product/264/4.jpg [thumbnail] => [description] => Des - Stand Arrangement of 99 Balloons ( Set of 2 ) [price] => 1099 [mrp] => 1099 [varient_image] => N/A [unit] => Pc [quantity] => 1 [type] => Regular [delivery] => 1 [discountper] => 0 [avgrating] => 0 [countrating] => 0 [is_subscription] => 1 [isFavourite] => false [cart_qty] => 0 [images] => Array ( [0] => Array ( [product_id] => 2403 [image] => /images/bulk_product/264/4.jpg ) ) [tags] => Array ( [0] => Array ( [tag_id] => 7374 [product_id] => 2403 [tag] => National day ) ) ) [11] => Array ( [store_id] => 1 [stock] => 1000 [varient_id] => 2554 [product_id] => 2421 [product_name] => test [product_image] => /images/product/03-12-2025/Untitled.png [thumbnail] => N/A [description] =>

test test

[price] => 100 [mrp] => 100 [varient_image] => N/A [unit] => 1 KG [quantity] => 4 [type] => Regular [delivery] => 3 [discountper] => 0 [avgrating] => 0 [countrating] => 0 [is_subscription] => 1 [isFavourite] => false [cart_qty] => 0 [images] => Array ( [0] => Array ( [product_id] => 2421 [image] => /images/product/03-12-2025/Untitled.png ) ) [tags] => Array ( [0] => Array ( [tag_id] => 7392 [product_id] => 2421 [tag] => Test ) ) ) ) [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 ('2393', '2394', '2395', '2396', '2397', '2398', '2399', '2400', '2401', '2402', '2403', '2421') and not `product`.`hide` = 1 and `product`.`approved` = 1 and `store`.`store_status` != 0 )