exhibitionPeriod
string(7) "Current"
searchCritea
array(2) {
[0]=>
array(3) {
["libele"]=>
string(10) "Artiste : "
["data"]=>
string(15) "Philippe Geluck"
["field"]=>
string(6) "artist"
}
[1]=>
array(3) {
["libele"]=>
string(10) "Nouveautés"
["data"]=>
string(10) "Nouveautés"
["field"]=>
string(11) "new_artwork"
}
}
Artwork_search
string(1364) " AND artist.id = 135 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 (47290,47291,47295,47296,47299,51086,51087,51091,52401,52402,52403,52404,52405,52406,52407,52408,52409,52410,52683,52684,52719,52720,52721,52722,52723,52724,52725,52726,52727,52728,52729,52730,52731,52742,52743,52744,52745,52746,52747,52748,52749,52751,52752,52753,52754,52755,52756,52757,52758,52759,52760,52762,52763,52764,52765,52766,52767,52768,52769,52770,52777,52778,52779,52780,52781,52782,52783,52784,52785,52786,52787,52788,52789,52790,52791,52792,52793,52794,52795,52796,52797,52798,52799,52800,52801,52802,52803,52804,52805,52806,52807,52808,52809,52810,52811,52812,52813,52814,52815,52816,52817,52818,52819,52820,52821,52822,52823,52824,52825,52826,52827,52828,52833,52834,52835,52836,52837,52838,52839,52840,52841,52842,52843,52844,52847,52848,52849,52850,52851,52852,52853,52854,52855,52856,52857,52858,52859,52860,52861,52862,52863,52864,52865,52866,52867,52868,52869,52870,52871,52872,52873,52875,52876,52884,52885,52886,52887,52888,52889,52890,52891,52892,52893,52894,52895,52896,52897,52898,52899,52900,52901,52902,52903,52904,52905,52906,52907,52908,52909,53108,53109) "
Artwork_sort
string(42) " ORDER BY tbl_artwork.custom_field_8 DESC "
sql_swipe
string(1791) "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 = 135 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 (47290,47291,47295,47296,47299,51086,51087,51091,52401,52402,52403,52404,52405,52406,52407,52408,52409,52410,52683,52684,52719,52720,52721,52722,52723,52724,52725,52726,52727,52728,52729,52730,52731,52742,52743,52744,52745,52746,52747,52748,52749,52751,52752,52753,52754,52755,52756,52757,52758,52759,52760,52762,52763,52764,52765,52766,52767,52768,52769,52770,52777,52778,52779,52780,52781,52782,52783,52784,52785,52786,52787,52788,52789,52790,52791,52792,52793,52794,52795,52796,52797,52798,52799,52800,52801,52802,52803,52804,52805,52806,52807,52808,52809,52810,52811,52812,52813,52814,52815,52816,52817,52818,52819,52820,52821,52822,52823,52824,52825,52826,52827,52828,52833,52834,52835,52836,52837,52838,52839,52840,52841,52842,52843,52844,52847,52848,52849,52850,52851,52852,52853,52854,52855,52856,52857,52858,52859,52860,52861,52862,52863,52864,52865,52866,52867,52868,52869,52870,52871,52872,52873,52875,52876,52884,52885,52886,52887,52888,52889,52890,52891,52892,52893,52894,52895,52896,52897,52898,52899,52900,52901,52902,52903,52904,52905,52906,52907,52908,52909,53108,53109) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY tbl_artwork.custom_field_8 DESC "
TOTAL ITEM SQL
NULL
TOTAL ITEM
int(23)
TOTAL PAGES
float(2)
sql
string(1785) "
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 = 135 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 (47290,47291,47295,47296,47299,51086,51087,51091,52401,52402,52403,52404,52405,52406,52407,52408,52409,52410,52683,52684,52719,52720,52721,52722,52723,52724,52725,52726,52727,52728,52729,52730,52731,52742,52743,52744,52745,52746,52747,52748,52749,52751,52752,52753,52754,52755,52756,52757,52758,52759,52760,52762,52763,52764,52765,52766,52767,52768,52769,52770,52777,52778,52779,52780,52781,52782,52783,52784,52785,52786,52787,52788,52789,52790,52791,52792,52793,52794,52795,52796,52797,52798,52799,52800,52801,52802,52803,52804,52805,52806,52807,52808,52809,52810,52811,52812,52813,52814,52815,52816,52817,52818,52819,52820,52821,52822,52823,52824,52825,52826,52827,52828,52833,52834,52835,52836,52837,52838,52839,52840,52841,52842,52843,52844,52847,52848,52849,52850,52851,52852,52853,52854,52855,52856,52857,52858,52859,52860,52861,52862,52863,52864,52865,52866,52867,52868,52869,52870,52871,52872,52873,52875,52876,52884,52885,52886,52887,52888,52889,52890,52891,52892,52893,52894,52895,52896,52897,52898,52899,52900,52901,52902,52903,52904,52905,52906,52907,52908,52909,53108,53109) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY tbl_artwork.custom_field_8 DESC
LIMIT 16, 16"
POST
NULL
GET
array(8) {
["lang"]=>
string(2) "fr"
["page"]=>
string(5) "store"
["view"]=>
string(8) "editions"
["id"]=>
int(0)
["name"]=>
string(28) "huberty-breyne-gallery-store"
["?paged"]=>
string(0) ""
["artist"]=>
string(19) "philippe-geluck-135"
["paged"]=>
string(1) "2"
}
exhib_search
string(0) ""
openFilter
bool(true)
artwork_ids
array(23) {
[0]=>
string(5) "51475"
[1]=>
string(5) "51476"
[2]=>
string(5) "23756"
[3]=>
string(5) "48229"
[4]=>
string(5) "36044"
[5]=>
string(5) "36581"
[6]=>
string(5) "40381"
[7]=>
string(5) "34115"
[8]=>
string(5) "24896"
[9]=>
string(5) "13864"
[10]=>
string(5) "16248"
[11]=>
string(5) "16257"
[12]=>
string(5) "47593"
[13]=>
string(5) "16259"
[14]=>
string(5) "32507"
[15]=>
string(5) "32509"
[16]=>
string(5) "23667"
[17]=>
string(5) "23668"
[18]=>
string(5) "24863"
[19]=>
string(5) "32477"
[20]=>
string(5) "32510"
[21]=>
string(5) "32513"
[22]=>
string(5) "35921"
}
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 "