id_cat : 933
Ok Pi├Ęces SELECT c.`id_product`, p.`id_category_default` FROM `ps_category_product` c LEFT JOIN `ps_product` p ON (p.`id_product` = c.`id_product`) WHERE c.`id_category` = 933 AND p.`active` = 1
Array
(
    [0] => Array
        (
            [id_product] => 111
            [id_category_default] => 3
        )

    [1] => Array
        (
            [id_product] => 127
            [id_category_default] => 1263
        )

    [2] => Array
        (
            [id_product] => 183
            [id_category_default] => 355
        )

    [3] => Array
        (
            [id_product] => 184
            [id_category_default] => 355
        )

    [4] => Array
        (
            [id_product] => 292
            [id_category_default] => 355
        )

    [5] => Array
        (
            [id_product] => 293
            [id_category_default] => 355
        )

    [6] => Array
        (
            [id_product] => 294
            [id_category_default] => 355
        )

    [7] => Array
        (
            [id_product] => 295
            [id_category_default] => 355
        )

    [8] => Array
        (
            [id_product] => 437
            [id_category_default] => 355
        )

    [9] => Array
        (
            [id_product] => 498
            [id_category_default] => 355
        )

    [10] => Array
        (
            [id_product] => 500
            [id_category_default] => 355
        )

    [11] => Array
        (
            [id_product] => 554
            [id_category_default] => 355
        )

    [12] => Array
        (
            [id_product] => 847
            [id_category_default] => 355
        )

    [13] => Array
        (
            [id_product] => 848
            [id_category_default] => 355
        )

    [14] => Array
        (
            [id_product] => 849
            [id_category_default] => 355
        )

    [15] => Array
        (
            [id_product] => 1045
            [id_category_default] => 1364
        )

    [16] => Array
        (
            [id_product] => 1046
            [id_category_default] => 1364
        )

    [17] => Array
        (
            [id_product] => 1047
            [id_category_default] => 1364
        )

    [18] => Array
        (
            [id_product] => 1048
            [id_category_default] => 1364
        )

    [19] => Array
        (
            [id_product] => 1049
            [id_category_default] => 1364
        )

    [20] => Array
        (
            [id_product] => 1114
            [id_category_default] => 355
        )

    [21] => Array
        (
            [id_product] => 1152
            [id_category_default] => 355
        )

    [22] => Array
        (
            [id_product] => 1188
            [id_category_default] => 355
        )

    [23] => Array
        (
            [id_product] => 1245
            [id_category_default] => 355
        )

    [24] => Array
        (
            [id_product] => 1316
            [id_category_default] => 355
        )

    [25] => Array
        (
            [id_product] => 1403
            [id_category_default] => 355
        )

    [26] => Array
        (
            [id_product] => 1447
            [id_category_default] => 355
        )

    [27] => Array
        (
            [id_product] => 1505
            [id_category_default] => 355
        )

    [28] => Array
        (
            [id_product] => 1595
            [id_category_default] => 355
        )

    [29] => Array
        (
            [id_product] => 1882
            [id_category_default] => 1158
        )

    [30] => Array
        (
            [id_product] => 2217
            [id_category_default] => 3
        )

    [31] => Array
        (
            [id_product] => 2554
            [id_category_default] => 13
        )

    [32] => Array
        (
            [id_product] => 2715
            [id_category_default] => 13
        )

    [33] => Array
        (
            [id_product] => 2754
            [id_category_default] => 3
        )

    [34] => Array
        (
            [id_product] => 2755
            [id_category_default] => 3
        )

    [35] => Array
        (
            [id_product] => 2775
            [id_category_default] => 13
        )

    [36] => Array
        (
            [id_product] => 3272
            [id_category_default] => 3
        )

    [37] => Array
        (
            [id_product] => 3306
            [id_category_default] => 13
        )

    [38] => Array
        (
            [id_product] => 3354
            [id_category_default] => 13
        )

    [39] => Array
        (
            [id_product] => 3399
            [id_category_default] => 13
        )

    [40] => Array
        (
            [id_product] => 3443
            [id_category_default] => 13
        )

    [41] => Array
        (
            [id_product] => 3464
            [id_category_default] => 3
        )

    [42] => Array
        (
            [id_product] => 3615
            [id_category_default] => 1157
        )

    [43] => Array
        (
            [id_product] => 3619
            [id_category_default] => 13
        )

    [44] => Array
        (
            [id_product] => 3620
            [id_category_default] => 13
        )

    [45] => Array
        (
            [id_product] => 3621
            [id_category_default] => 13
        )

    [46] => Array
        (
            [id_product] => 3675
            [id_category_default] => 3
        )

    [47] => Array
        (
            [id_product] => 3683
            [id_category_default] => 13
        )

    [48] => Array
        (
            [id_product] => 3700
            [id_category_default] => 13
        )

    [49] => Array
        (
            [id_product] => 4253
            [id_category_default] => 3
        )

    [50] => Array
        (
            [id_product] => 4254
            [id_category_default] => 23
        )

    [51] => Array
        (
            [id_product] => 4255
            [id_category_default] => 3
        )

    [52] => Array
        (
            [id_product] => 4273
            [id_category_default] => 355
        )

    [53] => Array
        (
            [id_product] => 4318
            [id_category_default] => 1263
        )

    [54] => Array
        (
            [id_product] => 4399
            [id_category_default] => 13
        )

    [55] => Array
        (
            [id_product] => 4400
            [id_category_default] => 13
        )

    [56] => Array
        (
            [id_product] => 4587
            [id_category_default] => 13
        )

    [57] => Array
        (
            [id_product] => 4594
            [id_category_default] => 13
        )

    [58] => Array
        (
            [id_product] => 4726
            [id_category_default] => 355
        )

    [59] => Array
        (
            [id_product] => 4727
            [id_category_default] => 355
        )

    [60] => Array
        (
            [id_product] => 4799
            [id_category_default] => 13
        )

    [61] => Array
        (
            [id_product] => 4820
            [id_category_default] => 13
        )

    [62] => Array
        (
            [id_product] => 4862
            [id_category_default] => 13
        )

    [63] => Array
        (
            [id_product] => 4899
            [id_category_default] => 13
        )

    [64] => Array
        (
            [id_product] => 5045
            [id_category_default] => 3
        )

    [65] => Array
        (
            [id_product] => 5241
            [id_category_default] => 355
        )

    [66] => Array
        (
            [id_product] => 5267
            [id_category_default] => 23
        )

    [67] => Array
        (
            [id_product] => 5268
            [id_category_default] => 3
        )

    [68] => Array
        (
            [id_product] => 5340
            [id_category_default] => 13
        )

    [69] => Array
        (
            [id_product] => 5341
            [id_category_default] => 13
        )

    [70] => Array
        (
            [id_product] => 5427
            [id_category_default] => 13
        )

    [71] => Array
        (
            [id_product] => 5429
            [id_category_default] => 13
        )

    [72] => Array
        (
            [id_product] => 5685
            [id_category_default] => 355
        )

    [73] => Array
        (
            [id_product] => 5761
            [id_category_default] => 355
        )

    [74] => Array
        (
            [id_product] => 5764
            [id_category_default] => 355
        )

    [75] => Array
        (
            [id_product] => 5901
            [id_category_default] => 355
        )

    [76] => Array
        (
            [id_product] => 5902
            [id_category_default] => 355
        )

    [77] => Array
        (
            [id_product] => 6327
            [id_category_default] => 13
        )

    [78] => Array
        (
            [id_product] => 6577
            [id_category_default] => 3
        )

    [79] => Array
        (
            [id_product] => 6696
            [id_category_default] => 1263
        )

    [80] => Array
        (
            [id_product] => 6735
            [id_category_default] => 355
        )

    [81] => Array
        (
            [id_product] => 6954
            [id_category_default] => 23
        )

    [82] => Array
        (
            [id_product] => 6955
            [id_category_default] => 176
        )

    [83] => Array
        (
            [id_product] => 6958
            [id_category_default] => 25
        )

    [84] => Array
        (
            [id_product] => 6972
            [id_category_default] => 176
        )

    [85] => Array
        (
            [id_product] => 6977
            [id_category_default] => 3
        )

    [86] => Array
        (
            [id_product] => 6996
            [id_category_default] => 176
        )

    [87] => Array
        (
            [id_product] => 6997
            [id_category_default] => 176
        )

    [88] => Array
        (
            [id_product] => 7012
            [id_category_default] => 355
        )

    [89] => Array
        (
            [id_product] => 7013
            [id_category_default] => 355
        )

)