Thanks NobbZ, I will clarify with the team what language it is.
I think my query is around what different things mean seperated by +. For example, what does this mean → ((ROUND((100 - (SELECT distance) + (LEAST(p.c_review_count, ?) * 2.5
And what does it mean → IF(p.professional_photo_graphic_id, 0, -5))),6) * 10000000000)
and what doesthis mean → (c_review_count * 1000) +
(IF(p.c_first_impression_count > 0, (((p.c_review_count * p.c_review_average_score_overall)+
((p.c_first_impression_count / 2 ) * p.c_first_impression_average_score_overall)) /
((p.c_review_count + p.c_first_impression_count) - (p.c_first_impression_count / 2))),
p.c_review_average_score_overall) * 10))