MySQL сообщает: Unknown column 'p.star_rating' in 'field list'<br>
Это был запрос dbResultMenuFiltersTotal: select COUNT(IF(`idobj` != '0', 1, NULL)) `objcount`, min(minprice) `minprice`, max(maxprice) `maxprice`, sum(beach1) beach1, 
    sum(food) food, 
    sum(animals) animals, 
    sum(socket220) socket220, 
    sum(restoran) restoran, 
    sum(conferencehall) conferencehall, 
    sum(videonab) videonab, 
    sum(parking) parking, 
    sum(internet) internet, 
    sum(pond) pond, 
    sum(excursions) excursions, 
    sum(spa) spa, 
    sum(kamin) kamin, 
    sum(kaljan) kaljan, 
    sum(karaoke) karaoke, 
    sum(voleibol) voleibol, 
    sum(nasttennis) nasttennis, 
    sum(tenniscourts) tenniscourts, 
    sum(trainingroom) trainingroom, 
    sum(shouprogr) shouprogr, 
    sum(fishing) fishing, 
    sum(bicyclerent) bicyclerent, 
    sum(vanna) vanna, 
    sum(dush) dush, 
    sum(kondicioner) kondicioner, 
    sum(balkon) balkon, 
    sum(tvset) tvset, 
    sum(holodilnik) holodilnik, 
    sum(seavizion) seavizion, 
    sum(lift) lift, 
    sum(rooms1) rooms1, 
    sum(rooms2) rooms2, 
    sum(rooms3) rooms3, 
    sum(rooms4) rooms4, 
    sum(rooms5) rooms5, 
    sum(wpool) wpool, 
    sum(kids) kids, 
    sum(beach2) beach2, 
    sum(beach3) beach3, 
    sum(food0) food0, 
    sum(food1) food1, 
    sum(food2) food2, 
    sum(food3) food3, 
    sum(food4) food4, 
    sum(food5) food5, 
    sum(billiard) billiard, 
    min(distance_min) `distance_min`, max(distance_max) `distance_max`, 
    sum(food_br) food_br, 
    sum(xpos) xpos, 
    sum(coop) coop, 
    sum(saunabathhouse) saunabathhouse, 
    sum(bath_and_shower) bath_and_shower, 
    sum(star_rating3) star_rating3, 
    sum(star_rating4) star_rating4, 
    sum(star_rating5) star_rating5 from(
select p.idobj, objidparent, min(prices.price) `minprice`,
max(prices.price) `maxprice`, IF(COUNT(IF(p.`beach` = '1', 1, NULL)) > 0, 1, 0) `beach1`, 
    IF(COUNT(IF(p.`food` != '0', 1, NULL)) > 0, 1, 0) `food`, 
    IF(COUNT(IF(p.`animals` > '1', 1, NULL)) > 0, 1, 0) `animals`, 
    max(p.socket220) socket220, 
    max(p.restoran) restoran, 
    max(p.conferencehall) conferencehall, 
    max(p.videonab) videonab, 
    max(p.parking) parking, 
    IF(COUNT(IF(p.`internet` > '1', 1, NULL)) > 0, 1, 0) `internet`, 
    max(p.pond) pond, 
    max(p.excursions) excursions, 
    max(p.spa) spa, 
    max(p.kamin) kamin, 
    max(p.kaljan) kaljan, 
    max(p.karaoke) karaoke, 
    max(p.voleibol) voleibol, 
    max(p.nasttennis) nasttennis, 
    max(p.tenniscourts) tenniscourts, 
    max(p.trainingroom) trainingroom, 
    max(p.shouprogr) shouprogr, 
    max(p.fishing) fishing, 
    max(p.bicyclerent) bicyclerent, 
    max(c.vanna) vanna, 
    max(c.dush) dush, 
    max(c.kondicioner) kondicioner, 
    max(c.balkon) balkon, 
    max(c.tvset) tvset, 
    max(c.holodilnik) holodilnik, 
    max(c.seavizion) seavizion, 
    IF(COUNT(IF(p.`lift` = '1', 1, NULL)) > 0, 1, 0) `lift`, 
    IF(COUNT(IF(c.`numrooms` = '1', 1, NULL)) > 0, 1, 0) `rooms1`, 
    IF(COUNT(IF(c.`numrooms` = '2', 1, NULL)) > 0, 1, 0) `rooms2`, 
    IF(COUNT(IF(c.`numrooms` = '3', 1, NULL)) > 0, 1, 0) `rooms3`, 
    IF(COUNT(IF(c.`numrooms` = '4', 1, NULL)) > 0, 1, 0) `rooms4`, 
    IF(COUNT(IF(c.`numrooms` = '5', 1, NULL)) > 0, 1, 0) `rooms5`, 
    IF(COUNT(IF(p.`closewpool` = '1', 1, NULL) OR IF(p.`openwpool` = '1', 1, NULL) OR IF(p.`openwpoolheated` = '1', 1, NULL)) > 0, 1, 0) `wpool`, 
    IF(COUNT(IF(p.`detgorodok` = '1', 1, NULL) OR IF(p.`dethotwpool` = '1', 1, NULL) OR IF(p.`detcoldwpool` = '1', 1, NULL) OR IF(p.`animator` = '1', 1, NULL) OR IF(p.`detclub` = '1', 1, NULL)) > 0, 1, 0) `kids`, 
    IF(COUNT(IF(p.`beach` = '2', 1, NULL)) > 0, 1, 0) `beach2`, 
    IF(COUNT(IF(p.`beach` = '3', 1, NULL)) > 0, 1, 0) `beach3`, 
    IF(COUNT(IF(p.`food` = '0', 1, NULL)) > 0, 1, 0) `food0`, 
    IF(COUNT(IF(p.`food` = '1', 1, NULL)) > 0, 1, 0) `food1`, 
    IF(COUNT(IF(p.`food` = '2', 1, NULL)) > 0, 1, 0) `food2`, 
    IF(COUNT(IF(p.`food` = '3', 1, NULL)) > 0, 1, 0) `food3`, 
    IF(COUNT(IF(p.`food` = '4', 1, NULL)) > 0, 1, 0) `food4`, 
    IF(COUNT(IF(p.`food` = '5', 1, NULL)) > 0, 1, 0) `food5`, 
    IF(COUNT(IF(p.`rusbilliard` = '1', 1, NULL) OR IF(p.`ambilliard` = '1', 1, NULL)) > 0, 1, 0) `billiard`, 
    min(p.distance) `distance_min`, max(p.distance) `distance_max`, 
    IF(COUNT(IF(p.`food` = '1', 1, NULL) OR IF(p.`food` = '5', 1, NULL)) > 0, 1, 0) `food_br`, 
    IF(COUNT(IF(p.`xpos` > '0', 1, NULL)) > 0, 1, 0) `xpos`, 
    IF(COUNT(IF(p.`cooperation` != '0', 1, NULL)) > 0, 1, 0) `coop`, 
    IF(COUNT(IF(p.`finsauna` = '1', 1, NULL) OR IF(p.`rusbanja` = '1', 1, NULL) OR IF(p.`tursauna` = '1', 1, NULL)) > 0, 1, 0) `saunabathhouse`, 
    IF(COUNT(IF(c.`dush` = '1', 1, NULL) OR IF(c.`vanna` = '1', 1, NULL)) > 0, 1, 0) `bath_and_shower`, 
    IF(COUNT(IF(p.`star_rating` = '3', 1, NULL)) > 0, 1, 0) `star_rating3`, 
    IF(COUNT(IF(p.`star_rating` = '4', 1, NULL)) > 0, 1, 0) `star_rating4`, 
    IF(COUNT(IF(p.`star_rating` = '5', 1, NULL)) > 0, 1, 0) `star_rating5`

 from obj c join prices on c.idobj = prices.objid join obj p on prices.objidparent = p.idobj 
where p.adminchecked = 1 AND p.activity = 1  AND p.objtype IN (6) AND p.locationid IN (4, 40, 41, 42, 27, 36, 281, 43, 29, 44, 37, 21, 47, 49, 51, 30, 56, 59, 60, 61, 62, 46, 31, 64, 66, 22, 77, 288, 72, 35, 73, 75, 79, 280, 23, 83, 85, 92, 95, 98, 32, 107, 3, 26, 68, 24, 118, 113, 33)
group by p.idobj) t<br>