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', '7', '10', '13', '14', '16', '17', '18', '20', '21', '23', '25', '26', '27', '28', '29', '31', '32', '33', '34', '35', '36', '37', '40', '41', '43', '44', '47', '48', '50', '52', '53', '55', '56', '57', '58', '59', '60', '64', '67', '68', '69', '70', '72', '73', '74', '75', '76', '78', '79', '80', '81', '82', '83', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '99', '100', '101', '102', '105', '106', '107', '108', '109', '111', '112', '113', '114', '116', '117', '118', '121', '122', '123', '127', '128', '129', '131', '132', '133', '135', '136', '137', '140', '142', '143', '149', '160', '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', '200', '201', '202', '203', '204', '205', '206', '207', '214', '215', '216', '219', '221', '222', '225', '229', '232', '233', '236', '239', '241', '242', '244', '260', '267', '271', '282', '283', '288', '291', '293', '297', '299', '300', '301', '305', '306', '308', '310', '311', '312', '313', '314', '317', '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', '506', '507', '508', '510', '512', '514', '515', '516', '517', '518', '519', '520', '525', '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', '558', '571', '583', '584', '591', '592', '593', '594', '595', '598', '600', '601', '602', '603', '604', '605', '607', '608', '609', '613', '615', '628', '629', '635', '640', '645', '648', '649', '659', '661', '664', '665', '671', '677', '678', '686', '687', '688', '689', '690', '704', '706', '708', '710', '713', '717', '718', '720', '721', '733', '736', '737', '739', '740', '741', '742', '743', '744', '745', '746', '747', '755', '756', '757', '758', '759', '768', '769', '771', '773', '774', '775', '776', '785', '791', '792', '804', '808', '809', '810', '811', '812', '813', '814', '815', '816', '817', '818', '819', '820', '821', '822', '823', '824', '826', '827', '828', '829', '830', '831', '832', '833', '835', '837', '838', '839', '840', '841', '842', '843', '844', '845', '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', '923', '928', '934', '937', '938', '943', '949', '950', '951', '952', '953', '954', '955', '956')
AND `products`.`static` =0
GROUP BY `products`.`id`
ORDER BY `products`.`category_order` DESC, `discounted_price` ASC, `products`.`featured_order` DESC, `discounted_price` ASC
Evlilik Yıl Dönümü için Etkileyici Çiçek Siparişi Veriniz. Evlilik Yıl Dönümü Çiçekleri
- local_shipping Aynı Gün Teslimat
- local_florist Taze Canlı Çiçek
- 6 Ay Taksit İmkanı
- add_a_photo Medya Mesaj
Evlilik, nişan, düğün ve tüm yıl dönümü kutlamaları için sevdiklerinizi mutlu etmenin adresi Ciceknet.com.
|
