SELECT p.id, p.line, p.code, p.powerkey, l.name_en AS LINE, c.id AS idcat, c.name_en AS CATEGORY, s.name_en AS SUBCATEGORY, s.order_subcat, t.name_en AS TYPE, rpl.name AS PRODNAME, rpl.preview AS PREVIEW, rpl.tech_spec AS TECH, rpl.features AS FEATURES, rpl.box_content AS CONTENT, rpl.active FROM v_products p INNER JOIN v_line l ON l.id = p.line INNER JOIN v_category c ON c.id = p.category INNER JOIN v_scategory s ON s.id = p.scategory INNER JOIN v_stype t ON t.id = p.stype INNER JOIN v_rel_prod_en rpl ON rpl.idProd = p.id INNER JOIN v_rel_prod_en act ON rpl.idProd = act.idProd WHERE act.active = 1 AND p.stype = 20 ORDER BY FIELD(p.id, '716','743','740','992','720','993','995','968','973','969','982','970','972','975','976','977','978','979','980','981','983','984','985','986','987','989','990'), LENGTH(p.code), p.code LIMIT 0,12