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', '2', '3', '4', '5', '6', '7', '8', '9', '10', '12', '15', '16', '18', '19', '20', '21', '22', '24', '25', '26', '27', '28', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '46', '47', '48', '49', '50', '51', '52', '53', '54', '55', '56', '57', '58', '59', '60', '61', '62', '63', '65', '66', '67', '70', '71', '73', '74', '75', '76', '78', '79', '80', '81', '82', '85', '87', '88', '89', '90', '93', '95', '96', '97', '98', '99', '100', '101', '102', '104', '105', '106', '107', '108', '109', '111', '113', '116', '120', '124', '125', '126', '127', '130', '131', '134', '137', '138', '139', '140', '141', '142', '149', '160', '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', '242', '243', '244', '267', '268', '271', '282', '290', '292', '297', '298', '299', '300', '302', '306', '309', '314', '315', '317', '318', '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', '506', '509', '510', '511', '512', '513', '528', '539', '540', '542', '543', '544', '545', '546', '547', '548', '549', '550', '551', '552', '553', '554', '556', '557', '560', '561', '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', '622', '623', '624', '625', '626', '627', '628', '631', '632', '633', '634', '635', '636', '637', '638', '639', '640', '641', '644', '645', '646', '648', '649', '659', '660', '661', '662', '663', '664', '666', '667', '670', '672', '704', '705', '707', '708', '709', '712', '714', '715', '716', '718', '719', '720', '726', '727', '728', '729', '730', '731', '732', '734', '735', '737', '738', '752', '753', '754', '758', '759', '768', '771', '773', '774', '775', '776', '782', '783', '784', '785', '787', '788', '789', '790', '793', '796', '797', '799', '800', '801', '802', '803', '804', '805', '806', '807', '808', '809', '810', '811', '812', '813', '818', '819', '821', '822', '824', '825', '828', '836', '837', '838', '839', '840', '842', '844', '845', '850', '851', '852', '853', '854', '857', '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', '919', '920', '921', '922', '923', '924', '925', '926', '928', '929', '932', '934', '936', '937', '938', '939', '940', '941', '942', '943', '944', '949', '950', '951', '952', '957')
AND `products`.`static` =0
GROUP BY `products`.`id`
ORDER BY `products`.`category_order` DESC, `discounted_price` ASC, `products`.`featured_order` DESC, `discounted_price` ASC
Geçmiş Olsun Çiçekleri %65 İndirimli Bir Şekilde Sipariş Veriniz.
- local_shipping Aynı Gün Teslimat
- local_florist Taze Canlı Çiçek
- 6 Ay Taksit İmkanı
- add_a_photo Medya Mesaj
Geçmiş Olsun demenin en güzel yolu, geçmiş olsun çiçekleri Ciceknet.com ayrıcalığı ile.
|
