Barbati

select sql_calc_found_rows p.`id`, p.`id_brand`,pd.`code`,p.`is_best`,p.`price_promo`,p.`price`,p.`is_seller`,p.`is_seller`,p.`is_new`,p.`is_delivery`,p.`romanesc`, if((select COUNT(id) from xp_products_variations where id_product=p.id and stock>0)>0,(select COUNT(id) from xp_products_variations where id_product=p.id and stock>0),p.stock) as stock, pd.`name`, pd.`name_seo`,pd.`code`,p.min_quantity,pd.`short_description`,p.colectie,p.`price_bg`,p.`price_hu`,p.`price_el`, c.`id_parent`, cd.`name_seo` category, pc.`id_category` from `xp_products` p inner join `xp_products_data` pd on p.`id`=pd.`id_product` inner join `xp_products_to_categories` pc on p.`id`=pc.`id_product` left join `xp_brands` b on b.`id`=p.`id_brand` inner join `xp_categories` c on c.`id`=pc.`id_category` inner join `xp_currencies` currency on p.`id_currency`=currency.`id` inner join `xp_categories_data` cd on c.`id`=cd.`_id` where p.`status`=1 and pd.`lang`=? and cd.`lang`=? and c.`status`=1 and pc.`id_category` in (2,13,15,17,19,21) and p.`id` in (0,1806,1805,1804,1804,1804,1803,1802,1802,1802,3163,1242,1242,1242,1242,253,253,253,253,253,245,245,245,245,245,245,246,246,246,246,246,246,3158,3158,3158,3158,3158,1730,1730,1730,1730,1730,243,243,243,243,243,3160,3160,3160,3160,1840,1840,1840,1840,1741,1741,1741,1741,1699,1699,1699,1699,1567,1567,1567,1567,244,244,244,244,3161,3161,3161,1832,1832,1832,1743,1743,1743,1742,1742,1742,1742,1737,1737,1737,1735,1735,1735,1733,1733,1733,1733,1697,1697,1697,1697,3162,3162,3159,3159,1836,1836,1738,1738,1738,1729,1729,1729,229,229,229,233,233,233,1837,1837,1831,1831,1830,1830,1828,1828,1740,1740,1731,1731,1698,1698,1694,1694,1568,1568,228,231,231,234,234,238,238,3166,3164,1834,1732,236,237,4223,4019,3871,1301,1301,1301,1301,1301,1301,1302,1302,1302,1302,1302,1300,1300,1300,1300,1300,3591,3591,3591,3591,3591,3584,3584,3584,3584,3576,3576,3576,3576,3576,2617,2617,2617,2617,2617,2613,2613,2613,2613,2613,2610,2610,2610,2610,2610,2601,2601,2601,2601,2601,2595,2595,2595,2595,2595,2587,2587,2587,2587,2587,2582,2582,2582,2582,2582,2578,2578,2578,2578,2578,1566,1566,1566,1566,1566,1520,1520,1520,1520,1520,1512,1512,1512,1512,1512,3580,3580,3580,3580,3578,3578,3578,3578,3573,3573,3573,3573,3397,3397,3397,3397,2606,2606,2606,2606,2580,2580,2580,2580,1119,1119,1119,1119,3412,3412,3412,3411,3411,3411,3376,3376,3376,2579,2579,2579,2575,2575,2575,2575,2573,2573,2573,2573,252,252,252,252,3589,3589,3589,3410,3410,3375,3375,3374,3374,2640,2640,2589,2589,1569,1569,1569,3598,3598,3588,3588,3441,3441,3439,3378,3378,3377,3377,2634,2634,2634,2615,2615,2611,2611,2609,2609,2609,2608,2608,3917,3885,3880,3873,3872,3442,3398,3396,3395,3384,2660,2638,2637,2635,1771,1665,1664,1522,1511,1362,1244,2583,2583,2898,4377,4377,4377,4377,4377,4376,4376,4376,4376,4375,4375,4375,4375,4375,4374,4374,4374,4374,4374,4373,4373,4373,4373,4373,4372,4371,4371,4371,4370,4370,4369,4369,4369,4368,4368,4368,4174,4174,4174,4174,4070,4069,4065,4064,4060,4059,4058,4173,4173,4173,4173,4071,4071,4068,4016,3585,3585,3585,3585,3444,2584,2584,2584,2584,2581,2574,2574,2574,2574,2574,3369,3408,3385,3403,3445,2621,2623,2508,630,4363,4363,4363,4361,4361,4361,4360,4360,4172,4172,4172,4172,4172,4367,4367,4366,4366,4365,4364,4364,4364,4364,4364,632,3333,3335,3335,3335,3335,3335,3336,3337,3331,3331,3331,3331,3368,3371,3371,3371,3372,3329,3380,3404,3406,3399,2123,2123,2123,2171,2501,2501,2505,2505,1118,1118,1118,1118,1118,3383,3383,3383,3394,3394,3407,3407,3407,3409,2507,2507,1120,1120,1120,1120,1120,3330,3330,3387,3388,3388,3382,3382,3326,3326,3326,3326,3328,3328,3328,3389,3389,3390,3390,3327,3327,3327,3327,3327,3381,3381,3391,3392,3392,3392,3392,3393,628,4106,2121,2121,2121,2121,2121,2121,4105,4105,4105,4105,4105,2122,2122,2122,2122,2122,3332,3332,3332,3332,3332,1669,1668,636,636,2633,2633,2633,250,250,250,250,250,251,251,251,251,251,247,247,247,247,247,248,248,248,248,248,248,249,249,249,249,249,249,249) group by p.id order by p.views desc, (stock > 0) desc, p.views desc limit 0, 50