SELECT `products`.*, `pt`.`name` as `prodName`, `pi`.`image`, `pp`.`price`, `pp`.`discount`, `pp`.`discount_type`, `pp`.`vat`, `country`.`currency`, `pi`.`comments` as `comments`, `pi`.`description` as `description`, `pi`.`tags` as `tags`, `ptt`.`name` as `product_type`, CASE WHEN discount_type = 0 THEN price - discount ELSE (price -(discount * price)/100) END as `discounted_price` FROM `products` LEFT JOIN `product_types_translation` as `ptt` ON `products`.`product_type`=`ptt`.`row_id` and `ptt`.`lang_id` =1 JOIN `products_translation` as `pt` ON `pt`.`row_id`=`products`.`id` AND `pt`.`lang_id`=1 LEFT JOIN `product_images` as `pi` ON `pi`.`product_id`=`products`.`id` AND `pi`.`deleted`=0 JOIN `product_prices` as `pp` ON `pp`.`product_id`=`products`.`id` and `pp`.`deleted` = 0 JOIN `country` ON `country`.`id`=`pp`.`country_id` JOIN `product_cities` as `pc` ON `pc`.`city_id`=1 and `pc`.`deleted`=0 and `pc`.`product_id`=`products`.`id` JOIN `florist_products` as `fp` ON `fp`.`status`=1 and `fp`.`product_id`=`products`.`id` JOIN `florist_areas_charges` as `fac` ON `fac`.`district`=1 and `fac`.`deleted`=0 and `fac`.`can_deliver`=1 and `fp`.`user_id`=`fac`.`florist_id` WHERE `pi`.`primary_image` = 1 AND `products`.`deleted` =0 AND `products`.`status` = 1 AND `products`.`id` IN('14', '15', '23', '32', '33', '62', '63', '64', '114', '117', '118', '119', '120', '121', '123', '124', '131', '135', '136', '141', '143', '181', '182', '188', '191', '213', '214', '215', '217', '220', '225', '226', '239', '292', '293', '297', '301', '302', '305', '306', '308', '309', '311', '313', '314', '315', '317', '318', '319', '320', '323', '325', '327', '329', '330', '332', '336', '337', '338', '339', '340', '350', '352', '358', '359', '364', '384', '385', '396', '400', '401', '403', '405', '407', '409', '410', '412', '417', '418', '419', '420', '421', '422', '424', '427', '430', '431', '435', '440', '450', '451', '460', '463', '464', '501', '502', '507', '510', '512', '514', '521', '522', '523', '524', '525', '526', '527', '528', '529', '530', '531', '534', '536', '537', '538', '542', '545', '549', '550', '551', '558', '559', '583', '584', '592', '593', '608', '615', '704', '706', '708', '710', '711', '713', '717', '718', '719', '720', '721', '752', '753', '758', '768', '795', '798', '799', '800', '801', '802', '806', '807', '814', '815', '816', '817', '818', '820', '821', '823', '826', '827', '834', '835', '837', '841', '843', '854', '917', '918', '919', '920', '921', '922', '923', '942', '943', '944', '946', '947', '948', '949', '950', '951', '952', '953') AND `products`.`static` =0 GROUP BY `products`.`id` ORDER BY `products`.`category_order` DESC, `discounted_price` ASC, `products`.`featured_order` DESC, `discounted_price` ASC
Sevgililer Günü Çiçekleri - %70 İndirimli Çiçekleri Gönderin
  • local_shipping Aynı Gün Teslimat
  • local_florist Taze Canlı Çiçek
  • 6 Ay Taksit İmkanı
  • add_a_photo Medya Mesaj

Ana Sayfa > Sevgililer Günü

Sevgililer Günü çiçekleri

|