svd71

"необходимо два отдельных запроса, так они будут в разных местах javascript"

/*Выборка дат по закупкам*/
$procurement = mysql_query ("SELECT data_start_god 
FROM goods 
WHERE id_com_god='{$company['inde_com']}' GROUP BY data_start_god  ORDER BY `data_start_god` ASC LIMIT 7",$db);
while ($rowk = mysql_fetch_array($procurement))
echo "'{$rowk['data_start_god']}',";

foreach($rowk as <b>$itm</b>) {
/*Подсчет cуммы товара*/
$product = mysql_query ("SELECT SUM(start_col_god) 
FROM goods 
WHERE id_com_god='{$company['inde_com']}' AND data_start_god='{<b>$itm</b>['data_start_god']}'  ORDER BY `start_col_god` ASC LIMIT 7",$db);
while ($pro = mysql_fetch_array($product))
echo "'$pro[0]',";
}

$procurement = mysql_query ("SELECT data_start_god<b>, sum(start_col_god) as sum_col_god </b>
FROM goods 
WHERE id_com_god='{$company['inde_com']}' GROUP BY data_start_god  ORDER BY `data_start_god` ASC LIMIT 7",$db);
while ($rowk = mysql_fetch_array($procurement))
echo "'{$rowk['data_start_god']}',";

procurement = mysql_query ("SELECT data_start_god 
FROM goods 
WHERE id_com_god='{$company['inde_com']}' GROUP BY data_start_god  ORDER BY `data_start_god` ASC LIMIT 7",$db);
while ($rowk = mysql_fetch_array($procurement))
echo "'{$rowk['data_start_god']}',";

select u.*,
  (select count(*) from subscribes s where s.to_user_id=u.user_id) as SUBSCRIBESCOUNT
from users u
order by u.rating desc, SUBSCRIBESCOUNT desc, u.place asc