SELECT SQL_CALC_FOUND_ROWS `goods`.`goods_id`, `goods`.`source_price`, `goods`.`name`, `goods`.`warranty`, `gp`.`price` `price_hs`, `goods`.`vendor_id`, `vendors`.`vendor`, `goods`.`typePrefix` `g_typePrefix`, `goods`.`vendor` `g_vendor`,`goods`.`model` `g_model`, `goods`.`description` `g_description`, `goods`.`html_name` `g_htmlname`, `goods`.`picture` `g_pic`, `goods`.`rate`, DATE_FORMAT(`goods`.`t`, '%e-%m-%Y') AS `missing_since`, `gp`.`rrc` `gp_rrc` FROM `goods`, `vendors`, `goods_price` `gp`, `typePrefixes` `tp` WHERE `tp`.`id` = `goods`.`typePrefix_id` AND `vendors`.`id` = `goods`.`vendor_id` AND `gp`.`goods_id` = `goods`.`goods_id` AND `goods`.`not4yandex` = 0 AND `gp`.`site` = 161(`vendor_id` = '2832') AND gp.price > '0' ORDER BY `gp`.`price` LIMIT 0, 10