SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
SELECT DISTINCT aa_bursiyer_detay1.bursiyer_id, ap_users.user_fullname AS ogrenci_ad_soyad, aa_bursiyer_detay1.tc_kimlik, aa_bursiyer_detay1.iban_no, aa_bursiyer_detay1.banka_ad_sube, aa_bursiyer_detay1.alan_ad, ap_users.user_email, aa_bursiyer_detay1.telefon, aa_bursiyer_detay1.cinsiyet, DATE_FORMAT( case WHEN aa_bursiyer_detay2.burs_tarihi is null THEN '' ELSE MAX(aa_bursiyer_detay2.burs_tarihi) END , "%Y - %m") donem, aa_bursiyer_detay2.burs_miktari, DATE_FORMAT( case WHEN aa_bursiyer_detay2.burs_tarihi is null THEN '' ELSE MAX(aa_bursiyer_detay2.burs_tarihi) END , "%d.%m.%Y") max_burs_tarihi FROM bursofisi.ap_users ap_users LEFT OUTER JOIN bursofisi.ap_form_10451 ap_form_10451 ON (ap_users.user_email = ap_form_10451.element_16) INNER JOIN bursofisi.aa_bursiyer_detay1 aa_bursiyer_detay1 ON (aa_bursiyer_detay1.bursiyer_id = ap_users.user_id) LEFT OUTER JOIN bursofisi.aa_bursiyer_detay2 aa_bursiyer_detay2 ON (aa_bursiyer_detay2.bursiyer_id = aa_bursiyer_detay1.id) WHERE (ap_users.status = 1) AND ap_users.user_id not in (1,2) AND priv_new_themes<>1 AND aa_bursiyer_detay1.status=1 AND aa_bursiyer_detay2.status=1 GROUP BY ap_users.user_id, aa_bursiyer_detay2.burs_miktari ORDER BY ap_users.last_login_date DESC
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear