Tesco akciók

SELECT * FROM hvg_akciovadasz_products WHERE validityStart<='2025-04-29' AND validityEnd>='2025-04-29' AND ( categoryId='1' OR categoryId='2' OR categoryId='3' OR categoryId='4' OR categoryId='5' OR categoryId='6' OR categoryId='66' OR categoryId='67' OR categoryId='124' OR categoryId='176' OR categoryId='177' OR categoryId='247' OR categoryId='271' OR categoryId='273' OR categoryId='274' OR categoryId='275' OR categoryId='277' OR categoryId='20' OR categoryId='64' OR categoryId='65' OR categoryId='186' OR categoryId='246' OR categoryId='278' OR categoryId='279' OR categoryId='280' OR categoryId='11' OR categoryId='12' OR categoryId='13' OR categoryId='14' OR categoryId='129' OR categoryId='168' OR categoryId='281' OR categoryId='15' OR categoryId='16' OR categoryId='17' OR categoryId='18' OR categoryId='30' OR categoryId='31' OR categoryId='33' OR categoryId='60' OR categoryId='145' OR categoryId='166' OR categoryId='175' OR categoryId='243' OR categoryId='270' OR categoryId='35' OR categoryId='38' OR categoryId='39' OR categoryId='40' OR categoryId='62' OR categoryId='131' OR categoryId='167' OR categoryId='42' OR categoryId='44' OR categoryId='46' OR categoryId='140' OR categoryId='143' OR categoryId='144' OR categoryId='172' OR categoryId='220' OR categoryId='238' OR categoryId='43' OR categoryId='47' OR categoryId='48' OR categoryId='50' OR categoryId='69' OR categoryId='70' OR categoryId='71' OR categoryId='123' OR categoryId='128' OR categoryId='137' OR categoryId='138' OR categoryId='139' OR categoryId='142' OR categoryId='165' OR categoryId='173' OR categoryId='174' OR categoryId='233' OR categoryId='249' OR categoryId='251' OR categoryId='51' OR categoryId='57' OR categoryId='58' OR categoryId='132' OR categoryId='133' OR categoryId='158' OR categoryId='59' OR categoryId='253' OR categoryId='119' OR categoryId='159' OR categoryId='160' OR categoryId='187' OR categoryId='234' OR categoryId='252' OR categoryId='22' OR categoryId='23' OR categoryId='24' OR categoryId='146' OR categoryId='25' OR categoryId='32' OR categoryId='147' OR categoryId='171' OR categoryId='254' OR categoryId='170' OR categoryId='248' OR categoryId='255' OR categoryId='52' OR categoryId='53' OR categoryId='54' OR categoryId='55' OR categoryId='56' OR categoryId='61' OR categoryId='97' OR categoryId='98' OR categoryId='223' OR categoryId='224' OR categoryId='225' ) AND ( (originalPrice>price AND price!='0') OR ( originalPrice>loyaltyPrice AND loyaltyPrice!='0') ) AND chainId='1' ORDER BY orderPrice ASC