(549)
SELECT id_product, p.id_category, name_ro, url_product_ro, name_hu, url_product_hu, name_en, url_product_en, price, price_promo, desc_ro, desc_hu, desc_en, stock, url_category_ro, url_category_hu, url_category_en, new, rendelesre
FROM products p JOIN categories c
ON p.id_category = c.id_category AND parent_id = 0 AND visible="y" ORDER BY p.position ASC LIMIT 7932, 12