Сортировка в запросе mysql - Joomla 1.5: Настройка и оптимизация

		$db->setQuery('SELECT content_id AS contid, extra_id AS eid, lastip AS lastip, rating_sum AS sum, rating_count AS count FROM #__content_extravote' .
		' ORDER BY sum DESC LIMIT '.$max_items.'');
  		$vote = $db->loadObjectList();

		$query = 'SELECT p.product_id AS pid, p.product_sku AS psku, p.product_thumb_image AS pimage, p.product_full_image AS fullimage, p.product_name AS pname, ' .
			' cx.category_id AS catid, '.$ceil_price.', p.product_s_desc AS pintro, pp.product_currency AS currency, p.product_discount_id AS discount'.
			' FROM #__vm_product p ' .
			' WHERE id IN (' . $whereid . ') LIMIT 12';

		$db->setQuery($query);
		$rows = $db->loadObjectList();

Array (
    [0] => stdClass Object (
            [pname] => IMG_4916.JPG
            [pid] => 41
  ) [1] => stdClass Object (
            [pname] => IMG_4689.JPG
            [pid] => 65
  ) [2] => stdClass Object (
            [pname] => IMG_4834.JPG
            [pid] => 77
  ) [3] => stdClass Object (
            [pname] => IMG_2455.JPG
            [pid] => 149
   )
)

ORDER BY 'material_id'='$id_1' ASC, 'material_id'='$id_2' ASC "

ORDER BY p_id IN ("149", "77", "65", "41", "150")

SELECT p.product_id AS pid, p.product_sku AS psku, p.product_thumb_image AS pimage, p.product_full_image AS fullimage, p.product_name AS pname,  cx.category_id AS catid, floor(pp.product_price) AS pprice, p.product_s_desc AS pintro, pp.product_currency AS currency, p.product_discount_id AS discount
FROM #__vm_product p
RIGHT JOIN #__vm_product_category_xref AS cx ON p.product_id = cx.product_id
RIGHT JOIN #__vm_product_price as pp ON pp.product_id = p.product_id
WHERE p.product_id IN ('149', '77', '65', '41', '150')
ORDER BY p.product_id IN (149, 77, 65, 41, 150) LIMIT 12