exhibitionPeriod
string(7) "Current"
searchCritea
array(1) {
[0]=>
array(3) {
["libele"]=>
string(8) "Artist: "
["data"]=>
string(7) "Andreas"
["field"]=>
string(6) "artist"
}
}
Artwork_search
string(1249) " AND artist.id = 21 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 (1329,4653,4657,4663,4668,4670,4671,4673,5219,5222,5223,5226,12527,17856,19947,19954,21828,21914,21919,21922,21924,21926,21935,21937,21943,21945,21947,21952,21962,24288,24291,28645,28646,28647,31771,35839,35873,35880,35933,36039,46460,46462,47147,47149,47151,47166,47173,47177,47179,47289,47290,47291,47292,47293,47294,47295,47296,47297,47298,47299,47300,47301,47302,47303,47304,47305,47306,47417,47418,47419,47420,47421,47422,47423,47424,47425,47427,47428,47429,47430,47431,47432,47433,47434,47435,47436,47437,47438,47439,47440,47450,47451,47452,47453,47454,47455,47456,47457,47458,47459,47460,47461,47462,47463,47464,47465,47466,47467,47468,47469,47470,47471,47472,47473,47474,47475,47476,47477,47478,47479,47480,47481,47482,47483,47484,47485,47486,47487,47488,47489,47491,47492,47493,47494,47529,47530,47550,47551,47554,47555,47556,47557,47558,47559,47561,47564,47570,47571,47578,47584,47586,47588,47589,47591,47592,47593,47595,47597,47598,47611,47639,47668,47682,47683) "
Artwork_sort
string(89) " ORDER BY artist.nom ASC,artist.prenom ASC, tbl_artwork.title ASC, tbl_artwork.year DESC "
sql_swipe
string(1723) "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 = 21 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 (1329,4653,4657,4663,4668,4670,4671,4673,5219,5222,5223,5226,12527,17856,19947,19954,21828,21914,21919,21922,21924,21926,21935,21937,21943,21945,21947,21952,21962,24288,24291,28645,28646,28647,31771,35839,35873,35880,35933,36039,46460,46462,47147,47149,47151,47166,47173,47177,47179,47289,47290,47291,47292,47293,47294,47295,47296,47297,47298,47299,47300,47301,47302,47303,47304,47305,47306,47417,47418,47419,47420,47421,47422,47423,47424,47425,47427,47428,47429,47430,47431,47432,47433,47434,47435,47436,47437,47438,47439,47440,47450,47451,47452,47453,47454,47455,47456,47457,47458,47459,47460,47461,47462,47463,47464,47465,47466,47467,47468,47469,47470,47471,47472,47473,47474,47475,47476,47477,47478,47479,47480,47481,47482,47483,47484,47485,47486,47487,47488,47489,47491,47492,47493,47494,47529,47530,47550,47551,47554,47555,47556,47557,47558,47559,47561,47564,47570,47571,47578,47584,47586,47588,47589,47591,47592,47593,47595,47597,47598,47611,47639,47668,47682,47683) 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(21)
TOTAL PAGES
float(2)
sql
string(1716) "
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 = 21 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 (1329,4653,4657,4663,4668,4670,4671,4673,5219,5222,5223,5226,12527,17856,19947,19954,21828,21914,21919,21922,21924,21926,21935,21937,21943,21945,21947,21952,21962,24288,24291,28645,28646,28647,31771,35839,35873,35880,35933,36039,46460,46462,47147,47149,47151,47166,47173,47177,47179,47289,47290,47291,47292,47293,47294,47295,47296,47297,47298,47299,47300,47301,47302,47303,47304,47305,47306,47417,47418,47419,47420,47421,47422,47423,47424,47425,47427,47428,47429,47430,47431,47432,47433,47434,47435,47436,47437,47438,47439,47440,47450,47451,47452,47453,47454,47455,47456,47457,47458,47459,47460,47461,47462,47463,47464,47465,47466,47467,47468,47469,47470,47471,47472,47473,47474,47475,47476,47477,47478,47479,47480,47481,47482,47483,47484,47485,47486,47487,47488,47489,47491,47492,47493,47494,47529,47530,47550,47551,47554,47555,47556,47557,47558,47559,47561,47564,47570,47571,47578,47584,47586,47588,47589,47591,47592,47593,47595,47597,47598,47611,47639,47668,47682,47683) 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(10) "andreas-21"
}
exhib_search
string(0) ""
openFilter
bool(true)
artwork_ids
array(21) {
[0]=>
string(5) "37905"
[1]=>
string(5) "23680"
[2]=>
string(5) "14191"
[3]=>
string(5) "26076"
[4]=>
string(5) "16225"
[5]=>
string(5) "23654"
[6]=>
string(5) "26077"
[7]=>
string(5) "26068"
[8]=>
string(5) "12409"
[9]=>
string(5) "46843"
[10]=>
string(5) "23232"
[11]=>
string(5) "14366"
[12]=>
string(5) "21168"
[13]=>
string(5) "14640"
[14]=>
string(5) "26083"
[15]=>
string(5) "23674"
[16]=>
string(5) "29555"
[17]=>
string(5) "14182"
[18]=>
string(5) "26085"
[19]=>
string(5) "14386"
[20]=>
string(5) "26069"
}
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 "
