SQL_CALC_FOUND_ROWS IF(pl.name <> '', pl.name, plt.name) AS pname, IF(pl.name2 <> '', pl.name2, plt.name2) AS pname2, IFNULL(`pl`.`shortdesc`, `plt`.`shortdesc`) AS `shortdesc`, m.name AS manuname, `m`.`idm` AS `idm`, `v`.`code`, `v`.`code2`, `v`.`ean`, `v`.`status`, `pl2`.`idpl` AS `idpl`, `pl2`.`price` AS `price`, IF ( (`pl2`.`price` - `pl2`.`oldprice`) > 0, 0, 1) AS `discount`, `pl2`.`oldprice`, `pl2`.`discountpct`, `pl2`.`obratkovostpct`, `pl2`.`changetime`, `pl2`.`minprice30`, `pl2`.`additionalprice`, v.idp, price_level.vat AS vat, pt.type, pt.upscode, pt.dodani, pt.descformat, pt.idt AS idt, p.idau AS idau, author.name AS authorname, author.url AS authorurl, author.paper AS authorpaper, author.mincommissioneur, p.material AS material, p.marketplace AS marketplace, p.explicit AS explicit, p.idg as idg, p.hasvratka, p.b2b, v.idv AS idv, s2pv.`forsale`, s2pv.`ids`, ( SUM(s2pv.`forsale`) - SUM(ABS(s2pv.`reserved`)) - SUM(s2pv.`notforsale`) ) AS total4sale FROM product p JOIN product_type pt on (pt.idt = p.idt) JOIN product_variant v on (v.idp = p.idp) LEFT JOIN author on (author.idau = p.idau) JOIN manufacturer m ON ( m.idm = p.idm ) LEFT JOIN product2language pl ON ( v.idp = pl.idp ) AND (pl.idl = 'it') LEFT JOIN product2language plt ON ( v.idp = plt.idp ) AND (plt.idl = 'en') LEFT JOIN price_level2product_variant pl2 ON ( v.idv = pl2.idv ) AND (pl2.idpl = 25) LEFT JOIN price_level ON ( price_level.idpl = pl2.idpl) LEFT JOIN store2product_variant s2pv ON (s2pv.idv=v.idv) WHERE v.idv IN (164175, 193309, 193377, 119021, 81283, 74984, 137408, 157828, 137505, 106291, 137396, 138163, 138124, 157900, 157821, 159735, 182946, 179325, 86486, 173069, 101914, 157141, 45784, 72587, 86327, 74606, 74605, 77283, 57513, 135382, 109883, 178224, 182959, 182957, 119021, 210363, 82321, 99331, 98822, 96433, 96432, 96431, 96424, 96143, 94461, 132172, 109432, 156506, 143253, 121623, 81283, 90742, 73591, 67630, 48707, 47370, 137402, 137336, 138083, 110308, 139430, 157929, 182956, 170786, 72999, 74984, 137408, 84272, 82277, 96426, 96425, 114533, 132217, 113651, 108844, 166025, 188342, 182738, 182197, 182196, 182195, 182194, 176070, 173036, 156502, 134722, 133639, 133484, 133473, 133472, 133470, 133469, 142713, 136382, 144381, 143617, 194232, 157828, 88506, 183882, 76396, 73194, 63017, 61555, 138223, 149701, 148540, 157810, 157806, 172525, 182955, 189020, 114444, 149256, 97904, 157911, 91759, 120526, 175419, 91746, 55245, 62657, 137423, 138104, 99713, 138565, 140335, 140328, 152797, 142936, 140777, 163561, 163554, 163534, 153401, 153306, 153303, 158518, 157909, 157893, 157866, 157864, 157822, 154408, 178532, 177024, 173201, 184916, 184912, 183703, 179325, 137396, 157821, 138163, 138124, 216680, 206767, 209869, 209863, 209808, 209727, 209689, 209688, 209661, 209603, 159735, 157900, 89934, 89933, 88564, 91793, 132795, 110708, 110705, 126214, 87571, 124393, 171164, 170684, 156614, 133688, 133480, 133479, 133477, 142825, 142143, 143752, 194224, 72587, 138222, 154178, 127585, 91745, 138097, 139448, 140297, 140024, 139731, 149750, 149749, 148728, 157924, 157914, 157892, 157827, 157823, 157820, 157811, 157807, 182923, 91735, 57513, 109883, 86486, 86327, 45784, 77283, 74606, 74605, 135382, 216728, 209705, 209634, 209596, 173069, 182957, 182946, 103235, 96731, 118292, 117617, 116845, 110703, 189106, 135290, 142126, 140961, 140956, 143957, 143759, 143252, 132620, 91758, 137417, 138149, 118367, 152891, 153297, 157898, 157851, 157813, 157808, 154776, 178461, 137505, 67628, 157824, 157862, 157901, 183882, 67630, 90742, 110308, 48707, 47370, 137402, 137336, 139430, 138083, 209696, 157929, 182959, 182956, 178224, 86765, 96729, 96687, 119776, 117578, 124489, 163678, 161034, 156623, 149262, 73893, 140780, 147688, 147653, 153228, 158135, 158122, 157916, 157910, 157891, 157861, 157809, 182951, 157904, 157810, 91970, 137399, 157814, 157911, 61555, 63017, 67628, 52563, 76396, 73591, 73194, 72999, 149701, 148540, 157806, 138565, 138223, 208986, 172525, 163561, 183703, 105419, 90849, 122907, 122906, 122313, 132463, 111601, 129951, 109496, 189767, 178410, 172727, 168755, 162101, 148518, 154408, 97900, 139730, 91758, 55245, 62657, 114444, 99713, 91746, 209429, 88506, 140777, 140335, 140328, 140024, 139731, 137423, 153401, 157866, 157864, 157822, 77187, 208919, 153306, 153303, 152797, 173201, 163554) AND (v.`status` = 1 OR v.`status` = 2) GROUP BY v.idp ORDER BY FIELD(`v`.`idv`, 164175, 193309, 193377, 119021, 81283, 74984, 137408, 157828, 137505, 106291, 137396, 138163, 138124, 157900, 157821, 159735, 182946, 179325, 86486, 173069, 101914, 157141, 45784, 72587, 86327, 74606, 74605, 77283, 57513, 135382, 109883, 178224, 182959, 182957, 119021, 210363, 82321, 99331, 98822, 96433, 96432, 96431, 96424, 96143, 94461, 132172, 109432, 156506, 143253, 121623, 81283, 90742, 73591, 67630, 48707, 47370, 137402, 137336, 138083, 110308, 139430, 157929, 182956, 170786, 72999, 74984, 137408, 84272, 82277, 96426, 96425, 114533, 132217, 113651, 108844, 166025, 188342, 182738, 182197, 182196, 182195, 182194, 176070, 173036, 156502, 134722, 133639, 133484, 133473, 133472, 133470, 133469, 142713, 136382, 144381, 143617, 194232, 157828, 88506, 183882, 76396, 73194, 63017, 61555, 138223, 149701, 148540, 157810, 157806, 172525, 182955, 189020, 114444, 149256, 97904, 157911, 91759, 120526, 175419, 91746, 55245, 62657, 137423, 138104, 99713, 138565, 140335, 140328, 152797, 142936, 140777, 163561, 163554, 163534, 153401, 153306, 153303, 158518, 157909, 157893, 157866, 157864, 157822, 154408, 178532, 177024, 173201, 184916, 184912, 183703, 179325, 137396, 157821, 138163, 138124, 216680, 206767, 209869, 209863, 209808, 209727, 209689, 209688, 209661, 209603, 159735, 157900, 89934, 89933, 88564, 91793, 132795, 110708, 110705, 126214, 87571, 124393, 171164, 170684, 156614, 133688, 133480, 133479, 133477, 142825, 142143, 143752, 194224, 72587, 138222, 154178, 127585, 91745, 138097, 139448, 140297, 140024, 139731, 149750, 149749, 148728, 157924, 157914, 157892, 157827, 157823, 157820, 157811, 157807, 182923, 91735, 57513, 109883, 86486, 86327, 45784, 77283, 74606, 74605, 135382, 216728, 209705, 209634, 209596, 173069, 182957, 182946, 103235, 96731, 118292, 117617, 116845, 110703, 189106, 135290, 142126, 140961, 140956, 143957, 143759, 143252, 132620, 91758, 137417, 138149, 118367, 152891, 153297, 157898, 157851, 157813, 157808, 154776, 178461, 137505, 67628, 157824, 157862, 157901, 183882, 67630, 90742, 110308, 48707, 47370, 137402, 137336, 139430, 138083, 209696, 157929, 182959, 182956, 178224, 86765, 96729, 96687, 119776, 117578, 124489, 163678, 161034, 156623, 149262, 73893, 140780, 147688, 147653, 153228, 158135, 158122, 157916, 157910, 157891, 157861, 157809, 182951, 157904, 157810, 91970, 137399, 157814, 157911, 61555, 63017, 67628, 52563, 76396, 73591, 73194, 72999, 149701, 148540, 157806, 138565, 138223, 208986, 172525, 163561, 183703, 105419, 90849, 122907, 122906, 122313, 132463, 111601, 129951, 109496, 189767, 178410, 172727, 168755, 162101, 148518, 154408, 97900, 139730, 91758, 55245, 62657, 114444, 99713, 91746, 209429, 88506, 140777, 140335, 140328, 140024, 139731, 137423, 153401, 157866, 157864, 157822, 77187, 208919, 153306, 153303, 152797, 173201, 163554)