SQL: SELECT SQL_CACHE SQL_CALC_FOUND_ROWS 
							product.id AS id,
							category_product.id_category AS id_category,
							COALESCE(product_lang.title, product_lang_alt.title) AS title, 
							COALESCE(product_lang.rewrite_title, product_lang_alt.rewrite_title) AS rewrite_title,
							COALESCE(product_lang.description, product_lang_alt.description) AS description,
							COALESCE(product_lang.short_description, product_lang_alt.short_description) AS short_description,
							product.user_code AS user_code,
							product.quantity AS quantity,
							COALESCE(price.value, price_alt.value) AS price,
							vat.rate AS vat,
							normal_price.value AS normal_price,
							normal_vat.rate AS normal_vat,
							image.url AS image,
							product.id AS order_by
						FROM product
						LEFT JOIN product_lang ON product_lang.id_product = product.id AND product_lang.id_lang = 1
						LEFT JOIN product_lang AS product_lang_alt ON product_lang.id_lang IS NULL AND product_lang_alt.id_product = product.id AND product_lang_alt.id_lang = 1  
						LEFT JOIN price ON price.id_product = product.id AND price.id_price_type = 1
						LEFT JOIN price AS price_alt ON price.id_product IS NULL AND price_alt.id_product = product.id AND price_alt.id_price_type = 1  
						INNER JOIN vat ON vat.id = COALESCE(price.id_vat, price_alt.id_vat)
						LEFT JOIN price AS normal_price ON normal_price.id_product = product.id AND normal_price.id_price_type = 2
						LEFT JOIN vat AS normal_vat ON normal_vat.id = normal_price.id_vat					
						LEFT JOIN image ON image.id_product = product.id AND image.head = 1
						INNER JOIN category_product ON category_product.id_product = product.id AND category_product.id_category IN (82,16,13,188,191,521,522,273,583,241,619,627,556,263,264,265,266,137,96,53,433,434,437,469,396,131,158,141,109,113,457,208,171,428,304,73,65,514,331,438,511,512,393,551,163,164,371,411,233,584,116,498,547,473,588,607,649,661,72,490,580,596,591,645,652,189,192,269,270,274,240,238,631,87,20,33,310,531,609,395,142,160,7,209,138,170,629,71,320,605,493,665,237,235,441,56,182,151,152,633,167,196,74,561,658,234,162,118,458,97,618,443,210,479,497,548,243,530,657,489,491,112,558,576,646,190,193,267,271,275,236,88,21,177,14,308,379,168,215,216,525,169,41,630,48,228,258,183,57,446,90,383,35,353,534,92,660,565,176,494,656,406,587,211,409,104,198,456,435,378,474,496,546,620,640,562,644,268,272,83,17,311,15,362,599,99,136,520,227,239,442,515,184,452,204,384,484,58,59,326,305,181,329,213,545,634,533,231,600,68,197,166,246,373,454,595,655,410,481,173,84,18,31,432,165,423,604,257,43,418,219,319,504,27,11,347,535,550,332,156,303,360,356,325,242,402,281,282,463,294,590,70,64,60,559,571,637,249,85,32,19,78,642,42,475,318,135,262,283,159,417,499,115,405,461,448,302,472,102,93,413,603,76,286,287,61,75,563,622,667,232,312,86,327,80,510,54,147,636,449,526,214,175,390,251,486,480,502,544,278,9,130,330,314,69,564,575,62,279,280,400,225,567,316,647,26,501,398,200,336,342,23,30,185,10,361,339,594,641,343,344,63,513,67,226,297,568,348,127,553,374,230,39,635,416,372,194,557,621,538,179,66,471,111,662,468,284,324,125,492,101,466,187,291,597,623,611,107,132,482,453,615,212,614,103,506,346,421,202,624,598,508,436,199,313,44,341,616,529,95,573,593,566,455,643,370,77,229,541,602,420,40,577,507,201,317,528,572,397,487,352,186,29,560,129,288,5,527,424,24,579,340,315,626,532,592,140,578,36,174,555,539,51,465,337,122,447,309,653,108,146,387,276,28,478,569,6,625,543,483,617,375,650,203,488,485,91,464,218,388,586,610,247,477,245,391,516,349,536,293,585,450,460,608,412,519,333,205,574,49,524,426,366,221,354,581,285,408,119,195,345,659,220,1,462,589,110,306,301,50,601,549,445,367,401,500,222,126,606,639,12,295,369,178,451,612,505,153,123,651,359,217,134,120,407,250,628,172,355,648,81,321,300,322,248,552,124,328,554,368,381,148,100,415,128,503,255,666,470,380,654,404,363,664,467,296,537,431,290,117,133,254,427,206,419,638,299,358,338,298,154,256,444,632,157,540,459,357,476,542,98,89,430,425,403,517,139,518,8,121,422,307,382,386,570,364,376,509,277,252,392,323,289,143)
						INNER JOIN preference ON preference.id_product = product.id AND preference.sale != 1
						WHERE 
							1=1 AND
							product.visible = 1 AND
							(1=1) AND
							(product.valid_until IS NULL OR product.valid_until > NOW())
						GROUP BY product.id
						 ORDER BY order_by DESC, RAND() LIMIT 0, 3