3.88 1.67 1.53 1.52 
+ - -
##</code><code>##

SELECT DISTINCT (country, zipcode, city) FROM fruit_load WHERE fruit_load.sold_date BETWEEN NOW() - INTERVAL 60 DAY AND NOW();

SELECT DISTINCT (owner) FROM fruit_pricing b JOIN fruit_load a ON a.fruit_load_id = b.fruit_load_id WHERE a.country= '$data[0]' AND a.zipcode = '$data[1]' AND a.city = '$data[2]';

SELECT DISTINCT (mgroup) FROM fruit_pricing b JOIN fruit_load a ON a.fruit_load_id = b.fruit_load_id WHERE a.country = '$data[0]' AND a.zipcode = '$data[1]' AND a.city = '$data[2]' AND b.owner ='$data2[0]';

SELECT DISTINCT (fruit) FROM fruit_pricing b JOIN fruit_load a ON a. fruit_load_id = b. fruit_load_id WHERE a.country = '$data[0]' AND a.zipcode = '$data[1]' AND a.city = '$data[2]' AND b.owner = '$data2[0]' AND b.mgroup = '$data3[0]';

SELECT * FROM fruit_load a
JOIN fruit_pricing b ON a.fruit_load_id = b.fruit_load_id
WHERE b.sold_date BETWEEN NOW() - INTERVAL 180 DAY AND NOW()
AND a.country = '$data[0]'
AND a.zipcode = '$data[1]'
AND a.city = '$data[2]'
AND b.owner = '$data2[0]'
AND b.mgroup = '$data3[0]'
AND b.fruit = '$data4[0]'
ORDER BY sold_date DESC;

put found row into array in this loop

SELECT DISTINCT (subgroup) FROM special_fruit_price c JOIN fruit_load a ON a.fruit_load_id = c.fruit_load_id WHERE a.country = '$data[0]' AND a.zipcode = '$data[1]' AND a.city = '$data[2]' AND c.owner = '$data2[0]';

SELECT DISTINCT (special_fruit)
FROM special_fruit_price c
JOIN fruit_load a ON a.fruit_load_id = c.fruit_load_id
WHERE a.country = '$data[0]' AND a.zipcode = '$data[1]' AND a.city = '$data[2]' AND c.owner = '$data2[0]'
AND c.mgroup = '$data3[0]' AND c.subgroup = '$data6[0]';

SELECT * FROM fruit_load a
JOIN special_fruit_price c ON a.fruit_load_id = c.fruit_load_id
WHERE c.sold_date BETWEEN NOW() - INTERVAL 180 DAY AND NOW()
AND a.country = '$data[0]'
AND a.zipcode = '$data[1]'
AND a.city = '$data[2]'
AND c.owner = '$data2[0]'
AND c.mgroup = '$data3[0]'
AND c.subgroup = '$data6[0]'
AND c.special_fruit = '$data7[0]'
ORDER BY sold_date DESC;

put found row into array in this loop