exhibitionPeriod
string(7) "Current"
searchCritea
array(1) {
[0]=>
array(3) {
["libele"]=>
string(10) "Artiste : "
["data"]=>
string(10) "Louis Joos"
["field"]=>
string(6) "artist"
}
}
Artwork_search
string(2420) " AND artist.id = 674 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 (30463,30465,30466,30485,30516,30517,30519,30520,30522,30530,30536,30550,30551,30555,30556,30558,30563,30573,30574,30575,30576,30578,30584,30587,30598,30606,30608,30612,30614,30618,30621,30624,30626,30627,30630,40964,41020,41027,46643,46644,46645,46646,46647,46648,46649,46650,46651,46652,46653,46654,46655,46656,46657,46658,46659,46663,46664,46665,46666,46667,46668,46669,46670,46671,46672,46673,46674,46675,46676,46685,46686,46687,46688,46689,46690,46691,46692,46693,46694,46695,46696,46697,46698,46699,46700,46701,46702,46703,46704,46705,46706,46707,46708,46709,46710,46711,46712,46713,46714,46715,46718,46719,46720,46721,46722,46723,46724,46725,46726,46727,46728,46729,46730,46731,46732,46733,46734,46735,46736,46737,46738,46739,46742,46743,46744,46745,46746,46747,46748,46749,46750,46751,46752,46753,46754,46755,46756,46758,46759,46760,46761,46762,46763,46764,46765,46766,46767,46768,46769,46770,46771,46772,46773,46774,46775,46776,46777,46778,46779,46780,46781,46782,46783,46784,46785,46786,46787,46788,46789,46790,46791,46792,46793,46795,46796,46798,46799,46800,46801,46802,46803,46804,46805,46806,46807,46808,46809,46810,46811,46812,46813,46814,46815,46816,46817,46818,46819,46820,46821,46822,46823,46824,46826,46827,46828,46829,46836,46837,46859,46860,46861,46862,46863,46866,46867,46868,46869,46870,46871,46872,46873,46874,46875,46876,46877,46878,46879,46880,46881,46882,46883,46884,46885,46886,46887,46889,46890,46891,46892,46893,46894,46895,46896,46897,46898,46899,46900,46901,46902,46903,46904,46905,46906,46907,46908,46909,46910,46911,46912,46913,46914,46915,46916,46917,46918,46919,46924,46925,46926,46927,46928,46929,46930,46931,46932,46933,46934,46935,46936,46937,46938,46939,46940,46941,46942,46943,46944,46945,46946,46947,46948,47017,47018,47019,47020,47021,47022,47023,47024,47025,47026,47027,47028,47036,47037,47038,47039,47040,47041,47042,47043,47044,47045,47046,47049,47050,47051,47052,47053,47054,47055,47056,47057,47058,47059,47060,47061,47062,47063,47064,47065,47066,47069,47070,47071,47073,47074,47076,47077,47078,47079,47080,47081,47082,47083,47084,47085,47086,47087,47088,47089,47090,47093,47111,47112,47134,47140) "
Artwork_sort
string(89) " ORDER BY artist.nom ASC,artist.prenom ASC, tbl_artwork.title ASC, tbl_artwork.year DESC "
sql_swipe
string(2894) "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 = 674 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 (30463,30465,30466,30485,30516,30517,30519,30520,30522,30530,30536,30550,30551,30555,30556,30558,30563,30573,30574,30575,30576,30578,30584,30587,30598,30606,30608,30612,30614,30618,30621,30624,30626,30627,30630,40964,41020,41027,46643,46644,46645,46646,46647,46648,46649,46650,46651,46652,46653,46654,46655,46656,46657,46658,46659,46663,46664,46665,46666,46667,46668,46669,46670,46671,46672,46673,46674,46675,46676,46685,46686,46687,46688,46689,46690,46691,46692,46693,46694,46695,46696,46697,46698,46699,46700,46701,46702,46703,46704,46705,46706,46707,46708,46709,46710,46711,46712,46713,46714,46715,46718,46719,46720,46721,46722,46723,46724,46725,46726,46727,46728,46729,46730,46731,46732,46733,46734,46735,46736,46737,46738,46739,46742,46743,46744,46745,46746,46747,46748,46749,46750,46751,46752,46753,46754,46755,46756,46758,46759,46760,46761,46762,46763,46764,46765,46766,46767,46768,46769,46770,46771,46772,46773,46774,46775,46776,46777,46778,46779,46780,46781,46782,46783,46784,46785,46786,46787,46788,46789,46790,46791,46792,46793,46795,46796,46798,46799,46800,46801,46802,46803,46804,46805,46806,46807,46808,46809,46810,46811,46812,46813,46814,46815,46816,46817,46818,46819,46820,46821,46822,46823,46824,46826,46827,46828,46829,46836,46837,46859,46860,46861,46862,46863,46866,46867,46868,46869,46870,46871,46872,46873,46874,46875,46876,46877,46878,46879,46880,46881,46882,46883,46884,46885,46886,46887,46889,46890,46891,46892,46893,46894,46895,46896,46897,46898,46899,46900,46901,46902,46903,46904,46905,46906,46907,46908,46909,46910,46911,46912,46913,46914,46915,46916,46917,46918,46919,46924,46925,46926,46927,46928,46929,46930,46931,46932,46933,46934,46935,46936,46937,46938,46939,46940,46941,46942,46943,46944,46945,46946,46947,46948,47017,47018,47019,47020,47021,47022,47023,47024,47025,47026,47027,47028,47036,47037,47038,47039,47040,47041,47042,47043,47044,47045,47046,47049,47050,47051,47052,47053,47054,47055,47056,47057,47058,47059,47060,47061,47062,47063,47064,47065,47066,47069,47070,47071,47073,47074,47076,47077,47078,47079,47080,47081,47082,47083,47084,47085,47086,47087,47088,47089,47090,47093,47111,47112,47134,47140) 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(8)
TOTAL PAGES
float(1)
sql
string(2887) "
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 = 674 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 (30463,30465,30466,30485,30516,30517,30519,30520,30522,30530,30536,30550,30551,30555,30556,30558,30563,30573,30574,30575,30576,30578,30584,30587,30598,30606,30608,30612,30614,30618,30621,30624,30626,30627,30630,40964,41020,41027,46643,46644,46645,46646,46647,46648,46649,46650,46651,46652,46653,46654,46655,46656,46657,46658,46659,46663,46664,46665,46666,46667,46668,46669,46670,46671,46672,46673,46674,46675,46676,46685,46686,46687,46688,46689,46690,46691,46692,46693,46694,46695,46696,46697,46698,46699,46700,46701,46702,46703,46704,46705,46706,46707,46708,46709,46710,46711,46712,46713,46714,46715,46718,46719,46720,46721,46722,46723,46724,46725,46726,46727,46728,46729,46730,46731,46732,46733,46734,46735,46736,46737,46738,46739,46742,46743,46744,46745,46746,46747,46748,46749,46750,46751,46752,46753,46754,46755,46756,46758,46759,46760,46761,46762,46763,46764,46765,46766,46767,46768,46769,46770,46771,46772,46773,46774,46775,46776,46777,46778,46779,46780,46781,46782,46783,46784,46785,46786,46787,46788,46789,46790,46791,46792,46793,46795,46796,46798,46799,46800,46801,46802,46803,46804,46805,46806,46807,46808,46809,46810,46811,46812,46813,46814,46815,46816,46817,46818,46819,46820,46821,46822,46823,46824,46826,46827,46828,46829,46836,46837,46859,46860,46861,46862,46863,46866,46867,46868,46869,46870,46871,46872,46873,46874,46875,46876,46877,46878,46879,46880,46881,46882,46883,46884,46885,46886,46887,46889,46890,46891,46892,46893,46894,46895,46896,46897,46898,46899,46900,46901,46902,46903,46904,46905,46906,46907,46908,46909,46910,46911,46912,46913,46914,46915,46916,46917,46918,46919,46924,46925,46926,46927,46928,46929,46930,46931,46932,46933,46934,46935,46936,46937,46938,46939,46940,46941,46942,46943,46944,46945,46946,46947,46948,47017,47018,47019,47020,47021,47022,47023,47024,47025,47026,47027,47028,47036,47037,47038,47039,47040,47041,47042,47043,47044,47045,47046,47049,47050,47051,47052,47053,47054,47055,47056,47057,47058,47059,47060,47061,47062,47063,47064,47065,47066,47069,47070,47071,47073,47074,47076,47077,47078,47079,47080,47081,47082,47083,47084,47085,47086,47087,47088,47089,47090,47093,47111,47112,47134,47140) 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) "fr"
["page"]=>
string(5) "store"
["view"]=>
string(6) "unique"
["id"]=>
int(0)
["name"]=>
string(28) "huberty-breyne-gallery-store"
["?paged"]=>
string(0) ""
["artist"]=>
string(14) "louis-joos-674"
}
exhib_search
string(0) ""
openFilter
bool(true)
artwork_ids
array(8) {
[0]=>
string(5) "18498"
[1]=>
string(5) "18512"
[2]=>
string(5) "18503"
[3]=>
string(5) "18495"
[4]=>
string(5) "18492"
[5]=>
string(5) "18490"
[6]=>
string(5) "18505"
[7]=>
string(5) "18497"
}
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 "
