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', '3', '4', '5', '6', '7', '8', '9', '10', '12', '15', '16', '17', '18', '19', '21', '24', '25', '26', '27', '29', '30', '31', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '46', '47', '48', '50', '51', '52', '53', '54', '55', '56', '57', '59', '61', '63', '64', '65', '67', '68', '70', '71', '72', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '99', '100', '101', '102', '103', '104', '105', '106', '107', '108', '110', '111', '112', '113', '114', '116', '118', '120', '121', '122', '124', '125', '126', '127', '128', '129', '130', '132', '134', '135', '136', '137', '138', '140', '141', '142', '143', '149', '161', '162', '163', '164', '165', '166', '167', '168', '169', '170', '171', '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', '203', '204', '205', '206', '214', '215', '216', '219', '221', '222', '225', '237', '239', '259', '267', '271', '282', '291', '293', '299', '300', '301', '305', '307', '308', '309', '310', '311', '312', '313', '318', '319', '320', '321', '322', '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', '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', '503', '504', '505', '507', '508', '510', '511', '512', '514', '515', '516', '523', '524', '528', '529', '531', '532', '533', '534', '535', '537', '538', '539', '542', '543', '544', '545', '546', '547', '548', '549', '550', '551', '552', '553', '554', '555', '556', '557', '558', '560', '566', '567', '568', '569', '571', '572', '573', '574', '575', '576', '577', '579', '580', '581', '582', '583', '584', '587', '588', '590', '591', '592', '593', '594', '595', '596', '598', '600', '601', '602', '603', '604', '605', '607', '608', '609', '610', '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', '638', '639', '640', '641', '642', '644', '645', '646', '648', '649', '658', '660', '661', '663', '670', '672', '674', '677', '678', '686', '687', '688', '689', '690', '704', '705', '706', '708', '710', '711', '712', '713', '716', '717', '718', '719', '720', '721', '727', '728', '729', '731', '733', '736', '737', '753', '754', '758', '759', '768', '771', '773', '774', '775', '776', '782', '783', '784', '785', '787', '788', '789', '790', '791', '794', '796', '797', '798', '799', '800', '801', '802', '803', '804', '805', '806', '807', '808', '809', '810', '811', '812', '813', '814', '815', '816', '817', '818', '819', '820', '821', '822', '823', '824', '825', '828', '829', '830', '831', '832', '833', '835', '836', '837', '838', '839', '840', '841', '842', '843', '844', '845', '850', '851', '852', '853', '854', '855', '856', '857', '858', '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', '915', '916', '917', '918', '920', '921', '923', '924', '925', '926', '927', '928', '929', '930', '931', '932', '933', '934', '936', '937', '938', '939', '940', '941', '942', '943', '944', '949', '950', '951', '952', '953', '954', '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
Özür Dilerim Çiçekleri %70 İndirimli Siparişi Verin
local_shipping Aynı Gün Teslimat
local_florist Taze Canlı Çiçek
6 Ay Taksit İmkanı
add_a_photo Medya Mesaj
Özür Dileme Çiçekleri
Özür dileme çiçekleri ile sevdiklerinizden özür dileme yaparak onların kalplerini kazanmaya çalışın, Özür dileme çiçekleri birbirinden güzel şekilde hazırlanmış bir sevdiklerinize aynı gün teslimat edilmektedir. Sizlerde sevdiklerinize hızlı ve güvenli bir şekilde çiçek siparşi vermek için hemen sipariş oluşturma yapabilirsiniz.
Beni Affet Çiçekleri
Hiç kimse sevdiklerin kalplerini kırmak istemez, elimizde olmayan nedenlerden dolayı sevdiklerimizi kırdık ise o zaman onlara en güzel şekilde hazırlanmış çiçekleri sipariş veriniz.
|