Cartea Munților

Trasee montane în România

User Tools

Site Tools


munti_romania:orientali:carpatii_de_curbura:piatra_mare:start

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
munti_romania:orientali:carpatii_de_curbura:piatra_mare:start [2020/07/13 22:29]
Sorin Sfirlogea
munti_romania:orientali:carpatii_de_curbura:piatra_mare:start [2020/07/13 22:30] (current)
Sorin Sfirlogea
Line 248: Line 248:
  
  
- +~~NOCACHE~~
-<​sql>​ +
-SELECT concat(latitudine,​ ', ', longitudine,​ ', 0, .7, ', LOWER(operator),​ '.png, Antenă ', operator) AS GSMpoint,  +
-ST_Distance_Sphere(ST_GeomFromText(CONCAT('​POINT(',​ CONVERT(longitudine,​ CHAR), ' ', CONVERT(latitudine,​CHAR),​ '​)'​)) , ST_GeomFromText('​POINT(25.657480 45.568128)'​) )  AS distance +
-FROM `cm-wiki`.gsm_cells  +
-ORDER BY distance +
-LIMIT 20; +
-</​sql>​ +