SELECT * from MON_recomanacions
LEFT JOIN MON_ciutats_mon on rec_ciutat = cit_id
LEFT JOIN MON_paisos on cit_CountryId = pai_id
WHERE 1
AND rec_ciutat='9865'
AND rec_status IN (1)
ORDER BY rec_nom
SELECT
*,
ROUND(
6371 * ACOS(
COS(RADIANS(43.347599029541))
* COS(RADIANS(rec_lat))
* COS(RADIANS(rec_long) - RADIANS(3.2189900875092))
+ SIN(RADIANS(43.347599029541))
* SIN(RADIANS(rec_lat))
),
2
) AS distancia_km
FROM MON_recomanacions
LEFT JOIN MON_ciutats_mon on rec_ciutat = cit_id
LEFT JOIN MON_paisos on cit_CountryId = pai_id
WHERE 1
ORDER BY distancia_km
LIMIT 0, 10
SELECT * , count(*) as total from MON_recomanacions
LEFT JOIN MON_ciutats_mon on rec_ciutat = cit_id
LEFT JOIN MON_paisos on cit_CountryId = pai_id
WHERE 1
AND rec_status IN (1)
GROUP BY pai_cat
ORDER BY pai_cat, cit_Name
SELECT * , count(*) as total from MON_recomanacions
LEFT JOIN MON_ciutats_mon on rec_ciutat = cit_id
LEFT JOIN MON_paisos on cit_CountryId = pai_id
WHERE 1
AND rec_tipus IN (1)
AND rec_status IN (1)
GROUP BY rec_opcio1
ORDER BY rec_opcio1
SELECT * , count(*) as total from MON_recomanacions
LEFT JOIN MON_ciutats_mon on rec_ciutat = cit_id
LEFT JOIN MON_paisos on cit_CountryId = pai_id
WHERE 1
AND rec_tipus IN (1)
AND rec_status IN (1)
GROUP BY rec_ciutat
ORDER BY cit_name
RECOMANACIONS de Catalans al MON
SELECT * , count(*) as total from MON_recomanacions
LEFT JOIN MON_ciutats_mon on rec_ciutat = cit_id
LEFT JOIN MON_paisos on cit_CountryId = pai_id
WHERE 1
AND rec_tipus IN (1)
AND rec_status IN (1)
GROUP BY rec_ciutat
ORDER BY cit_Name
Vius a l'estranger i vols contactar amb altres catalans? CATALANSALMON.COM et muntem una web latevaciutat.catalansalmon.com, de franc només has de demanar-la.
