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('1', '10', '13', '14', '16', '17', '19', '20', '23', '30', '32', '33', '58', '60', '61', '63', '64', '67', '68', '69', '72', '83', '84', '86', '90', '91', '92', '93', '98', '111', '114', '117', '119', '120', '121', '122', '123', '124', '127', '129', '131', '132', '133', '134', '135', '136', '137', '138', '160', '161', '167', '171', '292', '293', '297', '301', '302', '305', '306', '308', '309', '310', '311', '312', '313', '314', '315', '317', '318', '319', '320', '321', '322', '323', '324', '325', '326', '327', '328', '329', '330', '331', '332', '333', '334', '335', '336', '337', '338', '339', '340', '350', '351', '359', '364', '365', '366', '378', '381', '396', '403', '404', '405', '406', '407', '408', '409', '410', '411', '412', '413', '414', '415', '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', '501', '502', '507', '510', '512', '514', '515', '516', '517', '518', '519', '520', '521', '522', '523', '524', '525', '526', '527', '528', '529', '530', '531', '532', '533', '534', '535', '536', '537', '538', '548', '558', '559', '583', '584', '595', '600', '601', '603', '604', '608', '613', '615', '627', '628', '665', '670', '699', '704', '707', '708', '710', '711', '714', '716', '717', '719', '726', '768', '783', '791', '793', '794', '795', '796', '814', '815', '816', '817', '818', '819', '820', '821', '822', '823', '824', '825', '826', '827', '828', '829', '830', '831', '832', '833', '834', '835', '839', '840', '841', '843', '850', '854', '928', '932', '946', '947', '948', '949', '952', '953', '954', '955') AND `products`.`static` =0 GROUP BY `products`.`id` ORDER BY `products`.`category_order` DESC, `discounted_price` ASC, `products`.`featured_order` DESC, `discounted_price` ASC
Güller - Sevdikleriniz için Özenle Hazırlanmış Gül Arajmanları
  • local_shipping Aynı Gün Teslimat
  • local_florist Taze Canlı Çiçek
  • 6 Ay Taksit İmkanı
  • add_a_photo Medya Mesaj

Ana Sayfa > Güller

Sevdikleriniz için güller

|