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('15', '16', '19', '21', '25', '26', '27', '28', '31', '32', '34', '35', '36', '37', '39', '40', '41', '43', '44', '45', '46', '47', '48', '52', '53', '54', '55', '59', '65', '70', '73', '75', '78', '79', '80', '82', '85', '87', '88', '89', '90', '93', '95', '96', '97', '98', '99', '100', '101', '102', '106', '107', '108', '113', '116', '124', '125', '126', '127', '128', '134', '137', '138', '140', '141', '149', '162', '163', '164', '165', '166', '168', '169', '170', '172', '173', '174', '175', '176', '177', '178', '179', '180', '181', '182', '183', '184', '185', '186', '187', '188', '189', '190', '191', '192', '193', '194', '195', '196', '197', '198', '199', '200', '201', '208', '209', '210', '211', '212', '242', '243', '244', '245', '246', '247', '248', '249', '250', '251', '252', '253', '254', '255', '256', '257', '267', '271', '279', '282', '283', '288', '297', '298', '302', '306', '309', '312', '314', '323', '324', '325', '326', '327', '328', '329', '330', '331', '332', '333', '334', '335', '336', '337', '338', '339', '340', '341', '342', '343', '344', '345', '346', '347', '348', '349', '350', '351', '352', '353', '354', '355', '356', '357', '358', '359', '360', '361', '362', '363', '364', '365', '366', '367', '368', '369', '370', '371', '372', '373', '374', '375', '376', '377', '378', '379', '380', '381', '382', '383', '384', '385', '386', '387', '388', '389', '390', '391', '392', '393', '394', '395', '396', '397', '398', '399', '400', '401', '402', '403', '404', '405', '406', '407', '408', '409', '410', '411', '412', '413', '414', '416', '417', '418', '419', '420', '421', '422', '423', '424', '425', '426', '427', '428', '429', '430', '431', '432', '433', '434', '435', '436', '437', '438', '439', '440', '441', '442', '443', '444', '445', '446', '447', '448', '449', '450', '451', '452', '453', '454', '455', '456', '457', '458', '459', '460', '461', '462', '463', '464', '467', '468', '469', '470', '471', '472', '473', '474', '475', '476', '477', '478', '484', '485', '486', '487', '488', '489', '490', '491', '492', '493', '494', '503', '504', '505', '510', '511', '514', '540', '541', '542', '543', '544', '545', '546', '547', '548', '549', '550', '551', '552', '553', '554', '555', '556', '557', '560', '561', '562', '563', '564', '565', '566', '567', '568', '569', '570', '571', '572', '573', '574', '575', '576', '577', '578', '579', '580', '581', '582', '583', '584', '585', '586', '587', '588', '589', '590', '591', '592', '593', '594', '595', '596', '597', '598', '599', '600', '601', '602', '603', '604', '605', '606', '607', '609', '610', '611', '612', '613', '614', '615', '616', '617', '618', '620', '621', '622', '623', '624', '625', '626', '627', '628', '629', '630', '631', '632', '633', '634', '635', '636', '637', '639', '640', '641', '642', '644', '645', '646', '647', '648', '649', '670', '704', '705', '706', '707', '708', '709', '714', '715', '716', '718', '719', '721', '722', '723', '724', '726', '727', '728', '729', '730', '731', '732', '734', '735', '736', '737', '738', '752', '753', '754', '758', '759', '768', '771', '773', '774', '775', '776', '783', '785', '787', '788', '789', '790', '796', '797', '799', '800', '801', '802', '803', '804', '805', '806', '807', '808', '809', '810', '811', '812', '813', '817', '819', '824', '836', '838', '839', '840', '842', '844', '850', '851', '852', '853', '854', '856', '857', '859', '861', '862', '863', '864', '865', '866', '867', '868', '869', '870', '871', '872', '873', '874', '875', '876', '877', '878', '879', '880', '881', '882', '883', '884', '885', '886', '887', '888', '889', '890', '891', '892', '893', '894', '895', '896', '897', '898', '899', '900', '901', '902', '903', '904', '905', '906', '907', '908', '909', '910', '911', '912', '913', '914', '916', '920', '921', '922', '924', '925', '926', '927', '928', '929', '930', '931', '932', '933', '934', '935', '936', '937', '938', '939', '940', '941', '942', '943', '944', '950', '951', '956', '957', '958', '959') AND `products`.`static` =0 GROUP BY `products`.`id` ORDER BY `products`.`category_order` DESC, `discounted_price` ASC, `products`.`featured_order` DESC, `discounted_price` ASC
Yenidoğan için Çiçek Siparişi Verin. %50 İndirim
  • local_shipping Aynı Gün Teslimat
  • local_florist Taze Canlı Çiçek
  • 6 Ay Taksit İmkanı
  • add_a_photo Medya Mesaj

Ana Sayfa > Yenidoğan Çiçekleri

Yenidoğan çiçekleri

|