Düğün Çiçekleri - Tören Çiçekleri

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('59', '144', '145', '147', '149', '150', '151', '152', '153', '154', '155', '157', '158', '173', '242', '244', '261', '262', '263', '264', '265', '266', '272', '273', '274', '278', '279', '281', '341', '344', '348', '349', '465', '466', '467', '468', '469', '470', '471', '472', '473', '474', '475', '476', '477', '478', '484', '485', '486', '487', '488', '489', '490', '491', '492', '493', '494', '495', '739', '740', '741', '742', '743', '744', '745', '746', '747', '755', '756', '757', '846', '847', '848', '849', '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', '920', '934', '936', '937', '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