SELECT mm_seller_pages.header, count( mm_adverts.id ) AS advert_counter FROM mm_regions, mm_users, mm_seller_pages LEFT JOIN mm_adverts, mm_adverts_types ON ( ( ( mm_adverts_types.length + mm_adverts.time ) >1159458590 AND mm_adverts.time <1159458590 AND mm_adverts.end_time =0 ) OR ( mm_adverts.end_time >1159458590 AND mm_adverts.time <1159458590 ) ) WHERE ( mm_adverts.user_id = mm_users.id AND mm_users.id = mm_seller_pages.user_id AND mm_users.user_province = mm_regions.id ) GROUP BY mm_seller_pages.id;
jako advert_counter zwraca mi wp ierwszym wierszu 14, w drugim 1. (Pominmy to ze powionny byc 4 i 0)
na
count( adverts.id ) AS advert_counter.........
jak zmienie
na
count( mm_adverts.id ) AS advert_counter.........
count( mm_seller_pages.id ) AS advert_counter
to te same wyniki mi zwraca mio ze powionny zwrocic co innego (w typ wypadku 2 razy po 2)
o co chodzi? nie kumam w tym momenice funkcji count()
skladnia jest dobra... bo jedna kcos mi zwraca....