exhibitionPeriod
string(7) "Current"
searchCritea
array(1) {
[0]=>
array(3) {
["libele"]=>
string(10) "Nouveautés"
["data"]=>
string(10) "Nouveautés"
["field"]=>
string(11) "new_artwork"
}
}
Artwork_search
string(2225) " AND ( ( tbl_artwork.custom_field_8 <= DATE(NOW()) AND tbl_artwork.custom_field_8 !='0000-00-00' ) AND (tbl_artwork.custom_field_9 >= DATE(NOW()) OR tbl_artwork.custom_field_9 ='0000-00-00' )) AND tbl_artwork.type !='artwork' AND tbl_artwork.id NOT IN (43338,43339,47290,47291,47295,47296,47299,51086,51087,51091,51813,51814,51815,51816,51817,51818,51819,51820,51874,51875,51876,51877,51878,51879,51880,51881,51882,51883,51884,51885,51886,51887,51888,51889,51890,51891,51892,51893,51894,51895,51896,51897,51898,51899,51900,51901,51902,51903,51904,51905,51906,51907,51908,51915,51916,51917,51918,51919,51920,51921,51922,51923,51924,51925,51926,51927,51928,51929,51930,51931,51932,51933,51934,51936,51937,51938,51939,51940,51941,51942,51943,51964,52317,52329,52330,52331,52332,52333,52334,52335,52336,52337,52338,52339,52340,52341,52342,52343,52344,52345,52346,52347,52348,52349,52350,52351,52352,52353,52354,52355,52357,52358,52360,52361,52362,52363,52364,52365,52366,52367,52368,52369,52370,52371,52372,52373,52374,52375,52376,52377,52378,52379,52380,52381,52382,52383,52384,52385,52386,52399,52401,52402,52403,52404,52405,52406,52407,52408,52409,52410,52435,52436,52437,52438,52439,52440,52441,52442,52443,52444,52445,52446,52447,52448,52449,52450,52451,52452,52453,52454,52455,52456,52457,52458,52464,52465,52467,52468,52489,52490,52491,52492,52493,52494,52495,52496,52497,52498,52499,52500,52501,52502,52503,52510,52511,52512,52513,52514,52515,52516,52517,52518,52519,52520,52521,52522,52523,52524,52525,52526,52527,52528,52529,52530,52531,52532,52533,52534,52535,52536,52537,52538,52539,52540,52541,52542,52547,52548,52549,52550,52551,52552,52553,52554,52555,52556,52557,52558,52559,52560,52561,52562,52563,52564,52565,52567,52568,52569,52570,52571,52572,52573,52574,52575,52576,52577,52578,52579,52580,52581,52582,52583,52584,52585,52586,52588,52589,52590,52591,52592,52593,52594,52595,52596,52597,52598,52600,52601,52602,52603,52604,52614,52615,52617,52618,52619,52620,52621,52622,52623,52624,52625,52626,52627,52629,52631,52632,52633,52634,52635,52636,52638,52641,52642,52643,52644,52645,52646,52647,52648,52649,52650,52651,52652,52653,52654,52658,52659,52660,52664,52665,52671,52672,52673,52676,52678,52695,52697) "
Artwork_sort
string(42) " ORDER BY tbl_artwork.custom_field_8 DESC "
sql_swipe
string(2652) "SELECT DISTINCT tbl_artwork.id,tbl_artwork.id_artist,tbl_artwork.medium FROM tbl_artwork
LEFT JOIN tbl_contact AS artist ON (tbl_artwork.id_artist = artist.id)
LEFT JOIN tbl_artwork_multiple ON tbl_artwork_multiple.id_artwork=tbl_artwork.id AND tbl_artwork_multiple.premiere_dispo = 1
WHERE tbl_artwork.stock='on' AND ( ( tbl_artwork.custom_field_8 <= DATE(NOW()) AND tbl_artwork.custom_field_8 !='0000-00-00' ) AND (tbl_artwork.custom_field_9 >= DATE(NOW()) OR tbl_artwork.custom_field_9 ='0000-00-00' )) AND tbl_artwork.type !='artwork' AND tbl_artwork.id NOT IN (43338,43339,47290,47291,47295,47296,47299,51086,51087,51091,51813,51814,51815,51816,51817,51818,51819,51820,51874,51875,51876,51877,51878,51879,51880,51881,51882,51883,51884,51885,51886,51887,51888,51889,51890,51891,51892,51893,51894,51895,51896,51897,51898,51899,51900,51901,51902,51903,51904,51905,51906,51907,51908,51915,51916,51917,51918,51919,51920,51921,51922,51923,51924,51925,51926,51927,51928,51929,51930,51931,51932,51933,51934,51936,51937,51938,51939,51940,51941,51942,51943,51964,52317,52329,52330,52331,52332,52333,52334,52335,52336,52337,52338,52339,52340,52341,52342,52343,52344,52345,52346,52347,52348,52349,52350,52351,52352,52353,52354,52355,52357,52358,52360,52361,52362,52363,52364,52365,52366,52367,52368,52369,52370,52371,52372,52373,52374,52375,52376,52377,52378,52379,52380,52381,52382,52383,52384,52385,52386,52399,52401,52402,52403,52404,52405,52406,52407,52408,52409,52410,52435,52436,52437,52438,52439,52440,52441,52442,52443,52444,52445,52446,52447,52448,52449,52450,52451,52452,52453,52454,52455,52456,52457,52458,52464,52465,52467,52468,52489,52490,52491,52492,52493,52494,52495,52496,52497,52498,52499,52500,52501,52502,52503,52510,52511,52512,52513,52514,52515,52516,52517,52518,52519,52520,52521,52522,52523,52524,52525,52526,52527,52528,52529,52530,52531,52532,52533,52534,52535,52536,52537,52538,52539,52540,52541,52542,52547,52548,52549,52550,52551,52552,52553,52554,52555,52556,52557,52558,52559,52560,52561,52562,52563,52564,52565,52567,52568,52569,52570,52571,52572,52573,52574,52575,52576,52577,52578,52579,52580,52581,52582,52583,52584,52585,52586,52588,52589,52590,52591,52592,52593,52594,52595,52596,52597,52598,52600,52601,52602,52603,52604,52614,52615,52617,52618,52619,52620,52621,52622,52623,52624,52625,52626,52627,52629,52631,52632,52633,52634,52635,52636,52638,52641,52642,52643,52644,52645,52646,52647,52648,52649,52650,52651,52652,52653,52654,52658,52659,52660,52664,52665,52671,52672,52673,52676,52678,52695,52697) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY tbl_artwork.custom_field_8 DESC "
TOTAL ITEM SQL
NULL
TOTAL ITEM
int(305)
TOTAL PAGES
float(20)
sql
string(2647) "
SELECT DISTINCT
tbl_artwork.id
FROM tbl_artwork
LEFT JOIN tbl_contact AS artist ON (tbl_artwork.id_artist = artist.id)
LEFT JOIN tbl_artwork_multiple ON tbl_artwork_multiple.id_artwork=tbl_artwork.id AND tbl_artwork_multiple.premiere_dispo = 1
WHERE tbl_artwork.stock='on' AND ( ( tbl_artwork.custom_field_8 <= DATE(NOW()) AND tbl_artwork.custom_field_8 !='0000-00-00' ) AND (tbl_artwork.custom_field_9 >= DATE(NOW()) OR tbl_artwork.custom_field_9 ='0000-00-00' )) AND tbl_artwork.type !='artwork' AND tbl_artwork.id NOT IN (43338,43339,47290,47291,47295,47296,47299,51086,51087,51091,51813,51814,51815,51816,51817,51818,51819,51820,51874,51875,51876,51877,51878,51879,51880,51881,51882,51883,51884,51885,51886,51887,51888,51889,51890,51891,51892,51893,51894,51895,51896,51897,51898,51899,51900,51901,51902,51903,51904,51905,51906,51907,51908,51915,51916,51917,51918,51919,51920,51921,51922,51923,51924,51925,51926,51927,51928,51929,51930,51931,51932,51933,51934,51936,51937,51938,51939,51940,51941,51942,51943,51964,52317,52329,52330,52331,52332,52333,52334,52335,52336,52337,52338,52339,52340,52341,52342,52343,52344,52345,52346,52347,52348,52349,52350,52351,52352,52353,52354,52355,52357,52358,52360,52361,52362,52363,52364,52365,52366,52367,52368,52369,52370,52371,52372,52373,52374,52375,52376,52377,52378,52379,52380,52381,52382,52383,52384,52385,52386,52399,52401,52402,52403,52404,52405,52406,52407,52408,52409,52410,52435,52436,52437,52438,52439,52440,52441,52442,52443,52444,52445,52446,52447,52448,52449,52450,52451,52452,52453,52454,52455,52456,52457,52458,52464,52465,52467,52468,52489,52490,52491,52492,52493,52494,52495,52496,52497,52498,52499,52500,52501,52502,52503,52510,52511,52512,52513,52514,52515,52516,52517,52518,52519,52520,52521,52522,52523,52524,52525,52526,52527,52528,52529,52530,52531,52532,52533,52534,52535,52536,52537,52538,52539,52540,52541,52542,52547,52548,52549,52550,52551,52552,52553,52554,52555,52556,52557,52558,52559,52560,52561,52562,52563,52564,52565,52567,52568,52569,52570,52571,52572,52573,52574,52575,52576,52577,52578,52579,52580,52581,52582,52583,52584,52585,52586,52588,52589,52590,52591,52592,52593,52594,52595,52596,52597,52598,52600,52601,52602,52603,52604,52614,52615,52617,52618,52619,52620,52621,52622,52623,52624,52625,52626,52627,52629,52631,52632,52633,52634,52635,52636,52638,52641,52642,52643,52644,52645,52646,52647,52648,52649,52650,52651,52652,52653,52654,52658,52659,52660,52664,52665,52671,52672,52673,52676,52678,52695,52697) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY tbl_artwork.custom_field_8 DESC
LIMIT 288, 16"
POST
NULL
GET
array(8) {
["lang"]=>
string(2) "fr"
["page"]=>
string(5) "store"
["view"]=>
string(8) "editions"
["id"]=>
int(0)
["name"]=>
string(20) "huberty-breyne-store"
["?paged"]=>
string(0) ""
["paged"]=>
string(2) "19"
["sort"]=>
string(8) "new_DESC"
}
exhib_search
string(0) ""
openFilter
bool(true)
artwork_ids
array(305) {
[0]=>
string(5) "52667"
[1]=>
string(5) "52668"
[2]=>
string(5) "52669"
[3]=>
string(5) "52670"
[4]=>
string(5) "46343"
[5]=>
string(5) "48491"
[6]=>
string(5) "48492"
[7]=>
string(5) "43052"
[8]=>
string(5) "50181"
[9]=>
string(5) "51825"
[10]=>
string(5) "51873"
[11]=>
string(5) "51822"
[12]=>
string(5) "51823"
[13]=>
string(5) "51824"
[14]=>
string(5) "51062"
[15]=>
string(5) "51075"
[16]=>
string(5) "44712"
[17]=>
string(5) "44715"
[18]=>
string(5) "44716"
[19]=>
string(5) "49764"
[20]=>
string(5) "44366"
[21]=>
string(5) "44453"
[22]=>
string(5) "44704"
[23]=>
string(5) "46389"
[24]=>
string(5) "46388"
[25]=>
string(5) "50880"
[26]=>
string(5) "50882"
[27]=>
string(5) "51475"
[28]=>
string(5) "51476"
[29]=>
string(5) "17497"
[30]=>
string(5) "23756"
[31]=>
string(5) "44711"
[32]=>
string(5) "44713"
[33]=>
string(5) "44706"
[34]=>
string(5) "44707"
[35]=>
string(5) "44710"
[36]=>
string(5) "48546"
[37]=>
string(5) "48678"
[38]=>
string(5) "48687"
[39]=>
string(5) "48229"
[40]=>
string(5) "44795"
[41]=>
string(5) "12472"
[42]=>
string(5) "12201"
[43]=>
string(5) "12208"
[44]=>
string(5) "46410"
[45]=>
string(5) "46409"
[46]=>
string(5) "46408"
[47]=>
string(5) "46403"
[48]=>
string(5) "46402"
[49]=>
string(5) "46401"
[50]=>
string(5) "40716"
[51]=>
string(5) "40717"
[52]=>
string(5) "40720"
[53]=>
string(5) "40725"
[54]=>
string(5) "40726"
[55]=>
string(5) "32547"
[56]=>
string(5) "32553"
[57]=>
string(5) "32555"
[58]=>
string(5) "40727"
[59]=>
string(5) "40147"
[60]=>
string(5) "36044"
[61]=>
string(5) "40273"
[62]=>
string(5) "40276"
[63]=>
string(5) "40277"
[64]=>
string(5) "40278"
[65]=>
string(5) "40279"
[66]=>
string(5) "40280"
[67]=>
string(5) "40281"
[68]=>
string(5) "40282"
[69]=>
string(5) "40283"
[70]=>
string(5) "40285"
[71]=>
string(5) "40284"
[72]=>
string(5) "26040"
[73]=>
string(5) "26041"
[74]=>
string(5) "26042"
[75]=>
string(5) "26039"
[76]=>
string(5) "40053"
[77]=>
string(5) "40055"
[78]=>
string(5) "40051"
[79]=>
string(5) "25743"
[80]=>
string(5) "25977"
[81]=>
string(5) "18787"
[82]=>
string(5) "25713"
[83]=>
string(5) "25741"
[84]=>
string(5) "39991"
[85]=>
string(5) "39992"
[86]=>
string(5) "39790"
[87]=>
string(5) "39791"
[88]=>
string(5) "39792"
[89]=>
string(5) "39923"
[90]=>
string(5) "39948"
[91]=>
string(5) "30325"
[92]=>
string(5) "33373"
[93]=>
string(5) "39110"
[94]=>
string(5) "39108"
[95]=>
string(5) "39103"
[96]=>
string(5) "39115"
[97]=>
string(5) "39109"
[98]=>
string(5) "39114"
[99]=>
string(5) "39112"
[100]=>
string(5) "39111"
[101]=>
string(5) "39106"
[102]=>
string(5) "39104"
[103]=>
string(5) "39113"
[104]=>
string(5) "39116"
[105]=>
string(5) "39975"
[106]=>
string(5) "39027"
[107]=>
string(5) "39024"
[108]=>
string(5) "39053"
[109]=>
string(5) "39054"
[110]=>
string(5) "39055"
[111]=>
string(5) "39030"
[112]=>
string(5) "39089"
[113]=>
string(5) "39090"
[114]=>
string(5) "39091"
[115]=>
string(5) "38707"
[116]=>
string(5) "38709"
[117]=>
string(5) "38711"
[118]=>
string(5) "39119"
[119]=>
string(5) "38489"
[120]=>
string(5) "38492"
[121]=>
string(5) "38484"
[122]=>
string(5) "38488"
[123]=>
string(5) "38019"
[124]=>
string(5) "38021"
[125]=>
string(5) "38023"
[126]=>
string(5) "38015"
[127]=>
string(5) "38018"
[128]=>
string(5) "38089"
[129]=>
string(5) "12306"
[130]=>
string(5) "25732"
[131]=>
string(5) "37534"
[132]=>
string(5) "37536"
[133]=>
string(5) "20704"
[134]=>
string(5) "36350"
[135]=>
string(5) "36354"
[136]=>
string(5) "36581"
[137]=>
string(5) "36482"
[138]=>
string(5) "36544"
[139]=>
string(5) "36553"
[140]=>
string(5) "12188"
[141]=>
string(5) "35896"
[142]=>
string(5) "13250"
[143]=>
string(5) "35742"
[144]=>
string(5) "35745"
[145]=>
string(5) "35571"
[146]=>
string(5) "12199"
[147]=>
string(5) "12175"
[148]=>
string(5) "12183"
[149]=>
string(5) "35568"
[150]=>
string(5) "35570"
[151]=>
string(5) "25747"
[152]=>
string(5) "34431"
[153]=>
string(5) "40381"
[154]=>
string(5) "34115"
[155]=>
string(5) "25550"
[156]=>
string(5) "17475"
[157]=>
string(5) "32838"
[158]=>
string(5) "32837"
[159]=>
string(5) "32856"
[160]=>
string(5) "32857"
[161]=>
string(5) "32858"
[162]=>
string(5) "32859"
[163]=>
string(5) "32860"
[164]=>
string(5) "32861"
[165]=>
string(5) "32829"
[166]=>
string(5) "32845"
[167]=>
string(5) "32840"
[168]=>
string(5) "32281"
[169]=>
string(5) "32314"
[170]=>
string(5) "31833"
[171]=>
string(5) "31852"
[172]=>
string(5) "31853"
[173]=>
string(5) "31827"
[174]=>
string(5) "31829"
[175]=>
string(5) "31830"
[176]=>
string(5) "31831"
[177]=>
string(5) "31832"
[178]=>
string(5) "28032"
[179]=>
string(5) "28033"
[180]=>
string(5) "28034"
[181]=>
string(5) "28035"
[182]=>
string(5) "28012"
[183]=>
string(5) "28029"
[184]=>
string(5) "28030"
[185]=>
string(5) "28031"
[186]=>
string(5) "30729"
[187]=>
string(5) "30702"
[188]=>
string(5) "30013"
[189]=>
string(5) "30015"
[190]=>
string(5) "26591"
[191]=>
string(5) "13544"
[192]=>
string(5) "18780"
[193]=>
string(5) "12473"
[194]=>
string(5) "13547"
[195]=>
string(5) "17476"
[196]=>
string(5) "17570"
[197]=>
string(5) "12065"
[198]=>
string(5) "13546"
[199]=>
string(5) "17482"
[200]=>
string(5) "17574"
[201]=>
string(5) "23964"
[202]=>
string(5) "47593"
[203]=>
string(5) "12068"
[204]=>
string(5) "12470"
[205]=>
string(5) "17485"
[206]=>
string(5) "17580"
[207]=>
string(5) "23965"
[208]=>
string(5) "25760"
[209]=>
string(5) "35921"
[210]=>
string(5) "12069"
[211]=>
string(5) "12480"
[212]=>
string(5) "13543"
[213]=>
string(5) "17491"
[214]=>
string(5) "17584"
[215]=>
string(5) "23966"
[216]=>
string(5) "12070"
[217]=>
string(5) "12479"
[218]=>
string(5) "13864"
[219]=>
string(5) "17587"
[220]=>
string(5) "23967"
[221]=>
string(5) "12072"
[222]=>
string(5) "12218"
[223]=>
string(5) "12477"
[224]=>
string(5) "15034"
[225]=>
string(5) "17520"
[226]=>
string(5) "17590"
[227]=>
string(5) "23968"
[228]=>
string(5) "32477"
[229]=>
string(5) "12078"
[230]=>
string(5) "12256"
[231]=>
string(5) "12465"
[232]=>
string(5) "17523"
[233]=>
string(5) "17594"
[234]=>
string(5) "24036"
[235]=>
string(5) "32507"
[236]=>
string(5) "12016"
[237]=>
string(5) "12083"
[238]=>
string(5) "12267"
[239]=>
string(5) "12490"
[240]=>
string(5) "17526"
[241]=>
string(5) "17596"
[242]=>
string(5) "24032"
[243]=>
string(5) "30155"
[244]=>
string(5) "32509"
[245]=>
string(5) "12022"
[246]=>
string(5) "12094"
[247]=>
string(5) "12271"
[248]=>
string(5) "12657"
[249]=>
string(5) "17534"
[250]=>
string(5) "17690"
[251]=>
string(5) "24863"
[252]=>
string(5) "32510"
[253]=>
string(5) "12025"
[254]=>
string(5) "12097"
[255]=>
string(5) "12469"
[256]=>
string(5) "12610"
[257]=>
string(5) "16037"
[258]=>
string(5) "17535"
[259]=>
string(5) "17705"
[260]=>
string(5) "24896"
[261]=>
string(5) "13215"
[262]=>
string(5) "32513"
[263]=>
string(5) "12026"
[264]=>
string(5) "12098"
[265]=>
string(5) "12301"
[266]=>
string(5) "12875"
[267]=>
string(5) "16038"
[268]=>
string(5) "17538"
[269]=>
string(5) "18670"
[270]=>
string(5) "25527"
[271]=>
string(5) "27390"
[272]=>
string(5) "12027"
[273]=>
string(5) "12102"
[274]=>
string(5) "12876"
[275]=>
string(5) "16039"
[276]=>
string(5) "17543"
[277]=>
string(5) "27391"
[278]=>
string(5) "12028"
[279]=>
string(5) "12111"
[280]=>
string(5) "12314"
[281]=>
string(5) "12877"
[282]=>
string(5) "16248"
[283]=>
string(5) "17544"
[284]=>
string(5) "12029"
[285]=>
string(5) "12141"
[286]=>
string(5) "12315"
[287]=>
string(5) "12885"
[288]=>
string(5) "16257"
[289]=>
string(5) "17559"
[290]=>
string(5) "12031"
[291]=>
string(5) "12163"
[292]=>
string(5) "12464"
[293]=>
string(5) "13550"
[294]=>
string(5) "16259"
[295]=>
string(5) "17561"
[296]=>
string(5) "23667"
[297]=>
string(5) "12034"
[298]=>
string(5) "12376"
[299]=>
string(5) "13548"
[300]=>
string(5) "17567"
[301]=>
string(5) "23668"
[302]=>
string(5) "12040"
[303]=>
string(5) "12474"
[304]=>
string(5) "25976"
}
publicLeftJoin TEST FROM PC FIX
string(126) " LEFT JOIN tbl_artwork_multiple ON tbl_artwork_multiple.id_artwork=tbl_artwork.id AND tbl_artwork_multiple.premiere_dispo = 1 "