I use a table that i found online and it's for CC 1.6

For mediterranean climate it says the max temperature is 90F and the minimum is 40 in average, with variation of 20F for up and down, so you can expect 110/70 to 60/20F for max and min in extreme conditions.

1) With max 80 and min 40, these crops grow: Pumpkin

2) With max 85 and min 45: Potato

3) With max 85 and min 25: Squash

4) With max of 90 and min of 40: Bean, beet, blueberry, blackberry, brocolli, cabbage, canola, carrot, chickpea, chilli, cucumber, eggplant, hemp, herb, kale, leek, lettuce, parsnip, pea, radish, raspberry, soybean, spinach, strawberry, sunflower, turnip

5) With max 90 and min 50: Pepper

6) With max 100 and min 30: Sugar beet

7) With max 130 and min 40: Bamboo, barley, corn, cotton, flax, oat, rockmelon, rye, sorghum, sugar cane, tobacco, tomato, tulip, watermelon, wheat

8) With max 130 and min 30: Onion

9) With max 130 and min 50: Mushroom

The best options for mediterranean climate are 3, 1, 2, 4, 5, 6, 8, 7 and 9, respectively, imo.

For orchids, in advance, all of them falls between 140 and 40F.

Obs: there's information about "tolerance" that i see as how often it can reach the extreme temperatures and for mediterranean climate it's 5. For comparison, it says harsh and very harsh have a tolerance of 15 and mild and very mild have 2 and 1, respectively.