Message: | MySQL Query fail: SELECT DISTINCT p.product_id,p.sku_code,p.barcode,bp1.category_id, bp1.sub_category_id, p.product_name, p.product_short_name, p.product_brand,p.brand_id, p.product, p.product_with,p.product_mrp, p.product_color, p.product_flavour, p.packaging, p.product_size, p.quantity, p.unit, p.product_size_2, p.quantity_2, p.unit_2, p.product_size_3, p.quantity_3, p.unit_3, p.is_organic, p.is_recyclable, p.non_veg, p.is_frozen, p.ready_to_eat, p.ready_to_cook, p.veg,p.egg, p.ready_to_use, p.ayurvedic, p.sugar_free, p.skin_type, p.hair_type, p.spice_level, p.product_description, p.product_directions, p.ingredients, p.main_ingredients, p.product_content, p.manufactured_by, p.manufactured_by_logo, p.manufactured_email, p.manufactured_phone, p.manufactured_website,p.made_in, p.marketed_by,p.marketed_by_logo, p.marketed_email, p.marketed_website, p.customer_service_phone, p.customer_service_email, p.serving_size, p.serving_unit, p.no_of_serving_per_container, p.added_date, p.added_by, p.last_updated_date, p.last_updated_by, p.status, p.is_offer, p.offer_type, p.product_ratings, pi.product_image_url, pi.is_default, p.is_offer,p.no_mrp,p.offer_type , p.nutrition_facts_updated,p.product_allergies, p.nutrition_facts_image,p.seourls ,(SELECT category_name FROM bb_product_categories WHERE product_category_id = bp1.category_id AND parent_product_category_id = 0 AND status = '1' ) as mainCateName ,(SELECT seourl FROM bb_product_categories WHERE product_category_id = bp1.category_id AND parent_product_category_id = 0 AND status = '1' ) as catseourl ,(SELECT category_name FROM bb_product_categories WHERE product_category_id = bp1.sub_category_id AND parent_product_category_id = bp1.category_id AND status = '1' ) as subCateName ,(SELECT seourl FROM bb_product_categories WHERE product_category_id = bp1.sub_category_id AND parent_product_category_id = bp1.category_id AND status = '1' ) as subcatseourl ,(SELECT name FROM bb_store WHERE store_id = sp.store_id AND status = '1' ) as store_name ,(SELECT pickup_delay_time FROM bb_store WHERE store_id = sp.store_id AND status = '1' ) ,(SELECT seourl FROM bb_store WHERE store_id = sp.store_id AND status = '1' ) as seourl ,(SELECT speciality_store FROM bb_store WHERE store_id = sp.store_id AND status = '1' ) as speciality_store ,(SELECT speciality_store_delivery_time FROM bb_store WHERE store_id = sp.store_id AND status = '1' ) as speciality_store_delivery_time ,(SELECT local_speciality_store FROM bb_store WHERE store_id = sp.store_id AND status = '1' ) as local_speciality_store ,(SELECT pickup_delay_time FROM bb_store WHERE store_id = sp.store_id AND status = '1' ) as pickup_delay_time ,sp.store_id, sp.store_product_id, sp.product_price, sp.inventory as storeproduct_qty, sp.ranking,p.product_ratings, sp.store_product_likes, sp.store_product_unlikes ,sp.store_product_status, sp.purchase_limit, sp.listing_expiring_date, sp.feature_offer_expiry_date FROM bb_products p LEFT JOIN bb_prod_category_list bp1 ON bp1.prod_id = p.product_id LEFT JOIN bb_product_images pi ON p.product_id = pi.product_id AND pi.is_default = '1' LEFT JOIN bb_store_products sp ON p.product_id = sp.product_id WHERE sp.store_product_id = '' |