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('2', '3', '4', '5', '6', '8', '9', '10', '11', '12', '13', '15', '16', '21', '22', '25', '26', '27', '31', '33', '34', '35', '36', '37', '40', '41', '42', '43', '44', '45', '46', '47', '48', '50', '51', '52', '53', '54', '55', '57', '58', '59', '60', '63', '64', '67', '70', '71', '73', '74', '75', '76', '77', '78', '79', '80', '81', '82', '83', '85', '87', '88', '89', '90', '93', '94', '95', '96', '97', '98', '99', '100', '101', '102', '103', '104', '105', '106', '107', '108', '109', '110', '113', '116', '118', '120', '122', '125', '127', '132', '133', '134', '135', '136', '138', '139', '140', '142', '143', '149', '160', '162', '163', '164', '165', '166', '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', '221', '222', '225', '229', '231', '234', '239', '241', '242', '244', '259', '260', '267', '271', '282', '290', '291', '292', '293', '297', '298', '300', '301', '302', '303', '304', '305', '306', '307', '308', '309', '310', '311', '312', '313', '315', '317', '318', '319', '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', '402', '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', '506', '507', '509', '510', '511', '512', '513', '514', '515', '526', '528', '529', '531', '532', '533', '534', '535', '536', '537', '538', '539', '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', '608', '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', '638', '639', '640', '641', '642', '643', '644', '645', '646', '647', '648', '649', '658', '659', '660', '661', '663', '664', '665', '666', '667', '668', '669', '670', '671', '672', '674', '677', '678', '682', '686', '687', '688', '689', '690', '696', '700', '701', '705', '706', '707', '708', '709', '710', '711', '712', '713', '714', '715', '716', '717', '718', '719', '720', '721', '722', '726', '727', '728', '729', '730', '731', '732', '733', '734', '735', '736', '737', '738', '753', '758', '759', '763', '764', '768', '769', '771', '772', '773', '774', '775', '776', '778', '779', '780', '781', '782', '783', '785', '787', '788', '789', '790', '791', '792', '793', '794', '795', '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', '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', '860', '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', '919', '920', '921', '922', '923', '924', '925', '926', '927', '928', '929', '930', '931', '932', '933', '934', '936', '937', '938', '939', '940', '941', '942', '943', '944', '946', '947', '948', '949', '950', '951', '952', '953', '954', '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
Öylesine Çiçeklerimiz ile İçinizden Gelen Çiçekleri Gönderin
local_shipping Aynı Gün Teslimatlocal_florist Taze Canlı Çiçekadd_a_photo Medya Mesaj
Öylesine Çiçek Siparişi
Sevdiklerinize içinizden gelip bir çiçek siparişi vermek ister misiniz? Sevdiklerinize hızlı ve güvenli bir şekilde çiçek göndermek için hemen sitemizden çiçek siparişi vermeya başlayın. Sevdiklerinizi mutlu edin. Her zaman kaliteli ve güvenli bir şekilde öylesine çiçek siparişi verebilirsiniz.
|
