SELECT count(op.products_quantity) as ordered, 
                                  p.products_id,
                                  p.products_image,
                                  p.products_price,
                                  p.products_vpe,
                                  p.products_vpe_status,
                                  p.products_vpe_value,
                                  p.products_tax_class_id,
                                  pd.products_name 
                             FROM products p
                                   JOIN orders_products op
                     ON op.products_id = p.products_id 
                             JOIN products_description pd
                                  ON p.products_id = pd.products_id
                                     AND pd.language_id = '2'
                            WHERE p.products_status = 1
                              AND p.products_ordered > 0
                                   AND p.products_id IN ('51478', '50865', '50866', '1550', '417', '505', '535', '519', '49911', '51867', '51542', '49588', '49205', '51456', '49528', '50033', '50019', '50623', '49636', '51106', '589', '1097', '1136', '1203', '1520', '305', '50365', '49272', '185', '51052', '1153', '1347', '656', '856', '51871', '51361', '51858', '50904', '49065', '51432', '30', '50501', '1870', '791', '51228', '51932', '255', '306', '71', '737', '212', '49499', '1845', '49927', '308', '51853', '51371', '51120', '51143', '50954', '49309', '50151', '49943', '51918', '50690', '51930', '51227', '51903', '72', '49680', '50388', '50389', '679', '249', '50994', '25', '50993', '51914', '506', '578', '172', '1227', '673', '1253', '50039', '824', '739', '867', '773', '870', '866', '51841', '50795', '533', '256', '312', '323', '828', '50735', '49497', '51800', '1867', '321', '694', '49304', '49283', '50385', '50210', '51860', '50633', '48940', '51952', '1413', '1488', '51032', '52082', '50316', '51931', '49125', '51305', '1368', '49323', '1106', '49773', '49844', '51742', '750', '50639', '49012', '49013', '970', '1703', '1766', '50444', '50905', '814', '49160', '51464', '259', '49147', '51673', '60', '685', '49082', '684', '50178', '50114', '727', '252', '272', '51174', '51173', '49257', '170', '51418', '425', '426', '51153', '169', '49202', '51963', '189', '119', '514', '215', '50680', '51335', '836', '52', '1939', '50', '1825', '50669', '1906', '49789', '311', '62', '49809', '51798', '794', '297', '309') 
                                  
                         GROUP BY p.products_id
                         ORDER BY ordered DESC
                            LIMIT 12<div class="parseTime">Parse Time: 0.083s</div>