SELECT count(op.products_quantity) as ordered, 
                                  p.products_id,
                                  p.products_price,
                                  p.products_tax_class_id,
                                  p.products_image,
                                  p.products_vpe,
                                  p.products_vpe_status,
                                  p.products_vpe_value,
                                  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 trim(pd.products_name) != ''
                                     AND pd.language_id = '2'
                             JOIN products_to_categories p2c
                                  ON p.products_id = p2c.products_id
                                      AND p2c.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') 
                             JOIN categories c
                                  ON p2c.categories_id = c.categories_id
                                     AND c.categories_status = 1
                                     AND (c.categories_id = '359' 
                                          OR c.parent_id = '359')
                            WHERE p.products_status = 1
                              AND p.products_ordered > 0
                                  
                         GROUP BY p.products_id
                         ORDER BY ordered DESC
                            LIMIT 12