exhibitionPeriod
string(7) "Current"
searchCritea
array(2) {
[0]=>
array(3) {
["libele"]=>
string(8) "Artist: "
["data"]=>
string(12) "Alex Varenne"
["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(1328) " AND artist.id = 311 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 (53067,53068,53069,53070,53071,53072,53073,53074,53075,53076,53077,53078,53079,53080,53081,53082,53083,53084,53085,53086,53087,53088,53089,53090,53091,53092,53093,53094,53095,53096,53097,53098,53099,53100,53101,53102,53103,53104,53105,53106,53107,53112,53113,53114,53115,53116,53117,53118,53119,53120,53121,53122,53123,53124,53125,53126,53127,53128,53129,53130,53131,53132,53133,53134,53135,53136,53137,53138,53139,53140,53141,53142,53143,53144,53145,53146,53147,53148,53149,53150,53151,53152,53153,53154,53155,53156,53157,53158,53159,53160,53161,53163,53164,53165,53166,53167,53168,53169,53170,53171,53172,53173,53174,53175,53176,53177,53178,53179,53180,53181,53182,53183,53184,53185,53186,53188,53189,53190,53191,53192,53193,53194,53195,53196,53197,53198,53199,53200,53201,53202,53203,53204,53205,53206,53207,53208,53209,53210,53211,53212,53213,53214,53215,53216,53217,53218,53219,53220,53221,53222,53223,53224,53225,53226,53227,53228,53229,53230,53231,53232,53233,53234,53235,53236,53237,53238,53239,53240,53241,53242,53243,53244,53245,53246,53247) "
Artwork_sort
string(42) " ORDER BY tbl_artwork.custom_field_8 DESC "
sql_swipe
string(1755) "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 = 311 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 (53067,53068,53069,53070,53071,53072,53073,53074,53075,53076,53077,53078,53079,53080,53081,53082,53083,53084,53085,53086,53087,53088,53089,53090,53091,53092,53093,53094,53095,53096,53097,53098,53099,53100,53101,53102,53103,53104,53105,53106,53107,53112,53113,53114,53115,53116,53117,53118,53119,53120,53121,53122,53123,53124,53125,53126,53127,53128,53129,53130,53131,53132,53133,53134,53135,53136,53137,53138,53139,53140,53141,53142,53143,53144,53145,53146,53147,53148,53149,53150,53151,53152,53153,53154,53155,53156,53157,53158,53159,53160,53161,53163,53164,53165,53166,53167,53168,53169,53170,53171,53172,53173,53174,53175,53176,53177,53178,53179,53180,53181,53182,53183,53184,53185,53186,53188,53189,53190,53191,53192,53193,53194,53195,53196,53197,53198,53199,53200,53201,53202,53203,53204,53205,53206,53207,53208,53209,53210,53211,53212,53213,53214,53215,53216,53217,53218,53219,53220,53221,53222,53223,53224,53225,53226,53227,53228,53229,53230,53231,53232,53233,53234,53235,53236,53237,53238,53239,53240,53241,53242,53243,53244,53245,53246,53247) 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(1748) "
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 = 311 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 (53067,53068,53069,53070,53071,53072,53073,53074,53075,53076,53077,53078,53079,53080,53081,53082,53083,53084,53085,53086,53087,53088,53089,53090,53091,53092,53093,53094,53095,53096,53097,53098,53099,53100,53101,53102,53103,53104,53105,53106,53107,53112,53113,53114,53115,53116,53117,53118,53119,53120,53121,53122,53123,53124,53125,53126,53127,53128,53129,53130,53131,53132,53133,53134,53135,53136,53137,53138,53139,53140,53141,53142,53143,53144,53145,53146,53147,53148,53149,53150,53151,53152,53153,53154,53155,53156,53157,53158,53159,53160,53161,53163,53164,53165,53166,53167,53168,53169,53170,53171,53172,53173,53174,53175,53176,53177,53178,53179,53180,53181,53182,53183,53184,53185,53186,53188,53189,53190,53191,53192,53193,53194,53195,53196,53197,53198,53199,53200,53201,53202,53203,53204,53205,53206,53207,53208,53209,53210,53211,53212,53213,53214,53215,53216,53217,53218,53219,53220,53221,53222,53223,53224,53225,53226,53227,53228,53229,53230,53231,53232,53233,53234,53235,53236,53237,53238,53239,53240,53241,53242,53243,53244,53245,53246,53247) 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(16) "alex-varenne-311"
}
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 "