exhibitionPeriod
string(7) "Current"
searchCritea
array(2) {
[0]=>
array(3) {
["libele"]=>
string(8) "Artist: "
["data"]=>
string(12) "Denis Deprez"
["field"]=>
string(6) "artist"
}
[1]=>
array(3) {
["libele"]=>
string(12) "New artworks"
["data"]=>
string(12) "New artworks"
["field"]=>
string(11) "new_artwork"
}
}
Artwork_search
string(1567) " 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 (50130,50131,50132,50133,50134,50135,50136,50137,50138,50139,50140,50141,50142,50143,50144,50145,50146,50147,50148,50149,50150,50151,50152,50153,50154,50155,50156,50157,50158,50159,50160,50161,50162,50163,50164,50165,50166,50167,50168,50169,50170,50171,50172,50173,50174,50175,50176,50177,50217,50218,50219,50220,50221,50225,50292,50293,50294,50295,50296,50297,50298,50299,50300,50301,50303,50304,50305,50306,50307,50308,50309,50310,50312,50313,50314,50315,50316,50317,50318,50319,50320,50321,50322,50323,50324,50325,50326,50327,50328,50329,50330,50331,50332,50333,50334,50336,50337,50338,50339,50340,50341,50342,50343,50344,50345,50346,50347,50348,50349,50350,50351,50353,50354,50355,50356,50357,50358,50359,50360,50361,50362,50363,50364,50365,50366,50367,50368,50369,50370,50371,50372,50373,50374,50375,50376,50379,50382,50383,50385,50386,50387,50389,50391,50392,50393,50394,50395,50396,50397,50398,50399,50400,50401,50402,50403,50404,50405,50406,50407,50408,50409,50410,50411,50412,50413,50414,50415,50416,50417,50418,50419,50420,50421,50422,50423,50424,50425,50426,50427,50428,50429,50430,50431,50432,50433,50434,50435,50436,50437,50438,50473,50609,50613,50616,50620,50626,50627,50628,50629,50630,50631,50632,50880,50882,50883,50884,50885,50886,50887,50888,50889,50890,51062,51068,51075) "
Artwork_sort
string(42) " ORDER BY tbl_artwork.custom_field_8 DESC "
sql_swipe
string(1994) "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 (50130,50131,50132,50133,50134,50135,50136,50137,50138,50139,50140,50141,50142,50143,50144,50145,50146,50147,50148,50149,50150,50151,50152,50153,50154,50155,50156,50157,50158,50159,50160,50161,50162,50163,50164,50165,50166,50167,50168,50169,50170,50171,50172,50173,50174,50175,50176,50177,50217,50218,50219,50220,50221,50225,50292,50293,50294,50295,50296,50297,50298,50299,50300,50301,50303,50304,50305,50306,50307,50308,50309,50310,50312,50313,50314,50315,50316,50317,50318,50319,50320,50321,50322,50323,50324,50325,50326,50327,50328,50329,50330,50331,50332,50333,50334,50336,50337,50338,50339,50340,50341,50342,50343,50344,50345,50346,50347,50348,50349,50350,50351,50353,50354,50355,50356,50357,50358,50359,50360,50361,50362,50363,50364,50365,50366,50367,50368,50369,50370,50371,50372,50373,50374,50375,50376,50379,50382,50383,50385,50386,50387,50389,50391,50392,50393,50394,50395,50396,50397,50398,50399,50400,50401,50402,50403,50404,50405,50406,50407,50408,50409,50410,50411,50412,50413,50414,50415,50416,50417,50418,50419,50420,50421,50422,50423,50424,50425,50426,50427,50428,50429,50430,50431,50432,50433,50434,50435,50436,50437,50438,50473,50609,50613,50616,50620,50626,50627,50628,50629,50630,50631,50632,50880,50882,50883,50884,50885,50886,50887,50888,50889,50890,51062,51068,51075) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY tbl_artwork.custom_field_8 DESC "
TOTAL ITEM SQL
NULL
TOTAL ITEM
int(0)
TOTAL PAGES
float(0)
sql
string(1987) "
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 (50130,50131,50132,50133,50134,50135,50136,50137,50138,50139,50140,50141,50142,50143,50144,50145,50146,50147,50148,50149,50150,50151,50152,50153,50154,50155,50156,50157,50158,50159,50160,50161,50162,50163,50164,50165,50166,50167,50168,50169,50170,50171,50172,50173,50174,50175,50176,50177,50217,50218,50219,50220,50221,50225,50292,50293,50294,50295,50296,50297,50298,50299,50300,50301,50303,50304,50305,50306,50307,50308,50309,50310,50312,50313,50314,50315,50316,50317,50318,50319,50320,50321,50322,50323,50324,50325,50326,50327,50328,50329,50330,50331,50332,50333,50334,50336,50337,50338,50339,50340,50341,50342,50343,50344,50345,50346,50347,50348,50349,50350,50351,50353,50354,50355,50356,50357,50358,50359,50360,50361,50362,50363,50364,50365,50366,50367,50368,50369,50370,50371,50372,50373,50374,50375,50376,50379,50382,50383,50385,50386,50387,50389,50391,50392,50393,50394,50395,50396,50397,50398,50399,50400,50401,50402,50403,50404,50405,50406,50407,50408,50409,50410,50411,50412,50413,50414,50415,50416,50417,50418,50419,50420,50421,50422,50423,50424,50425,50426,50427,50428,50429,50430,50431,50432,50433,50434,50435,50436,50437,50438,50473,50609,50613,50616,50620,50626,50627,50628,50629,50630,50631,50632,50880,50882,50883,50884,50885,50886,50887,50888,50889,50890,51062,51068,51075) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY tbl_artwork.custom_field_8 DESC
LIMIT 0, 16"
POST
NULL
GET
array(7) {
["lang"]=>
string(2) "en"
["page"]=>
string(5) "store"
["view"]=>
string(8) "editions"
["id"]=>
int(0)
["name"]=>
string(29) "huberty-breyne-store-editions"
["?paged"]=>
string(0) ""
["artist"]=>
string(15) "denis-deprez-12"
}
exhib_search
string(0) ""
openFilter
bool(true)
artwork_ids
NULL
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 "