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 p.parent_id = 0 AND p.visible='y' AND p.id_category IN (SELECT id_category FROM categories WHERE parent='86' OR id_category='86') ORDER BY p.position ASC LIMIT 7044, 12
