exhibitionPeriod
string(7) "Current"
searchCritea
array(1) {
[0]=>
array(3) {
["libele"]=>
string(8) "Artist: "
["data"]=>
string(19) "Christophe Chabouté"
["field"]=>
string(6) "artist"
}
}
Artwork_search
string(2964) " AND artist.id = 68 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 (2617,11484,13051,13393,15141,15509,18505,18509,18583,20778,25720,25721,26591,26975,30387,30409,30439,36831,36905,36959,37765,42156,42157,42158,42159,42261,42262,42263,42462,42463,42464,42711,42819,42843,42844,42845,42849,42875,42876,42877,42878,42879,42884,42902,42924,42948,43071,43072,43073,43074,43075,43076,43251,43252,43324,43325,43326,43328,43329,43330,43331,43332,43333,43469,43497,43500,43501,43502,43505,43521,43560,43562,43568,43575,43576,43577,43578,43579,43580,43581,43641,43711,43726,43728,43755,43907,43908,43909,43910,43911,43912,43913,43914,43915,43916,43917,43918,43919,43920,43921,43922,43923,43924,43925,43926,43927,43928,43929,43930,43931,43932,43933,43936,43937,43938,43939,43940,44025,44026,44027,44028,44029,44030,44031,44032,44033,44034,44035,44036,44037,44038,44039,44040,44041,44042,44043,44044,44045,44046,44047,44048,44049,44050,44051,44052,44053,44054,44055,44056,44057,44058,44059,44060,44061,44062,44063,44064,44065,44066,44067,44068,44069,44070,44071,44072,44073,44074,44075,44076,44077,44078,44079,44080,44081,44082,44083,44084,44085,44086,44087,44090,44094,44095,44096,44097,44098,44099,44100,44101,44102,44103,44104,44105,44106,44107,44108,44109,44110,44111,44112,44113,44114,44115,44116,44117,44118,44119,44120,44121,44123,44124,44125,44126,44127,44128,44129,44130,44131,44132,44133,44134,44135,44136,44137,44138,44139,44140,44142,44143,44144,44145,44158,44160,44161,44162,44175,44176,44177,44178,44179,44180,44181,44182,44183,44184,44185,44186,44187,44188,44189,44190,44191,44192,44193,44194,44201,44202,44203,44204,44205,44207,44208,44209,44210,44212,44213,44339,44341,44342,44343,44344,44345,44346,44347,44348,44349,44350,44351,44352,44356,44357,44358,44359,44360,44361,44362,44363,44364,44365,44366,44367,44368,44369,44370,44371,44372,44373,44374,44375,44376,44377,44378,44379,44380,44381,44382,44383,44385,44387,44388,44391,44392,44396,44397,44398,44399,44400,44401,44402,44403,44404,44405,44406,44407,44408,44409,44410,44411,44412,44413,44414,44415,44416,44417,44418,44419,44420,44421,44422,44423,44424,44425,44426,44427,44428,44429,44430,44431,44432,44433,44434,44435,44436,44437,44438,44440,44441,44442,44443,44444,44445,44446,44447,44448,44449,44450,44451,44452,44453,44495,44498,44499,44501,44502,44503,44505,44506,44507,44508,44514,44515,44560,44580,44581,44582,44583,44584,44585,44586,44587,44588,44589,44590,44591,44592,44593,44594,44595,44596,44677,44696,44697,44698,44699,44700,44701,44702,44704,44706,44707,44710,44711,44712,44713,44714,44715,44716,44717,44718,44719,44720,44721,44722,44723,44724,44725,44795,44797,44798,44799,44800,44801,44802,44803,44804,44805,44806,44807,44808,44809,44810,44811,44812,44813,44814,44815,44816,44817) "
Artwork_sort
string(89) " ORDER BY artist.nom ASC,artist.prenom ASC, tbl_artwork.title ASC, tbl_artwork.year DESC "
sql_swipe
string(3438) "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 artist.id = 68 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 (2617,11484,13051,13393,15141,15509,18505,18509,18583,20778,25720,25721,26591,26975,30387,30409,30439,36831,36905,36959,37765,42156,42157,42158,42159,42261,42262,42263,42462,42463,42464,42711,42819,42843,42844,42845,42849,42875,42876,42877,42878,42879,42884,42902,42924,42948,43071,43072,43073,43074,43075,43076,43251,43252,43324,43325,43326,43328,43329,43330,43331,43332,43333,43469,43497,43500,43501,43502,43505,43521,43560,43562,43568,43575,43576,43577,43578,43579,43580,43581,43641,43711,43726,43728,43755,43907,43908,43909,43910,43911,43912,43913,43914,43915,43916,43917,43918,43919,43920,43921,43922,43923,43924,43925,43926,43927,43928,43929,43930,43931,43932,43933,43936,43937,43938,43939,43940,44025,44026,44027,44028,44029,44030,44031,44032,44033,44034,44035,44036,44037,44038,44039,44040,44041,44042,44043,44044,44045,44046,44047,44048,44049,44050,44051,44052,44053,44054,44055,44056,44057,44058,44059,44060,44061,44062,44063,44064,44065,44066,44067,44068,44069,44070,44071,44072,44073,44074,44075,44076,44077,44078,44079,44080,44081,44082,44083,44084,44085,44086,44087,44090,44094,44095,44096,44097,44098,44099,44100,44101,44102,44103,44104,44105,44106,44107,44108,44109,44110,44111,44112,44113,44114,44115,44116,44117,44118,44119,44120,44121,44123,44124,44125,44126,44127,44128,44129,44130,44131,44132,44133,44134,44135,44136,44137,44138,44139,44140,44142,44143,44144,44145,44158,44160,44161,44162,44175,44176,44177,44178,44179,44180,44181,44182,44183,44184,44185,44186,44187,44188,44189,44190,44191,44192,44193,44194,44201,44202,44203,44204,44205,44207,44208,44209,44210,44212,44213,44339,44341,44342,44343,44344,44345,44346,44347,44348,44349,44350,44351,44352,44356,44357,44358,44359,44360,44361,44362,44363,44364,44365,44366,44367,44368,44369,44370,44371,44372,44373,44374,44375,44376,44377,44378,44379,44380,44381,44382,44383,44385,44387,44388,44391,44392,44396,44397,44398,44399,44400,44401,44402,44403,44404,44405,44406,44407,44408,44409,44410,44411,44412,44413,44414,44415,44416,44417,44418,44419,44420,44421,44422,44423,44424,44425,44426,44427,44428,44429,44430,44431,44432,44433,44434,44435,44436,44437,44438,44440,44441,44442,44443,44444,44445,44446,44447,44448,44449,44450,44451,44452,44453,44495,44498,44499,44501,44502,44503,44505,44506,44507,44508,44514,44515,44560,44580,44581,44582,44583,44584,44585,44586,44587,44588,44589,44590,44591,44592,44593,44594,44595,44596,44677,44696,44697,44698,44699,44700,44701,44702,44704,44706,44707,44710,44711,44712,44713,44714,44715,44716,44717,44718,44719,44720,44721,44722,44723,44724,44725,44795,44797,44798,44799,44800,44801,44802,44803,44804,44805,44806,44807,44808,44809,44810,44811,44812,44813,44814,44815,44816,44817) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY artist.nom ASC,artist.prenom ASC, tbl_artwork.title ASC, tbl_artwork.year DESC "
TOTAL ITEM SQL
NULL
TOTAL ITEM
int(33)
TOTAL PAGES
float(3)
sql
string(3431) "
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 artist.id = 68 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 (2617,11484,13051,13393,15141,15509,18505,18509,18583,20778,25720,25721,26591,26975,30387,30409,30439,36831,36905,36959,37765,42156,42157,42158,42159,42261,42262,42263,42462,42463,42464,42711,42819,42843,42844,42845,42849,42875,42876,42877,42878,42879,42884,42902,42924,42948,43071,43072,43073,43074,43075,43076,43251,43252,43324,43325,43326,43328,43329,43330,43331,43332,43333,43469,43497,43500,43501,43502,43505,43521,43560,43562,43568,43575,43576,43577,43578,43579,43580,43581,43641,43711,43726,43728,43755,43907,43908,43909,43910,43911,43912,43913,43914,43915,43916,43917,43918,43919,43920,43921,43922,43923,43924,43925,43926,43927,43928,43929,43930,43931,43932,43933,43936,43937,43938,43939,43940,44025,44026,44027,44028,44029,44030,44031,44032,44033,44034,44035,44036,44037,44038,44039,44040,44041,44042,44043,44044,44045,44046,44047,44048,44049,44050,44051,44052,44053,44054,44055,44056,44057,44058,44059,44060,44061,44062,44063,44064,44065,44066,44067,44068,44069,44070,44071,44072,44073,44074,44075,44076,44077,44078,44079,44080,44081,44082,44083,44084,44085,44086,44087,44090,44094,44095,44096,44097,44098,44099,44100,44101,44102,44103,44104,44105,44106,44107,44108,44109,44110,44111,44112,44113,44114,44115,44116,44117,44118,44119,44120,44121,44123,44124,44125,44126,44127,44128,44129,44130,44131,44132,44133,44134,44135,44136,44137,44138,44139,44140,44142,44143,44144,44145,44158,44160,44161,44162,44175,44176,44177,44178,44179,44180,44181,44182,44183,44184,44185,44186,44187,44188,44189,44190,44191,44192,44193,44194,44201,44202,44203,44204,44205,44207,44208,44209,44210,44212,44213,44339,44341,44342,44343,44344,44345,44346,44347,44348,44349,44350,44351,44352,44356,44357,44358,44359,44360,44361,44362,44363,44364,44365,44366,44367,44368,44369,44370,44371,44372,44373,44374,44375,44376,44377,44378,44379,44380,44381,44382,44383,44385,44387,44388,44391,44392,44396,44397,44398,44399,44400,44401,44402,44403,44404,44405,44406,44407,44408,44409,44410,44411,44412,44413,44414,44415,44416,44417,44418,44419,44420,44421,44422,44423,44424,44425,44426,44427,44428,44429,44430,44431,44432,44433,44434,44435,44436,44437,44438,44440,44441,44442,44443,44444,44445,44446,44447,44448,44449,44450,44451,44452,44453,44495,44498,44499,44501,44502,44503,44505,44506,44507,44508,44514,44515,44560,44580,44581,44582,44583,44584,44585,44586,44587,44588,44589,44590,44591,44592,44593,44594,44595,44596,44677,44696,44697,44698,44699,44700,44701,44702,44704,44706,44707,44710,44711,44712,44713,44714,44715,44716,44717,44718,44719,44720,44721,44722,44723,44724,44725,44795,44797,44798,44799,44800,44801,44802,44803,44804,44805,44806,44807,44808,44809,44810,44811,44812,44813,44814,44815,44816,44817) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY artist.nom ASC,artist.prenom ASC, tbl_artwork.title ASC, tbl_artwork.year DESC
LIMIT 0, 16"
POST
NULL
GET
array(7) {
["lang"]=>
string(2) "en"
["page"]=>
string(5) "store"
["view"]=>
string(6) "unique"
["id"]=>
int(0)
["name"]=>
string(20) "huberty-breyne-store"
["?paged"]=>
string(0) ""
["artist"]=>
string(22) "christophe-chaboute-68"
}
exhib_search
string(0) ""
openFilter
bool(true)
artwork_ids
array(33) {
[0]=>
string(4) "7368"
[1]=>
string(5) "34105"
[2]=>
string(5) "26360"
[3]=>
string(5) "16459"
[4]=>
string(5) "16457"
[5]=>
string(3) "743"
[6]=>
string(3) "745"
[7]=>
string(5) "26361"
[8]=>
string(5) "31139"
[9]=>
string(5) "31844"
[10]=>
string(5) "31855"
[11]=>
string(5) "31857"
[12]=>
string(5) "24299"
[13]=>
string(5) "31094"
[14]=>
string(3) "764"
[15]=>
string(3) "767"
[16]=>
string(5) "23600"
[17]=>
string(3) "217"
[18]=>
string(3) "766"
[19]=>
string(3) "755"
[20]=>
string(3) "784"
[21]=>
string(3) "854"
[22]=>
string(5) "25468"
[23]=>
string(5) "32523"
[24]=>
string(5) "34093"
[25]=>
string(5) "29550"
[26]=>
string(5) "36744"
[27]=>
string(5) "25445"
[28]=>
string(5) "31858"
[29]=>
string(5) "25501"
[30]=>
string(5) "13145"
[31]=>
string(5) "30944"
[32]=>
string(5) "25467"
}
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 "
