Query: SELECT `Product`.`id`, `Product`.`kategori_id`, `Product`.`grup_id`, `Product`.`mark_id`, `Product`.`urun_kodu`, `Product`.`urun_baslik`, `Product`.`kdv_oran`, `Product`.`fiyat`, `Product`.`fiyat_kdv_dahil`, `Product`.`ozel_kargo_fiyat`, `Product`.`doviz_id`, `Product`.`desi`, `Product`.`desi_grup`, `Product`.`agirlik`, `Product`.`indirim_oran`, `Product`.`indirimli_fiyat`, `Product`.`anahtar_kelime`, `Product`.`aciklama`, `Product`.`detay`, `Product`.`added_date`, `Product`.`yayinda`, `Product`.`vitrinde`, `Product`.`indirimli`, `Product`.`hizlikargo`, `Product`.`encoksatan`, `Product`.`yeniurun`, `Product`.`seo_link`, `Product`.`marka_id`, `Product`.`sira_no`, `Product`.`stok_durum`, `Product`.`stok_olmadan_satis`, `Product`.`stok_miktari`, `Product`.`gosterim_tutar`, `Product`.`ayni_gun_kargo`, `Product`.`kargo_hazirlik_suresi`, `Product`.`add_shopping_flag`, `Product`.`n11_integration`, `Product`.`n11_shipment_template`, `Product`.`n11_title`, `Product`.`n11_subtitle`, `Product`.`n11_detay`, `Product`.`n11_fiyat`, `Product`.`wholesaler_vendor_id`, `Product`.`wholesaler_vendor_code`, `Product`.`wholesaler_stok_senkronize`, `Product`.`wholesaler_fiyat_senkronize`, `Product`.`wholesaler_ayni_gun_senkronize`, `Product`.`wholesaler_desi_senkronize`, `Mark`.`id`, `Mark`.`name`, `Mark`.`sira_no`, `Marka`.`id`, `Marka`.`name`, `Marka`.`sira_no`, `Grup`.`id`, `Grup`.`parent_id`, `Grup`.`grup_name`, `Grup`.`grup_menu_name`, `Grup`.`seo_link`, `Grup`.`grup_desi`, `Grup`.`kargo_hazirlik_suresi`, `Grup`.`lft`, `Grup`.`rght`, `Doviz`.`id`, `Doviz`.`name`, `Doviz`.`icon`, `Kategori`.`id`, `Kategori`.`parent_id`, `Kategori`.`name`, `Kategori`.`menu_name`, `Kategori`.`title`, `Kategori`.`seo_link`, `Kategori`.`aciklama`, `Kategori`.`detay`, `Kategori`.`anahtar_kelime`, `Kategori`.`lft`, `Kategori`.`rght`, `Kategori`.`one_cikan`, `Kategori`.`one_cikan_sira_no` FROM `products` AS `Product` INNER JOIN `marks` AS `Mark` ON (`Product`.`mark_id` = `Mark`.`id`) LEFT JOIN `markas` AS `Marka` ON (`Product`.`marka_id` = `Marka`.`id`) LEFT JOIN `grups` AS `Grup` ON (`Product`.`grup_id` = `Grup`.`id`) INNER JOIN `dovizs` AS `Doviz` ON (`Product`.`doviz_id` = `Doviz`.`id`) INNER JOIN `kategoris` AS `Kategori` ON (`Product`.`kategori_id` = `Kategori`.`id`) WHERE `Product`.`yayinda`= 1 AND (`Kategori`.`id` = 244 OR exists(select 1 from kategoris k where `k`.`id` = `Kategori`.`id` and exists(select 1 from kategoris kk where `kk`.`id` = 244 and `k`.`lft` between `kk`.`lft` and `kk`.`rght`))) ORDER BY `stok_durum` DESC, (case when `Product`.`sira_no` is null then 999999 else `Product`.`sira_no` end) ASC, `added_date` DESC LIMIT 240, 15
