$query="
SELECT
processor_reviews.id,
processor_reviews.manufacturer,
processor_reviews.filename,
processor_reviews.heading,
processor_reviews.review,
processor_reviews.active,
manufacturers.id,
manufacturers.name,
manufacturers.directory,
manufacturers.kind,
processor_reviews.kernel,
processor_reviews.freq_from,
processor_reviews.freq_from,
processor_reviews.frequency,
processor_reviews.voltage,
processor_reviews.cache_l1,
processor_reviews.cache_l2,
processor_reviews.instruction,
processor_reviews.technology,
processor_reviews.socket,
processor_kernel.id,
processor_kernel.name,
processor_freq_from.id,
processor_freq_from.name,
processor_freq_to.id,
processor_freq_to.name,
processor_frequency.id,
processor_frequency.name,
processor_cache_l1.id,
processor_cache_l1.name,
processor_cache_l2.id,
processor_cache_l2.name,
processor_instruction.id,
processor_instruction.name,
processor_technology.id,
processor_technology.name,
processor_socket.id,
processor_socket.name
FROM processor_reviews
LEFT JOIN manufacturers ON manufacturers.id=processor_reviews.manufacturer
LEFT JOIN processor_kernel ON processor_kernel.id=processor_reviews.kernel
LEFT JOIN processor_freq_from ON processor_freq_from.id=processor_reviews.freq_from
LEFT JOIN processor_freq_to ON processor_freq_to.id=processor_reviews.freq_to
LEFT JOIN processor_frequency ON processor_frequency.id=processor_reviews.frequency
LEFT JOIN processor_cache_l1 ON processor_cache_l1.id=processor_reviews.cache_l1
LEFT JOIN processor_cache_l2 ON processor_cache_l2.id=processor_reviews.cache_l2
LEFT JOIN processor_instruction ON processor_instruction.id=processor_reviews.instruction
LEFT JOIN processor_technology ON processor_technology.id=processor_reviews.technology
LEFT JOIN processor_socket ON processor_socket.id=processor_reviews.socket
WHERE processor_reviews.active=1 AND manufacturers.kind='$cat' AND " . $query_processor ."
ORDER BY manufacturers.name,processor_reviews.heading";
$result=mysql_query($query,$db);
while ($row_array = mysql_fetch_array ($result)) {
if ($row_array[5] == 1) {$status="Отменить";}
else {$status="Показать";}
if ($i==0) {$bgcolor='white'; $i++;} else {$bgcolor='#e7e7e7'; $i--;}
echo "