SELECT it.items as name, it.grams as grams, it.portion as portion,  it.calories as calories, it.grams_p as protein, it.grams_c as carbs,  it.grams_f as fat, it.grams_sat_f as saturated, (SQRT(((((14 -  (it.grams_p*4/((it.grams_p * 4) + (it.grams_c * 4) + (it.grams_f * 9))))  - (((14 - (it.grams_p*4/((it.grams_p * 4) + (it.grams_c * 4) +  (it.grams_f * 9)))) + (56 - (it.grams_c*4/((it.grams_p * 4) +  (it.grams_c * 4) + (it.grams_f * 9)))) + (30 -  (it.grams_f*9/((it.grams_p * 4) + (it.grams_c * 4) + (it.grams_f *  9)))))/3)) * ((14 - (it.grams_p*4/((it.grams_p * 4) + (it.grams_c * 4) +  (it.grams_f * 9)))) - (((14 - (it.grams_p*4/((it.grams_p * 4) +  (it.grams_c * 4) + (it.grams_f * 9)))) + (56 -  (it.grams_c*4/((it.grams_p * 4) + (it.grams_c * 4) + (it.grams_f * 9))))  + (30 - (it.grams_f*9/((it.grams_p * 4) + (it.grams_c * 4) +  (it.grams_f * 9)))))/3))) + (((56 - (it.grams_c*4/((it.grams_p * 4) +  (it.grams_c * 4) + (it.grams_f * 9)))) - (((14 -  (it.grams_p*4/((it.grams_p * 4) + (it.grams_c * 4) + (it.grams_f * 9)))) + (56 - (it.grams_c*4/((it.grams_p * 4) +  (it.grams_c * 4) + (it.grams_f * 9)))) + (30 -  (it.grams_f*9/((it.grams_p * 4) + (it.grams_c * 4) + (it.grams_f *  9)))))/3)) * ((56 - (it.grams_c*4/((it.grams_p * 4) + (it.grams_c * 4) +  (it.grams_f * 9)))) - (((14 - (it.grams_p*4/((it.grams_p * 4) +  (it.grams_c * 4) + (it.grams_f * 9)))) + (56 -  (it.grams_c*4/((it.grams_p * 4) + (it.grams_c * 4) + (it.grams_f * 9))))  + (30 - (it.grams_f*9/((it.grams_p * 4) + (it.grams_c * 4) +  (it.grams_f * 9)))))/3))) + (((30 - (it.grams_f*9/((it.grams_p * 4) +  (it.grams_c * 4) + (it.grams_f * 9)))) - (((14 -  (it.grams_p*4/((it.grams_p * 4) + (it.grams_c * 4) + (it.grams_f * 9))))  + (56 - (it.grams_c*4/((it.grams_p * 4) + (it.grams_c * 4) +  (it.grams_f * 9)))) + (30 - (it.grams_f*9/((it.grams_p * 4) +  (it.grams_c * 4) + (it.grams_f * 9)))))/3)) * ((30 - (it.grams_f*9/((it.grams_p * 4) +  (it.grams_c * 4) + (it.grams_f * 9)))) - (((14 -  (it.grams_p*4/((it.grams_p * 4) + (it.grams_c * 4) + (it.grams_f * 9))))  + (56 - (it.grams_c*4/((it.grams_p * 4) + (it.grams_c * 4) +  (it.grams_f * 9)))) + (30 - (it.grams_f*9/((it.grams_p * 4) +  (it.grams_c * 4) + (it.grams_f * 9)))))/3))))/2) * ((14 -  (it.grams_p*4/((it.grams_p * 4) + (it.grams_c * 4) + (it.grams_f * 9))))  + (56 - (it.grams_c*4/((it.grams_p * 4) + (it.grams_c * 4) +  (it.grams_f * 9)))) + (30 - (it.grams_f*9/((it.grams_p * 4) +  (it.grams_c * 4) + (it.grams_f * 9)))))) AS sortorder FROM items it LEFT  JOIN intake int_f ON (it.id_foods=int_f.id_foods and int_f.Date >=  DATE_SUB(CURDATE(),INTERVAL 4 DAY) and int_f.user_id='1') LEFT JOIN  intake int_fg ON (it.id_groups=int_fg.id_groups and int_fg.Date >=  DATE_SUB(CURDATE(),INTERVAL 2 DAY) and int_fg.user_id='1') WHERE  int_f.id_intake IS NULL and int_fg.id_intake IS NULL ORDER BY sortorder  ASC