Travel Notes Romania

  • Vremea – Starea vremii in Sharm El-Sheikh » Egipt – Prognoza Meteo pe 3 zile


    Table './travel_rute/vremea' is marked as crashed and last (automatic?) repair failed
    SELECT *, DATE_FORMAT(CONCAT_WS('-',SUBSTRING_INDEX(v.obsdate,'/',-1),SUBSTRING_INDEX(v.obsdate,'/',1),SUBSTRING_INDEX(SUBSTRING_INDEX(v.obsdate,'/',2),'/',-1)), '%m-%d-%Y') AS zdate FROM tari t, vremea v, vremealoc vl, vremeareg vr WHERE t.id_tara=vr.id_tara AND vr.id_reg=vl.id_reg AND vl.id_loc=v.id_loc AND DATEDIFF(CONCAT_WS('-',SUBSTRING_INDEX(v.obsdate,'/',-1),SUBSTRING_INDEX(v.obsdate,'/',1),SUBSTRING_INDEX(SUBSTRING_INDEX(v.obsdate,'/',2),'/',-1)),'2023-6-1')>=0 AND REPLACE(REPLACE(vl.localitate, ' ', ''),'-','')='SharmElSheikh' AND REPLACE(REPLACE(vr.regiune, ' ', ''),'-','')='PeninsulaSinai' AND REPLACE(REPLACE(t.tara, ' ', ''),'-','')='Egipt' ORDER BY zdate ASC