SELECT
cscart_images_links.*,
cscart_images.image_path,
cscart_common_descriptions.description AS alt,
cscart_images.image_x,
cscart_images.image_y,
cscart_images.image_id as images_image_id
FROM
cscart_images_links
LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id
LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id
AND cscart_common_descriptions.object_holder = 'images'
AND cscart_common_descriptions.lang_code = 'fr'
WHERE
cscart_images_links.object_type = 'variant_image'
AND cscart_images_links.type = 'V'
AND cscart_images_links.object_id IN (
20439,
20432,
20433,
20434,
20435,
20436,
20437,
20438,
20505,
20500,
20501,
20502,
20503,
20504,
18321,
18322,
18323,
18324,
18325,
18326,
18327,
18328,
18329,
18330,
18331,
18332,
18334,
18335,
18336,
18411,
18412,
18425,
18413,
18414,
18424,
18415,
18416,
18417,
18418,
18419,
18420,
18421,
18422,
18423,
19688,
19689,
19702,
19690,
19691,
19701,
19692,
19693,
19694,
19700,
19695,
19696,
19697,
19698,
19699,
19808,
19809,
19822,
19810,
19811,
19821,
19812,
19813,
19814,
19815,
19816,
19817,
19823,
19818,
19819,
19820,
19936,
19937,
19950,
19938,
19939,
19949,
19940,
19941,
19942,
19943,
19944,
19945,
19946,
19947,
22451,
22452,
22474,
22475,
23687,
24286,
24285,
24284,
24283,
24276,
24275,
24277,
24282,
24281,
24280,
24279,
24278,
24274,
24288,
24287,
20406,
20407,
20408,
20409,
20410,
20411,
20412,
20413,
20416,
20417,
20418,
20419,
20420,
20421,
20422,
20386,
20388,
20390,
20855,
20856,
20857,
20858,
20859,
20860,
20861,
20862,
20863,
20864,
20865,
20866,
20867,
20868,
20869,
20870,
20871,
20872,
20873,
20874,
20875,
20876,
20702,
20703,
20704,
20705,
20706,
20707,
20708,
20709,
20710,
20711,
20714,
20715,
20716,
20717,
20718,
20719,
20720,
20721,
20722,
20724,
20725,
20726,
20728,
20729,
20730,
20731,
20732,
20733,
20738,
20739,
20742,
20743,
20768,
20769,
20770,
20771,
20772,
20773,
20774,
20775,
20776,
20777,
20779,
20780,
20781,
20782,
20783,
20784,
20790,
20791,
20792,
20793,
20794,
20795,
20796,
20797,
20798,
20799,
20800,
20801,
20802,
20803,
20804,
20805,
20806,
20807,
20808,
20809,
20810,
20812,
20813,
20816,
20818,
20819,
20820,
20821,
20823,
20824,
20825,
20826,
20827,
20828,
20829,
20830,
20831,
20832,
20834,
20835,
20836,
20837,
20838,
20839,
20840,
20841,
20842,
20843,
20844,
20845,
20846,
20847,
20848,
20849,
20850,
20851,
20852,
20853,
20854,
20878,
20879,
20880,
20881,
20882,
20883,
20884,
20885,
20886,
20887,
20889,
20890,
20891,
20892,
20893,
20894,
21406,
21407,
21409,
21410,
21411,
21412,
21413,
21414,
21415,
21418,
21419,
21421,
21422,
21473,
21474,
21476,
21477,
21478,
21479,
21480,
21481,
21482,
21485,
21486,
21488,
21489,
21495,
21496,
21498,
21499,
21500,
21501,
21502,
21503,
21504,
21507,
21508,
21510,
21511,
22811,
22812,
22814,
22815,
22816,
22817,
22818,
22819,
22820,
22823,
22824,
22826,
22827,
21077,
21078,
21080,
21081,
21082,
21083,
21084,
21085,
21087,
21088,
21089,
21090,
21091,
21092,
23847,
21094,
21095,
21099,
21100,
21102,
21103,
21104,
21105,
21106,
21107,
21109,
21110,
21111,
21112,
21113,
21114,
21115,
21116,
21117,
21121,
21122,
21124,
21125,
21126,
21127,
21128,
21129,
21131,
21132,
21133,
21134,
21135,
21136,
21137,
21138,
21139,
23849,
23853,
23854,
23855,
23883,
23884,
23859,
20530,
20620,
19576,
19578,
19579,
19580,
19581,
19582,
19577,
19600,
19602,
19603,
19604,
19605,
19606,
19601,
19612,
19614,
19615,
19616,
19617,
19618,
19613,
19636,
19638,
19639,
19640,
19641,
19642,
19637,
23828,
21432,
23829,
21434,
21435,
21436,
21437,
21441,
23830,
22837,
23831,
22839,
22840,
22841,
22842,
22846,
21388,
21390,
21391,
21392,
21393,
21397,
22459,
22460,
22462,
22463,
22465,
22466,
22467,
22469,
22470,
22471,
22472,
22473,
22930,
22926,
23994,
22920,
22933,
22932,
22931,
22929,
22928,
23995,
22924,
22923,
23996,
22922,
22921,
22966,
22962,
23973,
22956,
22969,
22968,
22967,
22965,
22964,
22963,
23974,
22960,
22959,
23975,
22958,
22957,
23673,
23674,
23675,
23676,
23677,
23678,
23679,
23680,
23681,
23682,
23683,
23684,
23928,
23929,
23930,
23931,
23932,
23933,
23934,
23935,
23937,
23938,
23939,
23940,
20476,
20477,
20478,
20479,
20480,
20481,
20482,
20483,
20484,
20485,
20487,
20488,
20489,
20490,
20491,
20492,
20493,
20494,
20495,
20496,
20497,
20506,
20507,
20508,
20509,
20510,
20511,
20512,
20513,
20514,
20515,
20516,
20517,
20518,
20519,
20520,
20521,
20522,
20523,
20524,
20525,
20526,
20527,
20536,
20537,
20538,
20539,
20540,
20541,
20542,
20543,
20544,
20545,
20546,
20547,
20548,
20549,
20550,
20551,
20552,
20553,
20554,
20555,
20556,
20557,
20566,
20567,
20568,
20569,
20570,
20571,
20572,
20573,
20574,
20576,
20577,
20578,
20579,
20581,
20582,
20583,
20584,
20585,
20586,
20587,
20596,
20597,
20598,
20599,
20600,
20601,
20602,
20603,
20604,
20605,
20606,
20607,
20608,
20609,
20610,
20611,
20612,
20613,
20614,
20615,
20616,
20617,
20626,
20627,
20628,
20629,
20630,
20631,
20632,
20633,
20634,
20635,
20636,
20637,
20638,
20639,
20640,
20641,
20642,
20643,
20644,
20645,
20646,
20647,
22442,
22443,
22444
)
ORDER BY
cscart_images_links.position,
cscart_images_links.pair_id