SELECT DISTINCT p.products_id, p.products_price_tax, pd.products_name, cu.value, cu.currencies_marza, (p.products_price_tax/cu.value)+(cu.value*cu.currencies_marza/100) AS cena FROM products p LEFT JOIN currencies cu ON cu.currencies_id = p.products_currencies_id LEFT JOIN products_to_categories ptc ON ptc.products_id = p.products_id LEFT JOIN products_description pd ON pd.products_id = p.products_id AND pd.language_id = '1' WHERE ptc.categories_id in (3,25,1130,707,706,705,24,703,704,27,721,719,715,716,720,713,717,722,26,708,727,726,712,731,729,728,730,711,710,745,740,741,742,747,739,743,732,735,744,737,736,23,690,677,678,676,673,674,691,692,693,675,696,679,680,681,683,682,684,686,695,697,698,971,976,972,974,973,672,687,688,685,689,694,22,671,669,668,1131,670) AND p.products_status = '1' and p.listing_status = '0' and ( (p.customers_group_id = '0' or p.customers_group_id = '' ) ) ORDER BY p.sort_order desc, pd.products_name LIMIT 0,24