| 1 | SELECT * , TRUNCATE((3958 * 3.1415926 * SQRT((`Scheda`.`coor_lat` - 45.07093) * (`Scheda`.`coor_lat` - 45.07093) + COS(`Scheda`.`coor_lat` / 57.29578) * COS(45.07093 / 57.29578) * (`Scheda`.`coor_lon` - 10.845689) * (`Scheda`.`coor_lon` - 10.845689)) / 180),2) AS distance FROM `schede` AS `Scheda` LEFT JOIN `temi` AS `Tema` ON ( `Scheda`.`tema_id` = `Tema`.`id` ) LEFT JOIN `flags_schede` AS `FlagsScheda` ON ( `FlagsScheda`.`scheda_id` = `Scheda`.`id` ) WHERE `FlagsScheda`.`flag_id` =2162 OR `FlagsScheda`.`flag_id` =2163 OR `FlagsScheda`.`flag_id` =2164 OR `FlagsScheda`.`flag_id` =2165 OR `FlagsScheda`.`flag_id` =2166 OR `FlagsScheda`.`flag_id` =2167 OR `FlagsScheda`.`flag_id` =2168 OR `FlagsScheda`.`flag_id` =2169 OR `FlagsScheda`.`flag_id` =2170 OR `FlagsScheda`.`flag_id` =2171 OR `FlagsScheda`.`flag_id` =2172 OR `FlagsScheda`.`flag_id` =2173 OR `FlagsScheda`.`flag_id` =2174 GROUP BY scheda_id HAVING distance <= 15 ORDER BY `distance` asc LIMIT 0,30 | | 20 | 20 | 106 |
| 2 | SELECT count(*) AS `count` FROM `schede` AS `Scheda`
LEFT JOIN `temi` AS `Tema` ON (`Scheda`.`tema_id` = `Tema`.`id`)
LEFT JOIN `flags_schede` AS `FlagsScheda` ON (`FlagsScheda`.`scheda_id` = `Scheda`.`id`)
WHERE (`FlagsScheda`.`flag_id` =2285 OR `FlagsScheda`.`flag_id` =2286 OR `FlagsScheda`.`flag_id` =2287 OR `FlagsScheda`.`flag_id` =2288 OR `FlagsScheda`.`flag_id` =2289 OR `FlagsScheda`.`flag_id` =2290 OR `FlagsScheda`.`flag_id` =2291 OR `FlagsScheda`.`flag_id` =2292 OR `FlagsScheda`.`flag_id` =2293 OR `FlagsScheda`.`flag_id` =2294 OR `FlagsScheda`.`flag_id` =2295 OR `FlagsScheda`.`flag_id` =2296 OR `FlagsScheda`.`flag_id` =2297)
AND `Scheda`.`denominazione` LIKE '%' AND `Scheda`.`denominazione` != ''
GROUP BY scheda_id | | 208 | 208 | 0 |
| 3 | SELECT count(*) AS `count` FROM `schede` AS `Scheda`
LEFT JOIN `temi` AS `Tema` ON (`Scheda`.`tema_id` = `Tema`.`id`)
LEFT JOIN `flags_schede` AS `FlagsScheda` ON (`FlagsScheda`.`scheda_id` = `Scheda`.`id`)
WHERE (`FlagsScheda`.`flag_id` =2162)
AND `Scheda`.`denominazione` LIKE '%' AND `Scheda`.`denominazione` != ''
GROUP BY scheda_id | | 456 | 456 | 0 |
| 4 | SELECT count(*) AS `count` FROM `schede` AS `Scheda`
LEFT JOIN `temi` AS `Tema` ON (`Scheda`.`tema_id` = `Tema`.`id`)
LEFT JOIN `flags_schede` AS `FlagsScheda` ON (`FlagsScheda`.`scheda_id` = `Scheda`.`id`)
WHERE (`FlagsScheda`.`flag_id` =2162 OR `FlagsScheda`.`flag_id` =2163 OR `FlagsScheda`.`flag_id` =2164 OR `FlagsScheda`.`flag_id` =2165 OR `FlagsScheda`.`flag_id` =2166 OR `FlagsScheda`.`flag_id` =2167 OR `FlagsScheda`.`flag_id` =2168 OR `FlagsScheda`.`flag_id` =2169 OR `FlagsScheda`.`flag_id` =2170 OR `FlagsScheda`.`flag_id` =2171 OR `FlagsScheda`.`flag_id` =2172 OR `FlagsScheda`.`flag_id` =2173 OR `FlagsScheda`.`flag_id` =2174)
AND `Scheda`.`denominazione` LIKE '%' AND `Scheda`.`denominazione` != ''
GROUP BY scheda_id | | 2042 | 2042 | 1 |
| 5 | SELECT count(*) AS `count` FROM `schede` AS `Scheda`
LEFT JOIN `temi` AS `Tema` ON (`Scheda`.`tema_id` = `Tema`.`id`)
LEFT JOIN `flags_schede` AS `FlagsScheda` ON (`FlagsScheda`.`scheda_id` = `Scheda`.`id`)
WHERE (`FlagsScheda`.`flag_id` =2282 OR `FlagsScheda`.`flag_id` =2283 OR `FlagsScheda`.`flag_id` =2284)
AND `Scheda`.`denominazione` LIKE '%' AND `Scheda`.`denominazione` != ''
GROUP BY scheda_id | | 338 | 338 | 0 |
| 6 | SELECT count(*) AS `count` FROM `schede` AS `Scheda`
LEFT JOIN `temi` AS `Tema` ON (`Scheda`.`tema_id` = `Tema`.`id`)
LEFT JOIN `flags_schede` AS `FlagsScheda` ON (`FlagsScheda`.`scheda_id` = `Scheda`.`id`)
WHERE (`FlagsScheda`.`flag_id` =2175 OR `FlagsScheda`.`flag_id` =2176 OR `FlagsScheda`.`flag_id` =2177 OR `FlagsScheda`.`flag_id` =2178 OR `FlagsScheda`.`flag_id` =2179 OR `FlagsScheda`.`flag_id` =2180 OR `FlagsScheda`.`flag_id` =2181 OR `FlagsScheda`.`flag_id` =2182 OR `FlagsScheda`.`flag_id` =2183)
AND `Scheda`.`denominazione` LIKE '%' AND `Scheda`.`denominazione` != ''
GROUP BY scheda_id | | 1012 | 1012 | 0 |
| 7 | SELECT count(*) AS `count` FROM `schede` AS `Scheda`
LEFT JOIN `temi` AS `Tema` ON (`Scheda`.`tema_id` = `Tema`.`id`)
LEFT JOIN `flags_schede` AS `FlagsScheda` ON (`FlagsScheda`.`scheda_id` = `Scheda`.`id`)
WHERE (`FlagsScheda`.`flag_id` =2374 OR `FlagsScheda`.`flag_id` =2375 OR `FlagsScheda`.`flag_id` =2376 OR `FlagsScheda`.`flag_id` =2377 OR `FlagsScheda`.`flag_id` =2378 OR `FlagsScheda`.`flag_id` =2379 OR `FlagsScheda`.`flag_id` =2380 OR `FlagsScheda`.`flag_id` =2381 OR `FlagsScheda`.`flag_id` =2382 OR `FlagsScheda`.`flag_id` =2383 OR `FlagsScheda`.`flag_id` =2384 OR `FlagsScheda`.`flag_id` =2385 OR `FlagsScheda`.`flag_id` =2386 OR `FlagsScheda`.`flag_id` =2387 OR `FlagsScheda`.`flag_id` =2388 OR `FlagsScheda`.`flag_id` =2389 OR `FlagsScheda`.`flag_id` =2390 OR `FlagsScheda`.`flag_id` =2391 OR `FlagsScheda`.`flag_id` =2392 OR `FlagsScheda`.`flag_id` =2393 OR `FlagsScheda`.`flag_id` =2394 OR `FlagsScheda`.`flag_id` =2395 OR `FlagsScheda`.`flag_id` =2396 OR `FlagsScheda`.`flag_id` =2397 OR `FlagsScheda`.`flag_id` =2398 OR `FlagsScheda`.`flag_id` =2399 OR `FlagsScheda`.`flag_id` =2400 OR `FlagsScheda`.`flag_id` =2401 OR `FlagsScheda`.`flag_id` =2402 OR `FlagsScheda`.`flag_id` =2403 OR `FlagsScheda`.`flag_id` =2404 OR `FlagsScheda`.`flag_id` =2405 OR `FlagsScheda`.`flag_id` =2406 OR `FlagsScheda`.`flag_id` =2407 OR `FlagsScheda`.`flag_id` =2408 OR `FlagsScheda`.`flag_id` =2409 OR `FlagsScheda`.`flag_id` =2410 OR `FlagsScheda`.`flag_id` =2411 OR `FlagsScheda`.`flag_id` =2412 OR `FlagsScheda`.`flag_id` =2413 OR `FlagsScheda`.`flag_id` =2414 OR `FlagsScheda`.`flag_id` =2415 OR `FlagsScheda`.`flag_id` =2416 OR `FlagsScheda`.`flag_id` =2417 OR `FlagsScheda`.`flag_id` =2418 OR `FlagsScheda`.`flag_id` =2419 OR `FlagsScheda`.`flag_id` =2420 OR `FlagsScheda`.`flag_id` =2421 OR `FlagsScheda`.`flag_id` =2422 OR `FlagsScheda`.`flag_id` =2423 OR `FlagsScheda`.`flag_id` =2424 OR `FlagsScheda`.`flag_id` =2425 OR `FlagsScheda`.`flag_id` =2426 OR `FlagsScheda`.`flag_id` =2427 OR `FlagsScheda`.`flag_id` =2428 OR `FlagsScheda`.`flag_id` =2429 OR `FlagsScheda`.`flag_id` =2430 OR `FlagsScheda`.`flag_id` =2431 OR `FlagsScheda`.`flag_id` =2432 OR `FlagsScheda`.`flag_id` =2433 OR `FlagsScheda`.`flag_id` =2434 OR `FlagsScheda`.`flag_id` =2435 OR `FlagsScheda`.`flag_id` =2436 OR `FlagsScheda`.`flag_id` =2437 OR `FlagsScheda`.`flag_id` =2438 OR `FlagsScheda`.`flag_id` =2439 OR `FlagsScheda`.`flag_id` =2440 OR `FlagsScheda`.`flag_id` =2441 OR `FlagsScheda`.`flag_id` =2442 OR `FlagsScheda`.`flag_id` =2443 OR `FlagsScheda`.`flag_id` =2444 OR `FlagsScheda`.`flag_id` =2445 OR `FlagsScheda`.`flag_id` =2446 OR `FlagsScheda`.`flag_id` =2447 OR `FlagsScheda`.`flag_id` =2448 OR `FlagsScheda`.`flag_id` =2449 OR `FlagsScheda`.`flag_id` =2450 OR `FlagsScheda`.`flag_id` =2451 OR `FlagsScheda`.`flag_id` =2452 OR `FlagsScheda`.`flag_id` =2453 OR `FlagsScheda`.`flag_id` =2454 OR `FlagsScheda`.`flag_id` =2455 OR `FlagsScheda`.`flag_id` =2456 OR `FlagsScheda`.`flag_id` =2457 OR `FlagsScheda`.`flag_id` =2458 OR `FlagsScheda`.`flag_id` =2459 OR `FlagsScheda`.`flag_id` =2460 OR `FlagsScheda`.`flag_id` =2461 OR `FlagsScheda`.`flag_id` =2462 OR `FlagsScheda`.`flag_id` =2463 OR `FlagsScheda`.`flag_id` =2464 OR `FlagsScheda`.`flag_id` =2465 OR `FlagsScheda`.`flag_id` =2466 OR `FlagsScheda`.`flag_id` =2467 OR `FlagsScheda`.`flag_id` =2468 OR `FlagsScheda`.`flag_id` =2469 OR `FlagsScheda`.`flag_id` =2470 OR `FlagsScheda`.`flag_id` =2471 OR `FlagsScheda`.`flag_id` =2472 OR `FlagsScheda`.`flag_id` =2473 OR `FlagsScheda`.`flag_id` =2474 OR `FlagsScheda`.`flag_id` =2475 OR `FlagsScheda`.`flag_id` =2476 OR `FlagsScheda`.`flag_id` =2477 OR `FlagsScheda`.`flag_id` =2478 OR `FlagsScheda`.`flag_id` =2479 OR `FlagsScheda`.`flag_id` =2480 OR `FlagsScheda`.`flag_id` =2481 OR `FlagsScheda`.`flag_id` =2482 OR `FlagsScheda`.`flag_id` =2483 OR `FlagsScheda`.`flag_id` =2484 OR `FlagsScheda`.`flag_id` =2485 OR `FlagsScheda`.`flag_id` =2486 OR `FlagsScheda`.`flag_id` =2487 OR `FlagsScheda`.`flag_id` =2488 OR `FlagsScheda`.`flag_id` =2489 OR `FlagsScheda`.`flag_id` =2490 OR `FlagsScheda`.`flag_id` =2491 OR `FlagsScheda`.`flag_id` =2492 OR `FlagsScheda`.`flag_id` =2493 OR `FlagsScheda`.`flag_id` =2494 OR `FlagsScheda`.`flag_id` =2495 OR `FlagsScheda`.`flag_id` =2496 OR `FlagsScheda`.`flag_id` =2497 OR `FlagsScheda`.`flag_id` =2498 OR `FlagsScheda`.`flag_id` =2499 OR `FlagsScheda`.`flag_id` =2500 OR `FlagsScheda`.`flag_id` =2501 OR `FlagsScheda`.`flag_id` =2502 OR `FlagsScheda`.`flag_id` =2503 OR `FlagsScheda`.`flag_id` =2504 OR `FlagsScheda`.`flag_id` =2505 OR `FlagsScheda`.`flag_id` =2506 OR `FlagsScheda`.`flag_id` =2507 OR `FlagsScheda`.`flag_id` =2508 OR `FlagsScheda`.`flag_id` =2509 OR `FlagsScheda`.`flag_id` =2510 OR `FlagsScheda`.`flag_id` =2511 OR `FlagsScheda`.`flag_id` =2512 OR `FlagsScheda`.`flag_id` =2513 OR `FlagsScheda`.`flag_id` =2514 OR `FlagsScheda`.`flag_id` =2515 OR `FlagsScheda`.`flag_id` =2516 OR `FlagsScheda`.`flag_id` =2517 OR `FlagsScheda`.`flag_id` =2518 OR `FlagsScheda`.`flag_id` =2519 OR `FlagsScheda`.`flag_id` =2520 OR `FlagsScheda`.`flag_id` =2521 OR `FlagsScheda`.`flag_id` =2522 OR `FlagsScheda`.`flag_id` =2523 OR `FlagsScheda`.`flag_id` =2524 OR `FlagsScheda`.`flag_id` =2525 OR `FlagsScheda`.`flag_id` =2526)
AND `Scheda`.`denominazione` LIKE '%' AND `Scheda`.`denominazione` != ''
GROUP BY scheda_id | | 268 | 268 | 0 |
| 8 | SELECT count(*) AS `count` FROM `schede` AS `Scheda`
LEFT JOIN `temi` AS `Tema` ON (`Scheda`.`tema_id` = `Tema`.`id`)
LEFT JOIN `flags_schede` AS `FlagsScheda` ON (`FlagsScheda`.`scheda_id` = `Scheda`.`id`)
WHERE (`FlagsScheda`.`flag_id` =2185)
AND `Scheda`.`denominazione` LIKE '%' AND `Scheda`.`denominazione` != ''
GROUP BY scheda_id | | 1383 | 1383 | 1 |
| 9 | SELECT count(*) AS `count` FROM `schede` AS `Scheda`
LEFT JOIN `temi` AS `Tema` ON (`Scheda`.`tema_id` = `Tema`.`id`)
LEFT JOIN `flags_schede` AS `FlagsScheda` ON (`FlagsScheda`.`scheda_id` = `Scheda`.`id`)
WHERE (`FlagsScheda`.`flag_id` =2184 OR `FlagsScheda`.`flag_id` =2186)
AND `Scheda`.`denominazione` LIKE '%' AND `Scheda`.`denominazione` != ''
GROUP BY scheda_id | | 1107 | 1107 | 0 |
| 10 | SELECT COUNT(*) AS `count` FROM `ospitalitalia_beta`.`schede` AS `Scheda` LEFT JOIN `ospitalitalia_beta`.`locations` AS `Location` ON (`Scheda`.`location_id` = `Location`.`id`) LEFT JOIN `ospitalitalia_beta`.`flags_schede` AS `FlagsScheda` ON (`FlagsScheda`.`scheda_id` = `Scheda`.`id`) WHERE flag_id in ('2313','2314','2315','2316','2317','2318','2319','2320','2321','2322','2323','2324','2325','2326','2327','2328','2329','2330','2331','2332','2333','2334','2335','2336','2337','2338','2339','2340','2341','2342','2343','2344') | | 1 | 1 | 0 |
| 11 | SELECT `Pub`.`id`, `Pub`.`title`, `Pub`.`payoff` FROM `ospitalitalia_beta`.`pubs` AS `Pub` WHERE ((title is not null) AND (`status` > 0)) ORDER BY `published` DESC LIMIT 6 | | 6 | 6 | 0 |
Iscrizione al canale RSS
Parchi/Oasi
Attività/Sport
Musei
Monumenti
Feste/Sagre
Mercatini
Arte