exhibitionPeriod
string(7) "Current"
searchCritea
array(1) {
[0]=>
array(3) {
["libele"]=>
string(8) "Artist: "
["data"]=>
string(12) "Denis Deprez"
["field"]=>
string(6) "artist"
}
}
Artwork_search
string(1285) " AND artist.id = 12 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 (47810,53264,53265,53266,53267,53268,53269,53270,53271,53272,53273,53274,53275,53276,53277,53278,53279,53280,53281,53283,53284,53285,53422,53423,53424,53425,53426,53427,53428,53429,53430,53431,53432,53433,53434,53435,53436,53437,53438,53439,53440,53441,53442,53443,53444,53445,53447,53448,53449,53450,53451,53452,53453,53454,53455,53456,53457,53542,53543,53544,53545,53546,53547,53548,53549,53551,53554,53556,53557,53558,53559,53560,53561,53562,53563,53564,53565,53566,53567,53568,53569,53570,53571,53572,53573,53574,53575,53576,53577,53578,53579,53580,53581,53582,53583,53584,53585,53586,53587,53588,53589,53590,53591,53592,53593,53594,53650,53651,53652,53653,53654,53655,53656,53657,53658,53659,53660,53661,53662,53663,53664,53665,53666,53667,53668,53669,53670,53671,53672,53673,53674,53676,53677,53678,53679,53680,53681,53682,53683,53684,53685,53707,53708,53709,53710,53711,53712,53713,53714,53715,53716,53717,53718,53719,53720,53721,53722,53723,53724,53725,53726,53838,53839,53840,53841,53842,53843,53918) "
Artwork_sort
string(89) " ORDER BY artist.nom ASC,artist.prenom ASC, tbl_artwork.title ASC, tbl_artwork.year DESC "
sql_swipe
string(1759) "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 = 12 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 (47810,53264,53265,53266,53267,53268,53269,53270,53271,53272,53273,53274,53275,53276,53277,53278,53279,53280,53281,53283,53284,53285,53422,53423,53424,53425,53426,53427,53428,53429,53430,53431,53432,53433,53434,53435,53436,53437,53438,53439,53440,53441,53442,53443,53444,53445,53447,53448,53449,53450,53451,53452,53453,53454,53455,53456,53457,53542,53543,53544,53545,53546,53547,53548,53549,53551,53554,53556,53557,53558,53559,53560,53561,53562,53563,53564,53565,53566,53567,53568,53569,53570,53571,53572,53573,53574,53575,53576,53577,53578,53579,53580,53581,53582,53583,53584,53585,53586,53587,53588,53589,53590,53591,53592,53593,53594,53650,53651,53652,53653,53654,53655,53656,53657,53658,53659,53660,53661,53662,53663,53664,53665,53666,53667,53668,53669,53670,53671,53672,53673,53674,53676,53677,53678,53679,53680,53681,53682,53683,53684,53685,53707,53708,53709,53710,53711,53712,53713,53714,53715,53716,53717,53718,53719,53720,53721,53722,53723,53724,53725,53726,53838,53839,53840,53841,53842,53843,53918) 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(17)
TOTAL PAGES
float(2)
sql
string(1753) "
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 = 12 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 (47810,53264,53265,53266,53267,53268,53269,53270,53271,53272,53273,53274,53275,53276,53277,53278,53279,53280,53281,53283,53284,53285,53422,53423,53424,53425,53426,53427,53428,53429,53430,53431,53432,53433,53434,53435,53436,53437,53438,53439,53440,53441,53442,53443,53444,53445,53447,53448,53449,53450,53451,53452,53453,53454,53455,53456,53457,53542,53543,53544,53545,53546,53547,53548,53549,53551,53554,53556,53557,53558,53559,53560,53561,53562,53563,53564,53565,53566,53567,53568,53569,53570,53571,53572,53573,53574,53575,53576,53577,53578,53579,53580,53581,53582,53583,53584,53585,53586,53587,53588,53589,53590,53591,53592,53593,53594,53650,53651,53652,53653,53654,53655,53656,53657,53658,53659,53660,53661,53662,53663,53664,53665,53666,53667,53668,53669,53670,53671,53672,53673,53674,53676,53677,53678,53679,53680,53681,53682,53683,53684,53685,53707,53708,53709,53710,53711,53712,53713,53714,53715,53716,53717,53718,53719,53720,53721,53722,53723,53724,53725,53726,53838,53839,53840,53841,53842,53843,53918) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY artist.nom ASC,artist.prenom ASC, tbl_artwork.title ASC, tbl_artwork.year DESC
LIMIT 16, 16"
POST
NULL
GET
array(8) {
["lang"]=>
string(2) "en"
["page"]=>
string(5) "store"
["view"]=>
string(6) "unique"
["id"]=>
int(0)
["name"]=>
string(29) "huberty-breyne-store-editions"
["?paged"]=>
string(0) ""
["artist"]=>
string(15) "denis-deprez-12"
["paged"]=>
string(1) "2"
}
exhib_search
string(0) ""
openFilter
bool(true)
artwork_ids
array(17) {
[0]=>
string(4) "4810"
[1]=>
string(5) "23312"
[2]=>
string(5) "23307"
[3]=>
string(5) "22504"
[4]=>
string(5) "23314"
[5]=>
string(4) "4802"
[6]=>
string(4) "3116"
[7]=>
string(4) "4803"
[8]=>
string(4) "3174"
[9]=>
string(5) "28741"
[10]=>
string(5) "30142"
[11]=>
string(5) "28752"
[12]=>
string(5) "22500"
[13]=>
string(5) "28910"
[14]=>
string(5) "24914"
[15]=>
string(5) "29286"
[16]=>
string(4) "3157"
}
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 "